View: PA_PLANNING_RESOURCES_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PLANNING_RESOURCES_V

View Text

SELECT RL.RESOURCE_LIST_ID RESOURCE_LIST_ID
, RLM.RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, RLM.ALIAS PLANNING_RESOURCE_ALIAS
, RLM.RES_FORMAT_ID
, RF.NAME
, PA_PLANNING_RESOURCE_UTILS.GET_PLAN_RES_COMBINATION(RLM.RESOURCE_LIST_MEMBER_ID) PLANNING_RESOURCE_COMBINATION
, RLM.RESOURCE_CLASS_ID RESOURCE_CLASS_ID
, RLM.RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, RC.NAME RESOURCE_CLASS_NAME
, RLM.UNIT_OF_MEASURE
, RLM.OBJECT_TYPE
, RLM.OBJECT_ID
FROM PA_RESOURCE_LISTS_ALL_BG RL
, PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_CLASSES_VL RC
, PA_RES_FORMATS_VL RF
WHERE RL.MIGRATION_CODE IS NOT NULL
AND RL.RESOURCE_LIST_ID = RLM.RESOURCE_LIST_ID
AND RLM.MIGRATION_CODE IS NOT NULL
AND RLM.ENABLED_FLAG = 'Y'
AND RLM.RESOURCE_CLASS_ID = RC.RESOURCE_CLASS_ID
AND RLM.RES_FORMAT_ID = RF.RES_FORMAT_ID

Columns