View: PA_LOWEST_LEVEL_RESOURCES_V

Product:	PA - Projects
Description:	This view that displays details about the lowest level resource list members
Implementation/DBA Data:	APPS.PA_LOWEST_LEVEL_RESOURCES_V

View Text

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

Columns