VIEW: APPS.PA_LOWEST_LEVEL_RESOURCES_V

Source

View Text - Preformatted

SELECT RLM.RESOURCE_LIST_ID , RL.NAME , RLM.RESOURCE_LIST_MEMBER_ID , RLM.RESOURCE_ID , RLM.ALIAS , pa_resources_pkg.get_resource_name(R.RESOURCE_ID,R.RESOURCE_TYPE_ID) , RLM.TRACK_AS_LABOR_FLAG , rlm.migration_code FROM PA_RESOURCE_LIST_MEMBERS RLM , PA_RESOURCE_LISTS RL , PA_RESOURCES R WHERE NOT EXISTS (SELECT NULL FROM PA_RESOURCE_LIST_MEMBERS RLM2 WHERE RLM2.PARENT_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID) AND 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
, PA_RESOURCES_PKG.GET_RESOURCE_NAME(R.RESOURCE_ID
, R.RESOURCE_TYPE_ID)
, RLM.TRACK_AS_LABOR_FLAG
, RLM.MIGRATION_CODE
FROM PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCE_LISTS RL
, PA_RESOURCES R
WHERE NOT EXISTS (SELECT NULL
FROM PA_RESOURCE_LIST_MEMBERS RLM2
WHERE RLM2.PARENT_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID)
AND RLM.RESOURCE_LIST_ID = RL.RESOURCE_LIST_ID
AND RLM.RESOURCE_ID = R.RESOURCE_ID