View: PA_CDL_BURDEN_SUM_ERROR_V

Product:	PA - Projects
Description:	Cost distribution lines that are in exception for burden summarization
Implementation/DBA Data:	APPS.PA_CDL_BURDEN_SUM_ERROR_V

View Text

SELECT PT.PROJECT_TYPE
, P.PROJECT_ID
, P.SEGMENT1
, T.TASK_ID
, T.TASK_NUMBER
, EI.ATTRIBUTE1
, EI.EXPENDITURE_TYPE EI_EXP_TYPE
, EI.EXPENDITURE_ITEM_ID
, CDL.LINE_NUM
, CDL.PA_DATE
, EI.EXPENDITURE_ITEM_DATE
, CDL.BURDEN_SUM_SOURCE_RUN_ID
, CDL.BURDEN_SUM_REJECTION_CODE
, L.MEANING
, L.DESCRIPTION
, EI.ORG_ID
FROM PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_EXPENDITURES_ALL E
, PA_EXPENDITURE_ITEMS EI
, PA_LOOKUPS L
, 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 L.LOOKUP_TYPE = 'BURDEN_SUM_REJECTION_CODE'
AND LOOKUP_CODE = CDL.BURDEN_SUM_REJECTION_CODE
AND CDL.BURDEN_SUM_REJECTION_CODE IS NOT NULL
AND CDL.LINE_TYPE = 'R'
AND CDL.BURDEN_SUM_SOURCE_RUN_ID = -9999

Columns