PER_TAX_REPORTING_UNITS

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
ESTABLISHMENT_ID ORGANIZATION_ID EFFECTIVE_FROM EFFECTIVE_TO ESTAB_NAME MAIN_ESTABLISHMENT_FLAG PARENT_PSU_ORG_ID PARENT_PSU_NAME ENTERPRISE_ID

Query

SQL_Statement

SELECT ESTABLISHMENT.ESTABLISHMENT_ID, ORG_UNIT_ESTAB.ORGANIZATION_ID, ESTABLISHMENT.EFFECTIVE_FROM, ESTABLISHMENT.EFFECTIVE_TO, ESTABLISHMENT.NAME ESTAB_NAME, ESTABLISHMENT.MAIN_ESTABLISHMENT_FLAG, ORG_UNIT_PSU.ORGANIZATION_ID PARENT_PSU_ORG_ID, XLE_LE.NAME PARENT_PSU_NAME, XLE_LE.ENTERPRISE_ID ENTERPRISE_ID FROM XLE_ETB_PROFILES ESTABLISHMENT, HR_ALL_ORGANIZATION_UNITS_F_VL ORG_UNIT_ESTAB, HR_ORG_UNIT_CLASSIFICATIONS_F ORG_CLASS_ESTAB, XLE_ENTITY_PROFILES XLE_LE, HR_ALL_ORGANIZATION_UNITS_F_VL ORG_UNIT_PSU, HR_ORG_UNIT_CLASSIFICATIONS_F ORG_CLASS_PSU WHERE ESTABLISHMENT.ESTABLISHMENT_ID = ORG_UNIT_ESTAB.ESTABLISHMENT_ID AND ORG_UNIT_ESTAB.ORGANIZATION_ID = ORG_CLASS_ESTAB.ORGANIZATION_ID AND TRUNC(SYSDATE) BETWEEN ORG_CLASS_ESTAB.EFFECTIVE_START_DATE AND ORG_CLASS_ESTAB.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN ORG_UNIT_ESTAB.EFFECTIVE_START_DATE AND ORG_UNIT_ESTAB.EFFECTIVE_END_DATE AND ORG_CLASS_ESTAB.CLASSIFICATION_CODE = 'HCM_TRU' AND XLE_LE.LEGAL_ENTITY_ID = ESTABLISHMENT.LEGAL_ENTITY_ID AND ORG_UNIT_PSU.LEGAL_ENTITY_ID = NVL(XLE_LE.PARENT_PSU_ID,XLE_LE.LEGAL_ENTITY_ID) AND ORG_UNIT_PSU.ORGANIZATION_ID = ORG_CLASS_PSU.ORGANIZATION_ID AND TRUNC(SYSDATE) BETWEEN ORG_CLASS_PSU.EFFECTIVE_START_DATE AND ORG_CLASS_PSU.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN ORG_UNIT_PSU.EFFECTIVE_START_DATE AND ORG_UNIT_PSU.EFFECTIVE_END_DATE AND ORG_CLASS_PSU.CLASSIFICATION_CODE = 'HCM_PSU' AND XLE_LE.PSU_FLAG = 'Y'