View: EDWBV_ORGA_TREE1_LVL1_LCV

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.EDWBV_ORGA_TREE1_LVL1_LCV

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ '1-' || TREE.ORGANIZATION_ID || '-' || INST.INSTANCE_CODE ORG_TREE1_LVL1_PK
, LVL2.ORG_TREE1_LVL2_PK ORG_TREE1_LVL2_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_LVL2_LCV LVL2
, EDW_LOCAL_INSTANCE INST
WHERE TREE.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND TREE.BUSINESS_GROUP_ID = BGR.ORGANIZATION_ID
AND TREE.PARENT_ORGANIZATION_ID = LVL2.ORGANIZATION_ID
AND TREE.ORGANIZATION_LEVEL = 8 UNION SELECT '1-NA_EDW' || '-' || INST.INSTANCE_CODE ORG_TREE1_LVL1_PK
, '2-NA_EDW-' || INST.INSTANCE_CODE ORG_TREE1_LVL2_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