View: PA_ADW_ACT_CMT_B_V

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PA_ADW_ACT_CMT_B_V

View Text

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 )

Columns