View: EDW_BRES_RESCAT_LCV

Product:	ENG - Engineering
Description:	This view holds resource category information
Implementation/DBA Data:	APPS.EDW_BRES_RESCAT_LCV

View Text

SELECT RC.RESOURCE_CODE||'-'|| MP.ORGANIZATION_CODE||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, NVL(MP.ORGANIZATION_CODE
, 'NA_EDW')
, NVL(RT.MEANING
, 'NA_EDW')
, RC.RESOURCE_CODE||'('||MP.ORGANIZATION_CODE||')'
, RT.MEANING||'('||MP.ORGANIZATION_CODE||')'
, RC.DESCRIPTION
, RC.LAST_UPDATE_DATE
, RC.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MFG_LOOKUPS RT
, BOM_RESOURCES RC
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE RT.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE'
AND RT.LOOKUP_CODE = RC.RESOURCE_TYPE
AND RC.ORGANIZATION_ID = MP.ORGANIZATION_ID + 0 WITH READ ONLY

Columns