View: PA_COST_EXCEPTIONS_DET_V

Product:	PA - Projects
Description:	Identifies the details Cost Distribution Lines that prevent a period from being closed.
Implementation/DBA Data:	APPS.PA_COST_EXCEPTIONS_DET_V

View Text

SELECT TSK.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, SMRY.TASK_ID TASK_ID
, TSK.TASK_NUMBER TASK_NUMBER
, SMRY.INVOICE_ID INVOICE_ID
, SMRY.INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, SMRY.INVOICE_DISTRIBUTION_ID
, SMRY.DOCUMENT_PAYMENT_ID
, SMRY.DOCUMENT_TYPE
, SMRY.DOCUMENT_DISTRIBUTION_TYPE
, SMRY.SI_ASSETS_ADDITION_FLAG
, 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
, SMRY.VENDOR_ID VENDOR_ID
, VND.SEGMENT1 VENDOR_NUMBER
, VND.VENDOR_NAME VENDOR_NAME
, EXP.INCURRED_BY_PERSON_ID PERSON_ID
, EMP.FULL_NAME 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_V SMRY
, PA_PROJECTS_ALL PRJ
, PA_TASKS TSK
, PA_EXPENDITURES_ALL EXP
, PO_VENDORS VND
, PER_PEOPLE_F EMP
WHERE PRJ.PROJECT_ID = TSK.PROJECT_ID
AND TSK.TASK_ID = SMRY.TASK_ID
AND VND.VENDOR_ID(+) = SMRY.VENDOR_ID
AND EXP.EXPENDITURE_ID = SMRY.EXPENDITURE_ID
AND EMP.PERSON_ID(+) = EXP.INCURRED_BY_PERSON_ID

Columns