FUN_MO_RPTING_ENTITIES_SCD_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
REPORTING_LEVEL ENTITY_NAME ENTITY_ID OPERATING_UNIT_ID LEGAL_ENTITY_ID SET_OF_BOOKS_ID BU_ID

Query

SQL_Statement

SELECT '1000' reporting_level , sob.name entity_name , to_number(sob.set_of_books_id) entity_id , -9999 operating_unit_id , -9999 legal_entity_id , TO_CHAR(ou.org_information3) set_of_books_id, ou.organization_id bu_id FROM hr_organization_information ou, gl_sets_of_books sob WHERE sob.set_of_books_id = DECODE(LTRIM(ou.org_information3, '0123456789'), NULL, ou.org_information3, NULL) AND ou.org_information_context = 'FUN_BUSINESS_UNIT' AND EXISTS (SELECT 1 FROM mo_glob_org_access_tmp mg WHERE mg.organization_id = ou.organization_id ) UNION ALL SELECT '2000' reporting_level , legal_entity_name entity_name , to_number(legal_entity_id) entity_id , -9999 operating_unit_id , to_number(legal_entity_id) legal_entity_id, TO_CHAR(primary_ledger_id) set_books_id , bu_id FROM FUN_NAMES_BUSINESS_UNITS_V bu WHERE EXISTS (SELECT 1 FROM mo_glob_org_access_tmp mg WHERE mg.organization_id = bu.bu_id) UNION ALL SELECT '3000' reporting_level , bu_name entity_name , bu_id entity_id , bu_id operating_unit_id , to_number(legal_entity_id) legal_entity_id, primary_ledger_id set_of_books_id , bu_id FROM FUN_ALL_BUSINESS_UNITS_V bu WHERE legal_entity_id IS NOT NULL AND EXISTS (SELECT 1 FROM mo_glob_org_access_tmp mg WHERE mg.organization_id = bu.bu_id )