VIEW: APPS.PA_ADW_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) , PRAD.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 , PTA.TOT_REVENUE , PTA.TOT_RAW_COST , PTA.TOT_BURDENED_COST , PTA.TOT_QUANTITY , PTA.TOT_LABOR_HOURS , PTA.TOT_BILLABLE_RAW_COST , PTA.TOT_BILLABLE_BURDENED_COST , PTA.TOT_BILLABLE_QUANTITY , PTA.TOT_BILLABLE_LABOR_HOURS , PTA.TOT_CMT_RAW_COST , PTA.TOT_CMT_BURDENED_COST , PTA.TOT_CMT_QUANTITY , NVL(PTA.UNIT_OF_MEASURE,NVL(PET.UNIT_OF_MEASURE,'Unknown')) , PRAD.ADW_NOTIFY_FLAG , PTA.ADW_NOTIFY_FLAG FROM PA_TXN_ACCUM PTA, PA_EXPENDITURE_TYPES PET, PA_RESOURCE_ACCUM_DETAILS PRAD, PA_PROJECT_TYPES PPT, PA_ADW_PROJECTS_B_V PP, PA_ADW_RES_LISTS_B_V PRL, PA_ADW_CURRENT_TASKS PT, PA_ADW_CURRENT_TASKS PTT, PA_IMPLEMENTATIONS PI, PA_LOOKUPS PLU WHERE PTA.TXN_ACCUM_ID = PRAD.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 PRAD.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)
, PRAD.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
, PTA.TOT_REVENUE
, PTA.TOT_RAW_COST
, PTA.TOT_BURDENED_COST
, PTA.TOT_QUANTITY
, PTA.TOT_LABOR_HOURS
, PTA.TOT_BILLABLE_RAW_COST
, PTA.TOT_BILLABLE_BURDENED_COST
, PTA.TOT_BILLABLE_QUANTITY
, PTA.TOT_BILLABLE_LABOR_HOURS
, PTA.TOT_CMT_RAW_COST
, PTA.TOT_CMT_BURDENED_COST
, PTA.TOT_CMT_QUANTITY
, NVL(PTA.UNIT_OF_MEASURE
, NVL(PET.UNIT_OF_MEASURE
, 'UNKNOWN'))
, PRAD.ADW_NOTIFY_FLAG
, PTA.ADW_NOTIFY_FLAG
FROM PA_TXN_ACCUM PTA
, PA_EXPENDITURE_TYPES PET
, PA_RESOURCE_ACCUM_DETAILS PRAD
, PA_PROJECT_TYPES PPT
, PA_ADW_PROJECTS_B_V PP
, PA_ADW_RES_LISTS_B_V PRL
, PA_ADW_CURRENT_TASKS PT
, PA_ADW_CURRENT_TASKS PTT
, PA_IMPLEMENTATIONS PI
, PA_LOOKUPS PLU
WHERE PTA.TXN_ACCUM_ID = PRAD.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 PRAD.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 )