View: EDWBV_ORGA_TREE1_LVL4_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ '4-' || TREE.ORGANIZATION_ID || '-' || INST.INSTANCE_CODE ORG_TREE1_LVL4_PK
, LVL5.ORG_TREE1_LVL5_PK ORG_TREE1_LVL5_FK
, INST.INSTANCE_CODE INSTANCE
, ORG.NAME || '(' || BGR.NAME || ')' NAME
, ORG.NAME || '(' || BGR.NAME || ')' PRIMARY_ORG_DP
, BGR.NAME BUSINESS_GROUP
, TREE.ORGANIZATION_ID ORGANIZATION_ID
, GREATEST( NVL( ORG.LAST_UPDATE_DATE
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))
, NVL(TREE.ORG_LAST_UPDATED
, TO_DATE('01-01-2000'
, 'DD-MM-YYYY'))) LAST_UPDATE_DATE
, ORG.CREATION_DATE CREATION_DATE
FROM HR_ALL_ORGANIZATION_UNITS BGR
, HR_ALL_ORGANIZATION_UNITS ORG
, HRI_PRIMARY_HRCHYS TREE
, EDW_ORGA_TREE1_LVL5_LCV LVL5
, EDW_LOCAL_INSTANCE INST
WHERE TREE.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND TREE.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND TREE.PARENT_ORGANIZATION_ID = LVL5.ORGANIZATION_ID
AND TREE.ORGANIZATION_LEVEL = 5 UNION SELECT '4-NA_EDW' || '-' || INST.INSTANCE_CODE ORG_TREE1_LVL4_PK
, '5-NA_EDW-' || INST.INSTANCE_CODE ORG_TREE1_LVL5_FK
, INST.INSTANCE_CODE INSTANCE
, NULL NAME
, NULL PRIMARY_ORG_DP
, NULL BUSINESS_GROUP
, TO_NUMBER(NULL) ORGANIZATION_ID
, TO_DATE('01-01-1990'
, 'DD-MM-YYYY') LAST_UPDATE_DATE
, TO_DATE('01-01-1990'
, 'DD-MM-YYYY') CREATION_DATE
FROM EDW_LOCAL_INSTANCE INST WITH READ ONLY

Columns