VIEW: APPS.PA_CMT_BURDEN_SUM_ERROR_V

Source

View Text - Preformatted

SELECT PT.PROJECT_TYPE , P.PROJECT_ID , P.SEGMENT1 , T.TASK_ID , T.TASK_NUMBER , CMT.PA_PERIOD , CMT.TRANSACTION_SOURCE , CMT.EXPENDITURE_TYPE , CMT.LINE_TYPE , CMT.CMT_NUMBER , CMT.EXPENDITURE_ITEM_DATE , CMT.ORIGINAL_TXN_REFERENCE1 , CMT.ORIGINAL_TXN_REFERENCE2 , CMT.ORIGINAL_TXN_REFERENCE3 , CMT.BURDEN_SUM_SOURCE_RUN_ID , CMT.BURDEN_SUM_REJECTION_CODE , L.MEANING , L.DESCRIPTION FROM PA_PROJECT_TYPES_ALL PT, PA_PROJECTS_ALL P, PA_TASKS T, PA_LOOKUPS L, PA_COMMITMENT_TXNS CMT WHERE PT.PROJECT_TYPE = P.PROJECT_TYPE AND PT.ORG_ID = P.ORG_ID AND P.PROJECT_ID = CMT.PROJECT_ID AND T.TASK_ID = CMT.TASK_ID AND L.LOOKUP_TYPE = 'BURDEN_SUM_REJECTION_CODE' AND LOOKUP_CODE = CMT.BURDEN_SUM_REJECTION_CODE AND CMT.BURDEN_SUM_REJECTION_CODE IS NOT NULL AND CMT.LINE_TYPE = 'R' AND CMT.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
, CMT.PA_PERIOD
, CMT.TRANSACTION_SOURCE
, CMT.EXPENDITURE_TYPE
, CMT.LINE_TYPE
, CMT.CMT_NUMBER
, CMT.EXPENDITURE_ITEM_DATE
, CMT.ORIGINAL_TXN_REFERENCE1
, CMT.ORIGINAL_TXN_REFERENCE2
, CMT.ORIGINAL_TXN_REFERENCE3
, CMT.BURDEN_SUM_SOURCE_RUN_ID
, CMT.BURDEN_SUM_REJECTION_CODE
, L.MEANING
, L.DESCRIPTION
FROM PA_PROJECT_TYPES_ALL PT
, PA_PROJECTS_ALL P
, PA_TASKS T
, PA_LOOKUPS L
, PA_COMMITMENT_TXNS CMT
WHERE PT.PROJECT_TYPE = P.PROJECT_TYPE
AND PT.ORG_ID = P.ORG_ID
AND P.PROJECT_ID = CMT.PROJECT_ID
AND T.TASK_ID = CMT.TASK_ID
AND L.LOOKUP_TYPE = 'BURDEN_SUM_REJECTION_CODE'
AND LOOKUP_CODE = CMT.BURDEN_SUM_REJECTION_CODE
AND CMT.BURDEN_SUM_REJECTION_CODE IS NOT NULL
AND CMT.LINE_TYPE = 'R'
AND CMT.BURDEN_SUM_SOURCE_RUN_ID = -9999