VIEW: APPS.PA_ADW_R_ACT_CMT_B_V

Source

View Text - Preformatted

SELECT PTA.PROJECT_ID , PT.TOP_TASK_ID , PT.TASK_ID , PTA.PA_PERIOD || '-'|| PI.SET_OF_BOOKS_ID PA_PERIOD_KEY , NVL(PTA.ORGANIZATION_ID,-1) , NVL(PT.CARRYING_OUT_ORGANIZATION_ID, PP.CARRYING_OUT_ORGANIZATION_ID) , PORAD.RESOURCE_LIST_MEMBER_ID , NVL(PTT.SERVICE_TYPE_CODE,PPT.SERVICE_TYPE_CODE) , NVL(PTA.EXPENDITURE_TYPE,PLU.MEANING) , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NVL(PTA.UNIT_OF_MEASURE,NVL(PET.UNIT_OF_MEASURE,'Unknown')) , PORAD.ADW_NOTIFY_FLAG , PTA.ADW_NOTIFY_FLAG , NVL(PT.ADW_NOTIFY_FLAG,'N') FROM PA_TXN_ACCUM PTA, PA_EXPENDITURE_TYPES PET, PA_OLD_RES_ACCUM_DTLS PORAD, PA_PROJECT_TYPES PPT, PA_ADW_PROJECTS_B_V PP, PA_ADW_RES_LISTS_B_V PRL, PA_ADW_INTERFACED_TASKS PT, PA_ADW_INTERFACED_TASKS PTT, PA_IMPLEMENTATIONS PI, PA_LOOKUPS PLU WHERE PTA.TXN_ACCUM_ID = PORAD.TXN_ACCUM_ID AND PTA.PROJECT_ID = PP.PROJECT_ID AND PTA.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE(+) AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE AND PORAD.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME' AND PLU.LOOKUP_CODE = 'UNKNOWN' AND PT.TOP_TASK_ID = PTT.TASK_ID(+) AND PTA.TASK_ID = PT.TASK_ID(+) AND EXISTS (SELECT 'Yes' FROM PA_TXN_ACCUM_DETAILS PTAD WHERE PTAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID )

View Text - HTML Formatted

SELECT PTA.PROJECT_ID
, PT.TOP_TASK_ID
, PT.TASK_ID
, PTA.PA_PERIOD || '-'|| PI.SET_OF_BOOKS_ID PA_PERIOD_KEY
, NVL(PTA.ORGANIZATION_ID
, -1)
, NVL(PT.CARRYING_OUT_ORGANIZATION_ID
, PP.CARRYING_OUT_ORGANIZATION_ID)
, PORAD.RESOURCE_LIST_MEMBER_ID
, NVL(PTT.SERVICE_TYPE_CODE
, PPT.SERVICE_TYPE_CODE)
, NVL(PTA.EXPENDITURE_TYPE
, PLU.MEANING)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NVL(PTA.UNIT_OF_MEASURE
, NVL(PET.UNIT_OF_MEASURE
, 'UNKNOWN'))
, PORAD.ADW_NOTIFY_FLAG
, PTA.ADW_NOTIFY_FLAG
, NVL(PT.ADW_NOTIFY_FLAG
, 'N')
FROM PA_TXN_ACCUM PTA
, PA_EXPENDITURE_TYPES PET
, PA_OLD_RES_ACCUM_DTLS PORAD
, PA_PROJECT_TYPES PPT
, PA_ADW_PROJECTS_B_V PP
, PA_ADW_RES_LISTS_B_V PRL
, PA_ADW_INTERFACED_TASKS PT
, PA_ADW_INTERFACED_TASKS PTT
, PA_IMPLEMENTATIONS PI
, PA_LOOKUPS PLU
WHERE PTA.TXN_ACCUM_ID = PORAD.TXN_ACCUM_ID
AND PTA.PROJECT_ID = PP.PROJECT_ID
AND PTA.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE(+)
AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PORAD.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND PLU.LOOKUP_TYPE = 'ADW RESOURCE NAME'
AND PLU.LOOKUP_CODE = 'UNKNOWN'
AND PT.TOP_TASK_ID = PTT.TASK_ID(+)
AND PTA.TASK_ID = PT.TASK_ID(+)
AND EXISTS (SELECT 'YES'
FROM PA_TXN_ACCUM_DETAILS PTAD
WHERE PTAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID )