View: PA_GL_COST_EXCEPT_DET_V

Product:	PA - Projects
Description:	PA_GL_COST_EXCEPT_DET_V is a view that identifies the Cost Distribution Lines that prevents the PA GL period from being closed.
Implementation/DBA Data:	APPS.PA_GL_COST_EXCEPT_DET_V

View Text

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

Columns