VIEW: APPS.PA_STATUS_RSRC_EV_BASE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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