VIEW: APPS.EDW_MTL_ILDM_PORG_LCV

Source

View Text - Preformatted

SELECT O.ORGN_CODE|| '-' || I.INSTANCE_CODE ||'-'||'OPM' ORGANIZATION_PK, I.INSTANCE_CODE INSTANCE_CODE, O.CO_CODE ||'-' || I.INSTANCE_CODE ||'-'||'OPM' , O.ORGN_CODE OPM_ORGANIZATION_CODE, O.ORGN_NAME OPM_ORGANIZATION_NAME, O.ORGN_NAME DESCRIPTION, 'INVENTORY ORGANIZATION GROUP' ORGANIZATION_DP, O.ORGN_CODE ||'('||O.ORGN_NAME ||')', O.CREATION_DATE CREATION_DATE, O.LAST_UPDATE_DATE LAST_UPDATE_DATE, null USER_ATTRIBUTE1, null USER_ATTRIBUTE2, null USER_ATTRIBUTE3, null USER_ATTRIBUTE4, null USER_ATTRIBUTE5 FROM SY_ORGN_MST O, EDW_LOCAL_INSTANCE I UNION SELECT OPERATING_UNIT_PK||'-OU' ,INSTANCE ,OPERATING_UNIT_PK||'-OU' ,ORG_CODE ,NAME ,NAME , 'INVENTORY ORGANIZATION GROUPS' OPERATING_UNIT_DP ,NAME ,OUV.LAST_UPDATE_DATE ,OUV.LAST_UPDATE_DATE ,USER_ATTRIBUTE1 ,USER_ATTRIBUTE2 ,USER_ATTRIBUTE3 ,USER_ATTRIBUTE4 ,USER_ATTRIBUTE5 FROM EDW_MTL_ILDM_OU_LCV OUV UNION SELECT O.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' ||'-PCMP' COMPANY_FK , I.INSTANCE_CODE INSTANCE_CODE, O.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' COMPANY_FK , O.ORGN_CODE OPM_COMPANY_CODE, O.ORGN_NAME OPM_COMPANY_NAME, O.ORGN_NAME DESCRIPTION, 'INVENTORY ORGANIZATION GROUPS' OPM_COMPANY_DP, O.ORGN_CODE ||'('||O.ORGN_NAME ||')', O.CREATION_DATE CREATION_DATE, O.LAST_UPDATE_DATE LAST_UPDATE_DATE, null USER_ATTRIBUTE1, null USER_ATTRIBUTE2, null USER_ATTRIBUTE3, null USER_ATTRIBUTE4, null USER_ATTRIBUTE5 FROM SY_ORGN_MST O, EDW_LOCAL_INSTANCE I WHERE O.ORGN_CODE = O.CO_CODE

View Text - HTML Formatted

SELECT O.ORGN_CODE|| '-' || I.INSTANCE_CODE ||'-'||'OPM' ORGANIZATION_PK
, I.INSTANCE_CODE INSTANCE_CODE
, O.CO_CODE ||'-' || I.INSTANCE_CODE ||'-'||'OPM'
, O.ORGN_CODE OPM_ORGANIZATION_CODE
, O.ORGN_NAME OPM_ORGANIZATION_NAME
, O.ORGN_NAME DESCRIPTION
, 'INVENTORY ORGANIZATION GROUP' ORGANIZATION_DP
, O.ORGN_CODE ||'('||O.ORGN_NAME ||')'
, O.CREATION_DATE CREATION_DATE
, O.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM SY_ORGN_MST O
, EDW_LOCAL_INSTANCE I UNION SELECT OPERATING_UNIT_PK||'-OU'
, INSTANCE
, OPERATING_UNIT_PK||'-OU'
, ORG_CODE
, NAME
, NAME
, 'INVENTORY ORGANIZATION GROUPS' OPERATING_UNIT_DP
, NAME
, OUV.LAST_UPDATE_DATE
, OUV.LAST_UPDATE_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM EDW_MTL_ILDM_OU_LCV OUV UNION SELECT O.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' ||'-PCMP' COMPANY_FK
, I.INSTANCE_CODE INSTANCE_CODE
, O.ORGN_CODE || '-' || I.INSTANCE_CODE ||'-'||'OPM' COMPANY_FK
, O.ORGN_CODE OPM_COMPANY_CODE
, O.ORGN_NAME OPM_COMPANY_NAME
, O.ORGN_NAME DESCRIPTION
, 'INVENTORY ORGANIZATION GROUPS' OPM_COMPANY_DP
, O.ORGN_CODE ||'('||O.ORGN_NAME ||')'
, O.CREATION_DATE CREATION_DATE
, O.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM SY_ORGN_MST O
, EDW_LOCAL_INSTANCE I
WHERE O.ORGN_CODE = O.CO_CODE