View: PA_STATUS_RSRC_EV_BASE_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_STATUS_RSRC_EV_BASE_V

View Text

SELECT RAD.PROJECT_ID
, RAD.TASK_ID
, RAD.RESOURCE_LIST_MEMBER_ID
, TA.TXN_ACCUM_ID
, TA.PA_PERIOD
, TAD.EVENT_NUM
, NVL(ERDL.AMOUNT
, 0)
FROM PA_RESOURCE_ACCUM_DETAILS RAD
, PA_TXN_ACCUM TA
, PA_CUST_EVENT_RDL_ALL ERDL
, PA_TXN_ACCUM_DETAILS TAD
WHERE RAD.TXN_ACCUM_ID = TAD.TXN_ACCUM_ID
AND TA.TXN_ACCUM_ID = TAD.TXN_ACCUM_ID
AND TAD.LINE_TYPE = 'E'
AND TAD.PROJECT_ID = ERDL.PROJECT_ID
AND TAD.TASK_ID = NVL(ERDL.TASK_ID
, 0)
AND TAD.EVENT_NUM = ERDL.EVENT_NUM
AND TAD.LINE_NUM = ERDL.LINE_NUM
AND RAD.PROJECT_ID = PA_STATUS.GETPROJID
AND RAD.TASK_ID = PA_STATUS.GETTASKID
AND RAD.RESOURCE_LIST_MEMBER_ID = PA_STATUS.GETRSRCMEMBERID

Columns