View: PA_CC_EXCEPTIONS_SUM_V

Product:	PA - Projects
Description:	Cross charge distributions that prevent a period from being closed.This view is used in period close reports.
Implementation/DBA Data:	APPS.PA_CC_EXCEPTIONS_SUM_V

View Text

SELECT CDL.PROJECT_ID PROJECT_ID
, PP.SEGMENT1 PROJECT_NUMBER
, CDL.TASK_ID TASK_ID
, EI.RECVR_ORG_ID RECVR_ORG_ID
, OTL.NAME RECVR_ORG_NAME
, EXP.INCURRED_BY_PERSON_ID EMPLOYEE_ID
, EXP.VENDOR_ID VENDOR_ID
, EI.ORGANIZATION_ID NON_LABOR_ORG_ID
, NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, EXP.INCURRED_BY_ORGANIZATION_ID)
, EI.EXPENDITURE_ID EXPENDITURE_ID
, EI.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, EI.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EI.EXPENDITURE_TYPE EXPENDITURE_TYPE
, CDL.LINE_NUM CDL_LINE_NUM
, CDL.PA_DATE PA_DATE
, CDL.ACCT_CURRENCY_CODE
, CDL.AMOUNT
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('CC_EXCP'
, CDL.TRANSFER_REJECTION_CODE
, NULL
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('CC_EXCP'
, CDL.TRANSFER_REJECTION_CODE
, NULL
, 'A') CORRECTIVE_ACTION
, NVL(CDL.TRANSFER_REJECTION_CODE
, CDL.TRANSFER_STATUS_CODE)
, EI.SYSTEM_LINKAGE_FUNCTION
, 'I' CDL_EXCEPTION_TYPE
, CDL.PA_PERIOD_NAME PERIOD_NAME
, PP.ORG_ID
FROM PA_CC_DIST_LINES_ALL CDL
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL EXP
, PA_PROJECTS PP
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND EXP.EXPENDITURE_ID=EI.EXPENDITURE_ID
AND CDL.PROJECT_ID=PP.PROJECT_ID
AND EI.RECVR_ORG_ID=OTL.ORGANIZATION_ID(+)
AND DECODE(OTL.ORGANIZATION_ID
, NULL
, '1'
, OTL.LANGUAGE)= DECODE(OTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND CDL.TRANSFER_STATUS_CODE IN ('P'
, 'R'
, 'X')

Columns