[Home] [Help]
View: PA_STATUS_TASK_EV_BASE_V
View Text
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
Columns
Name |
PROJECT_ID |
TASK_ID |
RESOURCE_LIST_MEMBER_ID |
TXN_ACCUM_ID |
PA_PERIOD |
EVENT_NUM |
REVENUE_AMOUNT |