[Home] [Help]
| Product: | PA - Projects |
|---|---|
| Description: | pa_cost_exceptions_det_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 /*+ USE_NL (SMRY
, EXP) */ SMRY.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TSK.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, SMRY.TASK_ID TASK_ID
, TSK.TASK_NUMBER TASK_NUMBER
, SMRY.EXPENDITURE_ID EXPENDITURE_ID
, SMRY.EXPENDITURE_ITEM_ID EXPENDITURE_ITEM_ID
, SMRY.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXP.EXPENDITURE_ENDING_DATE EXPENDITURE_ENDING_DATE
, EXP.EXPENDITURE_GROUP EXPENDITURE_GROUP
, SMRY.EXPENDITURE_TYPE EXPENDITURE_TYPE
, SMRY.CDL_LINE_NUM CDL_LINE_NUM
, SMRY.PA_DATE PA_DATE
, SMRY.PERIOD_NAME PERIOD_NAME
, SMRY.QUANTITY
, SMRY.AMOUNT AMOUNT
, SMRY.DENOM_CURRENCY_CODE
, SMRY.DENOM_AMOUNT DENOM_AMOUNT
, SMRY.PROJECT_AMOUNT PROJECT_AMOUNT
, EXP.INCURRED_BY_PERSON_ID PERSON_ID
, (SELECT FULL_NAME
FROM PER_ALL_PEOPLE_F PER
WHERE PERSON_ID = EXP.INCURRED_BY_PERSON_ID
AND EXP.EXPENDITURE_ENDING_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE) PERSON_NAME
, SMRY.TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, SMRY.TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON
, SMRY.EXCEPTION_REASON EXCEPTION_REASON
, SMRY.CORRECTIVE_ACTION CORRECTIVE_ACTION
, SMRY.UNIT_OF_MEASURE
FROM PA_COST_EXCEPTIONS_SUM_MRC_V SMRY
, PA_PROJECTS_ALL PRJ
, PA_TASKS TSK
, PA_EXPENDITURES_ALL EXP
WHERE PRJ.PROJECT_ID = TSK.PROJECT_ID
AND TSK.TASK_ID = SMRY.TASK_ID
AND EXP.EXPENDITURE_ID = SMRY.EXPENDITURE_ID