View: PA_CHILD_RESOURCES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_CHILD_RESOURCES_V

View Text

SELECT RLM.ROWID
, RLM.RESOURCE_LIST_MEMBER_ID
, RLM.RESOURCE_LIST_ID
, RLM.RESOURCE_ID
, PA_RESOURCES_PKG.GET_RESOURCE_NAME(R.RESOURCE_ID
, R.RESOURCE_TYPE_ID)
, R.RESOURCE_TYPE_ID
, RT.NAME
, RLM.ALIAS
, RLM.PARENT_MEMBER_ID
, RLM.SORT_ORDER
, RLM.DISPLAY_FLAG
, RLM.ENABLED_FLAG
, RLM.TRACK_AS_LABOR_FLAG
, RLM.MIGRATION_CODE
, RLM.LAST_UPDATE_DATE
, RLM.LAST_UPDATED_BY
, RLM.CREATION_DATE
, RLM.CREATED_BY
, RLM.LAST_UPDATE_LOGIN
, RLM.FUNDS_CONTROL_LEVEL_CODE
FROM PA_RESOURCE_LIST_MEMBERS RLM
, PA_RESOURCES R
, PA_RESOURCE_TYPES RT
WHERE (RLM.PARENT_MEMBER_ID IS NOT NULL OR RLM.PARENT_MEMBER_ID <> 0 OR EXISTS (SELECT 'X'
FROM PA_RESOURCE_LISTS RL
WHERE RL.RESOURCE_LIST_ID = RLM.RESOURCE_LIST_ID
AND RL.GROUP_RESOURCE_TYPE_ID = 0))
AND RLM.RESOURCE_ID = R.RESOURCE_ID
AND R.RESOURCE_TYPE_ID = RT.RESOURCE_TYPE_ID

Columns