VIEW: APPS.PA_CDL_BURDEN_SUM_ERROR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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