View: PA_BURDEN_EXP_ITEM_CDL_V

Product:	PA - Projects
Description:	All summarized burden expenditure items and their cost distribution lines
Implementation/DBA Data:	APPS.PA_BURDEN_EXP_ITEM_CDL_V

View Text

SELECT PT.PROJECT_TYPE
, P.SEGMENT1
, T.TASK_NUMBER
, CDL.PA_DATE
, EI.ATTRIBUTE1
, E.EXPENDITURE_GROUP
, EI.EXPENDITURE_TYPE
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, EI.EXPENDITURE_ITEM_DATE
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, E.ORG_ID
FROM PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPENDITURES E
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_COST_DISTRIBUTION_LINES_ALL CDL
WHERE PT.PROJECT_TYPE = P.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID
AND P.PROJECT_ID = T.PROJECT_ID
AND T.TASK_ID = EI.TASK_ID
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND EI.BURDEN_SUM_DEST_RUN_ID = CDL.BURDEN_SUM_SOURCE_RUN_ID
AND CDL.LINE_TYPE = 'R'

Columns