Product: | ENG - Engineering |
---|---|
Description: | This view holds resource plant information |
Implementation/DBA Data: | APPS.EDW_BRES_PLANT_LCV |
SELECT MP.ORGANIZATION_CODE
, 'ALL'
, INST.INSTANCE_CODE
, MP.ORGANIZATION_CODE
, MP.ORGANIZATION_CODE
, ORG.NAME||'('||BG.NAME||')'
, MP.ORGANIZATION_CODE
, NULL
, MP.LAST_UPDATE_DATE
, MP.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_ALL_ORGANIZATION_UNITS BG
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE BG.ORGANIZATION_ID = ORG.BUSINESS_GROUP_ID
AND ORG.ORGANIZATION_ID = MP.ORGANIZATION_ID WITH READ ONLY