Product: | PA - Projects |
---|---|
Description: | This view is used in period close reports. It shows all cross charge distribution lines that prevent closing a period |
Implementation/DBA Data: | Not implemented in this database |
SELECT MCDL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, 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
, MCDL.LINE_NUM CDL_LINE_NUM
, CDL.PA_DATE PA_DATE
, MCDL.ACCT_CURRENCY_CODE
, MCDL.AMOUNT
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('CC_EXCP'
, MCDL.TRANSFER_REJECTION_CODE
, NULL
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('CC_EXCP'
, MCDL.TRANSFER_REJECTION_CODE
, NULL
, 'A') CORRECTIVE_ACTION
, MCDL.TRANSFER_REJECTION_CODE
, EI.SYSTEM_LINKAGE_FUNCTION
, 'I' CDL_EXCEPTION_TYPE
, CDL.PA_PERIOD_NAME PERIOD_NAME
FROM PA_CC_DIST_LINES_ALL CDL
, PA_MC_CC_DIST_LINES_ALL MCDL
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL EXP
, PA_PROJECTS_ALL PP
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE CDL.EXPENDITURE_ITEM_ID=MCDL.EXPENDITURE_ITEM_ID
AND CDL.LINE_NUM=MCDL.LINE_NUM
AND EI.EXPENDITURE_ITEM_ID = MCDL.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 MCDL.TRANSFER_STATUS_CODE IN ('P'
, 'R'
, 'X')