VIEW: APPS.PA_CHILD_RESOURCES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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