VIEW: APPS.PA_STATUS_TASK_EV_BASE_V

Source

View Text - Preformatted

SELECT TA.PROJECT_ID , TA.TASK_ID , 0 , TA.TXN_ACCUM_ID , TA.PA_PERIOD , TAD.EVENT_NUM , NVL(ERDL.AMOUNT,0) FROM PA_TXN_ACCUM TA , PA_CUST_EVENT_RDL_ALL ERDL , PA_TXN_ACCUM_DETAILS TAD WHERE 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 TA.PROJECT_ID = PA_STATUS.GETPROJID AND TA.TASK_ID = PA_STATUS.GETTASKID

View Text - HTML Formatted

SELECT TA.PROJECT_ID
, TA.TASK_ID
, 0
, TA.TXN_ACCUM_ID
, TA.PA_PERIOD
, TAD.EVENT_NUM
, NVL(ERDL.AMOUNT
, 0)
FROM PA_TXN_ACCUM TA
, PA_CUST_EVENT_RDL_ALL ERDL
, PA_TXN_ACCUM_DETAILS TAD
WHERE 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 TA.PROJECT_ID = PA_STATUS.GETPROJID
AND TA.TASK_ID = PA_STATUS.GETTASKID