Product: | ENG - Engineering |
---|---|
Description: | This view holds the resource department class information |
Implementation/DBA Data: | APPS.EDW_BRES_DEPT_CLASS_LCV |
SELECT DC.DEPARTMENT_CLASS_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(MP.ORGANIZATION_CODE
, 'NA_EDW')
, DC.DEPARTMENT_CLASS_CODE||'('||MP.ORGANIZATION_CODE||')'
, DC.DEPARTMENT_CLASS_CODE||'('||MP.ORGANIZATION_CODE||')'
, DC.DEPARTMENT_CLASS_CODE||'('||MP.ORGANIZATION_CODE||')'
, DC.DESCRIPTION
, DC.CREATION_DATE
, DC.LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM BOM_DEPARTMENT_CLASSES DC
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE DC.ORGANIZATION_ID = MP.ORGANIZATION_ID + 0 UNION ALL SELECT 'LINE-'||MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(MP.ORGANIZATION_CODE
, 'NA_EDW')
, ML.MEANING||'('||MP.ORGANIZATION_CODE||')'
, ML.MEANING
, ML.MEANING||'('||MP.ORGANIZATION_CODE||')'
, ML.DESCRIPTION
, ML.CREATION_DATE
, ML.LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MFG_LOOKUPS ML
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE ML.LOOKUP_TYPE='CRP_REPORT_TYPE'
AND ML.LOOKUP_CODE=1 WITH READ ONLY