View: PA_RESOURCE_LIST_V

Product:	PA - Projects
Description:	Details about a resource list and related resource list members.
Implementation/DBA Data:	APPS.PA_RESOURCE_LIST_V

View Text

SELECT RLM.RESOURCE_LIST_ID
, RL.NAME
, RLM.RESOURCE_LIST_MEMBER_ID
, RLM.RESOURCE_ID
, RLM.ALIAS
, R.NAME
, RLM.TRACK_AS_LABOR_FLAG
, RL.CONTROL_FLAG
FROM PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_LISTS RL
, PA_RESOURCES R
WHERE RLM.RESOURCE_LIST_ID = RL.RESOURCE_LIST_ID
AND RLM.RESOURCE_ID = R.RESOURCE_ID

Columns