VIEW: APPS.PA_RESOURCE_LIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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