Product: | PA - Projects |
---|---|
Description: | pa_cost_exceptions_sum_mrc_v is a view that identifies the Cost Distribution Lines that prevent a period - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT MCDL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, EI.TASK_ID TASK_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 COST_DISTRIBUTION_LINE_NUM
, CDL.PA_DATE PA_DATE
, PRD.PERIOD_NAME PERIOD_NAME
, MCDL.TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, MCDL.TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON
, MCDL.QUANTITY QUANTITY
, MCDL.AMOUNT AMOUNT
, CDL.DENOM_RAW_COST DENOM_AMOUNT
, CDL.AMOUNT PROJECT_AMOUNT
, CDL.DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, MCDL.TRANSFER_STATUS_CODE
, MCDL.TRANSFER_REJECTION_REASON
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('COST_EXCP'
, MCDL.TRANSFER_STATUS_CODE
, MCDL.TRANSFER_REJECTION_REASON
, 'A') CORRECTIVE_ACTION
, 'I' CDL_EXCEPTION_TYPE
, EI.UNIT_OF_MEASURE
, IMP.ORG_ID
FROM PA_COST_DISTRIBUTION_LINES_ALL CDL
, PA_MC_COST_DIST_LINES_ALL MCDL
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_IMPLEMENTATIONS IMP
, PA_PERIODS_ALL PRD
WHERE MCDL.TRANSFER_STATUS_CODE IN ('P'
, 'R'
, 'X')
AND CDL.EXPENDITURE_ITEM_ID=MCDL.EXPENDITURE_ITEM_ID
AND CDL.LINE_NUM=MCDL.LINE_NUM
AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND ((EI.SYSTEM_LINKAGE_FUNCTION IN ('ST'
, 'OT')
AND IMP.INTERFACE_LABOR_TO_GL_FLAG = 'Y') OR (EI.SYSTEM_LINKAGE_FUNCTION IN ('USG'
, 'PJ'
, 'BTC'
, 'INV'
, 'WIP')
AND IMP.INTERFACE_USAGE_TO_GL_FLAG = 'Y') OR (EI.SYSTEM_LINKAGE_FUNCTION IN ('ER'
, 'VI')))
AND CDL.PA_DATE BETWEEN PRD.START_DATE
AND PRD.END_DATE
AND IMP.ORG_ID = EI.ORG_ID