Tags: BI Publisher, SQL Query SQL Query to find the mapping between Business Unit and Reference Data Set
In this article, we will fetch the mapping between Business Units and Reference Data Sets.
SQL Query:
SELECT HAUFT.NAME AS BU_CODE, HAUFT.NAME AS BU_DESCRIPTION, HOUCF.LEGISLATION_CODE AS COUNTRY, TO_CHAR(HAUFT.EFFECTIVE_START_DATE, 'YYYY/MM/DD') AS EFFECTIVE_START_DATE, TO_CHAR(HAUFT.EFFECTIVE_END_DATE, 'YYYY/MM/DD') AS EFFECTIVE_END_DATE, HOUCF.STATUS AS STATUS, FS.SET_CODE AS SET_CODE, FS.SET_NAME AS SET_NAME, HAUFT.LAST_UPDATED_BY AS LAST_UPDATED_BY, TO_CHAR(HAUFT.LAST_UPDATE_DATE, 'YYYY/MM/DD') AS LAST_UPDATE_DATE FROM HR_ORG_UNIT_CLASSIFICATIONS_F HOUCF, HR_ALL_ORGANIZATION_UNITS_F HAOUF, HR_ORGANIZATION_UNITS_F_TL HAUFT, HR_ORGANIZATION_INFORMATION_F HOIF, FND_SETID_SETS_VL FS WHERE HAOUF.ORGANIZATION_ID = HOUCF.ORGANIZATION_ID AND HAOUF.ORGANIZATION_ID = HAUFT.ORGANIZATION_ID AND HAOUF.ORGANIZATION_ID = HOIF.ORGANIZATION_ID AND HAOUF.EFFECTIVE_START_DATE BETWEEN HOUCF.EFFECTIVE_START_DATE AND HOUCF.EFFECTIVE_END_DATE AND HAUFT.LANGUAGE = 'US' AND HAUFT.EFFECTIVE_START_DATE = HAOUF.EFFECTIVE_START_DATE AND HAUFT.EFFECTIVE_END_DATE = HAOUF.EFFECTIVE_END_DATE AND FS.SET_ID(+) = HOIF.ORG_INFORMATION4 AND HOUCF.CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT' If you like the content, please follow us on LinkedIn, Facebook, and Twitter to get updated with the latest content.
Read more articles
Previous PostSQL Query to fetch the Learner Course Progress Report Next PostSQL Query to fetch Delivery Option details for HCM Extracts
You Might Also Like
How to fetch the changes since the last scheduled run for the BI Report?
November 6, 2023
How to fetch Payslip XML from backend tables for a specific Pay Period
October 6, 2023
How to deal with Datetimes stored in Database as UTC timezone?
February 4, 2021
Leave a Reply Cancel reply
CommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional)
Save my name, email, and website in this browser for the next time I comment.
Search Knowledgebase
Search Generic filters Exact matches only Search in title Search in content Search in excerpt Advertisements
VIP Membership Plans
Advertisements Advertisements Advertisements
Recent Posts
SQL query to pull Payroll Run Results for employees with multiple assignments?
How to get the return value of Table Valueset in FF from SQL Query?
Advanced Edit not available for HCM Extracts from 24D
How to get the count of data loaded using HDL for business objects?
How do we extract the Grade Ladder step rates?
How do we reduce RTF template size when many images exist in the template?
How to find the Lookup Type for an attribute that supports HDL load?
How to modify the reports/value sets for Payroll table changes in 24A?
What is a Progression Grade Ladder and how to load it using HDL?
How to resolve “Template type etext is not yet supported” error for BI Report?
Advertisements
Tag Cloud
Alerts Approvals Audit BI Publisher Bursting Calculation Cards content server Data Disposal Data Scrambling EL Expressions ERD etext Fast Formula Flexfields Functional General HCM Data Loader HCM Extract Helpful Tools Interview Questions Latest Features LBAC Lookup Migration Notifications Offer Letter OTBI Analytics Payroll Payroll Batch Loader Payroll Flow Performance Management Personalizations Profile Options REST Services Scheduled Processes Security SOAP Services SQL Query Tables Templates Transformation Formula UDT Valueset VIP Content Web Services Advertisements
Archives
Archives Select Month October 2025 (1) December 2024 (2) May 2024 (2) April 2024 (1) March 2024 (4) February 2024 (1) December 2023 (1) November 2023 (5) October 2023 (2) August 2023 (2) July 2023 (21) June 2023 (8) May 2023 (11) April 2023 (5) March 2023 (1) February 2023 (7) January 2023 (1) December 2022 (5) November 2022 (8) October 2022 (7) September 2022 (1) June 2022 (10) May 2022 (2) April 2022 (2) March 2022 (6) February 2022 (1) January 2022 (5) December 2021 (18) November 2021 (3) October 2021 (8) September 2021 (13) August 2021 (10) July 2021 (14) June 2021 (11) May 2021 (9) April 2021 (15) March 2021 (6) February 2021 (14) January 2021 (3) December 2020 (7) November 2020 (10) October 2020 (6) September 2020 (9) August 2020 (13) July 2020 (16) June 2020 (28) May 2020 (37) April 2020 (35) May 2019 (2) April 2019 (2) March 2019 (5) February 2019 (4) January 2019 (24) Advertisements Close Menu Menu
Home
VIP Access
Log In
Manage VIP Account
Register for VIP Plan
VIP Member-Only Content
Blog
About Us
Technical
HCM Data Loader
HCM Extract
BI Publisher
Fast Formula
Security
OTBI Analytics
Personalizations
Scheduled Processes
Functional
Core HR
Absence Management
Payroll
Benefits
Performance Management
Talent Management
Time & Labor
Helpdesk
Learning
Recruiting
Onboarding
Interview Tips
HCM Extracts Questions
HCM Data Loader Questions
BI Reports Questions
Log In
Search Generic filters Exact matches only Search in title Search in content Search in excerpt
SQL Query to find the mapping between Business Unit and Reference Data Set 
Advertisements Advertisements Advertisements