VIEW: APPS.PA_COST_EXCEPTIONS_DET_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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