View: EDW_BRES_RESGROUP_LCV

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

View Text

SELECT RG.LOOKUP_CODE
, INST.INSTANCE_CODE
, 'ALL'
, RG.MEANING
, RG.MEANING
, RG.MEANING
, RG.DESCRIPTION
, RG.LAST_UPDATE_DATE
, RG.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM FND_COMMON_LOOKUPS RG
, EDW_LOCAL_INSTANCE INST
WHERE LOOKUP_TYPE='CRP_RESOURCE_GROUPS' /* THE FOLLOWING UNION IS FOR OPM */ UNION ALL SELECT RC.RESOURCE_CLASS||'-'||INST.INSTANCE_CODE||'-OPM'
, INST.INSTANCE_CODE
, 'ALL'
, RC.RESOURCE_CLASS_DESC
, RC.RESOURCE_CLASS_DESC
, RC.RESOURCE_CLASS_DESC
, RC.RESOURCE_CLASS_DESC
, RC.LAST_UPDATE_DATE
, RC.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM CR_RSRC_CLS RC
, EDW_LOCAL_INSTANCE INST WITH READ ONLY

Columns