Product: | OPI - Operations Intelligence (Obsolete) |
---|---|
Description: | Source View for Inventory Organization Parent Group Level of Inventory Locator Dimension |
Implementation/DBA Data: | Not implemented in this database |
SELECT O.ORGN_CODE|| '-' || I.INSTANCE_CODE||'-'||'OPM' COMPANY_PK
, I.INSTANCE_CODE INSTANCE_CODE
, DECODE(PM.ORG_ID
, NULL
, 'NA_EDW'
, PM.ORG_ID ||'-' || I.INSTANCE_CODE )
, O.ORGN_CODE OPM_COMPANY_CODE
, O.ORGN_NAME OPM_COMPANY_NAME
, O.ORGN_NAME DESCRIPTION
, 'INVENTORY ORGANIZATION PARENT GROUP' 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
, GL_PLCY_MST PM
, EDW_LOCAL_INSTANCE I
WHERE O.ORGN_CODE = O.CO_CODE
AND O.ORGN_CODE = PM.CO_CODE(+) UNION SELECT OPERATING_UNIT_PK||'-OU'
, INSTANCE
, OPERATING_UNIT_PK
, ORG_CODE
, NAME
, NAME
, 'ALL INVENTORY ORGANIZATION PARENT GROUPS' OPERATING_UNIT_DP
, NAME
, O.LAST_UPDATE_DATE
, O.LAST_UPDATE_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM EDW_MTL_ILDM_OU_LCV O