View: EDWBV_ORGA_TREE1_LVL6_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ '6-' || TREE.ORGANIZATION_ID || '-' || INST.INSTANCE_CODE ORG_TREE1_LVL6_PK
, LVL7.ORG_TREE1_LVL7_PK ORG_TREE1_LVL7_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_LVL7_LCV LVL7
, EDW_LOCAL_INSTANCE INST
WHERE TREE.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND TREE.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND TREE.PARENT_ORGANIZATION_ID = LVL7.ORGANIZATION_ID
AND TREE.ORGANIZATION_LEVEL = 3 UNION SELECT '6-NA_EDW' || '-' || INST.INSTANCE_CODE ORG_TREE1_LVL6_PK
, '7-NA_EDW-' || INST.INSTANCE_CODE ORG_TREE1_LVL7_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