VIEW: APPS.PA_GL_COST_EXCEPT_DET_V

Source

View Text - Preformatted

SELECT /*+ USE_NL (SMRY, EXP) */ 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 , SMRY.INVOICE_DISTRIBUTION_ID , SMRY.INVOICE_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.GL_DATE GL_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 , (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.org_id ORG_ID , SMRY.same_pa_gl_period , PA_EXPENDITURES_UTILS.getorgtlname(smry.org_id) , smry.set_of_books_id , smry.unit_of_measure FROM PA_GL_COST_EXCEPT_SUM_V SMRY, PA_PROJECTS_ALL PRJ, PA_TASKS TSK, PA_EXPENDITURES_ALL EXP, PO_VENDORS VND 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

View Text - HTML Formatted

SELECT /*+ USE_NL (SMRY
, EXP) */ 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
, SMRY.INVOICE_DISTRIBUTION_ID
, SMRY.INVOICE_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.GL_DATE GL_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
, (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.ORG_ID ORG_ID
, SMRY.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(SMRY.ORG_ID)
, SMRY.SET_OF_BOOKS_ID
, SMRY.UNIT_OF_MEASURE
FROM PA_GL_COST_EXCEPT_SUM_V SMRY
, PA_PROJECTS_ALL PRJ
, PA_TASKS TSK
, PA_EXPENDITURES_ALL EXP
, PO_VENDORS VND
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