VIEW: APPS.PA_STATUS_PROJ_ACCUM_HEADERS_V

Source

View Text - Preformatted

SELECT PAH.PROJECT_ID , PAH.TASK_ID , PAH.RESOURCE_LIST_MEMBER_ID , PAH.RESOURCE_LIST_ID , PAH.RESOURCE_LIST_ASSIGNMENT_ID FROM PA_PROJECT_ACCUM_HEADERS PAH WHERE PAH.PROJECT_ID = PA_STATUS.GETPROJID AND PAH.TASK_ID = PA_STATUS.GETTASKID AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID UNION SELECT PAH.PROJECT_ID , PAH.TASK_ID , RLM.PARENT_MEMBER_ID , PAH.RESOURCE_LIST_ID , PAH.RESOURCE_LIST_ASSIGNMENT_ID FROM PA_PROJECT_ACCUM_HEADERS PAH , PA_RESOURCE_LIST_MEMBERS RLM WHERE PAH.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID AND RLM.PARENT_MEMBER_ID IS NOT NULL AND PAH.PROJECT_ID = PA_STATUS.GETPROJID AND PAH.TASK_ID = PA_STATUS.GETTASKID AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID GROUP BY PAH.PROJECT_ID, PAH.TASK_ID, RLM.PARENT_MEMBER_ID, PAH.RESOURCE_LIST_ID, PAH.RESOURCE_LIST_ASSIGNMENT_ID

View Text - HTML Formatted

SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, PAH.RESOURCE_LIST_MEMBER_ID
, PAH.RESOURCE_LIST_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
FROM PA_PROJECT_ACCUM_HEADERS PAH
WHERE PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.TASK_ID = PA_STATUS.GETTASKID
AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID UNION SELECT PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.PARENT_MEMBER_ID
, PAH.RESOURCE_LIST_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_RESOURCE_LIST_MEMBERS RLM
WHERE PAH.RESOURCE_LIST_MEMBER_ID = RLM.RESOURCE_LIST_MEMBER_ID
AND RLM.PARENT_MEMBER_ID IS NOT NULL
AND PAH.PROJECT_ID = PA_STATUS.GETPROJID
AND PAH.TASK_ID = PA_STATUS.GETTASKID
AND PAH.RESOURCE_LIST_ID = PA_STATUS.GETRSRCLISTID GROUP BY PAH.PROJECT_ID
, PAH.TASK_ID
, RLM.PARENT_MEMBER_ID
, PAH.RESOURCE_LIST_ID
, PAH.RESOURCE_LIST_ASSIGNMENT_ID