View: PA_CMT_BURDEN_SUM_ERROR_V

Product:	PA - Projects
Description:	This View lists all the Commitment transactions which are in error during burden summarization.
Implementation/DBA Data:	APPS.PA_CMT_BURDEN_SUM_ERROR_V

View Text

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

Columns