View: PA_AP_INV_EXCEPTIONS_DET_V

Product:	PA - Projects
Description:	Details of Oracle Payables invoices that prevent a period from being cloded.
Implementation/DBA Data:	APPS.PA_AP_INV_EXCEPTIONS_DET_V

View Text

SELECT SMRY.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_NUMBER INVOICE_NUMBER
, SMRY.INVOICE_DATE INVOICE_DATE /* REL12 AP LINES UPTAKE START */
, SMRY.INVOICE_LINE_NUMBER
, SMRY.INVOICE_DISTRIBUTION_ID /* REL12 AP LINES UPTAKE END */
, SMRY.DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, SMRY.VENDOR_ID VENDOR_ID
, VND.SEGMENT1 VENDOR_NUMBER
, VND.VENDOR_NAME VENDOR_NAME
, SMRY.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, SMRY.EXPENDITURE_TYPE EXPENDITURE_TYPE
, SMRY.QUANTITY QUANTITY
, SMRY.DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, SMRY.DENOM_AMOUNT DENOM_AMOUNT
, SMRY.ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, SMRY.AMOUNT AMOUNT
, SMRY.ACCT_RATE_DATE ACCT_RATE_DATE
, SMRY.ACCT_RATE_TYPE ACCT_RATE_TYPE
, SMRY.ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, SMRY.PA_DATE PA_DATE
, SMRY.PERIOD_NAME PERIOD_NAME
, SMRY.GL_DATE GL_DATE
, SMRY.GL_PERIOD_NAME GL_PERIOD_NAME
, SMRY.POSTED_FLAG POSTED_FLAG
, SMRY.EXCEPTION_CODE EXCEPTION_CODE
, SMRY.EXCEPTION_REASON EXCEPTION_REASON
, SMRY.CORRECTIVE_ACTION CORRECTIVE_ACTION
, SMRY.ORG_ID
, SMRY.SAME_PA_GL_PERIOD
, IMP.SET_OF_BOOKS_ID
, SMRY.PAYMENT_NUM
, SMRY.CHECK_NUMBER
FROM PA_AP_INV_EXCEPTIONS_SUM_V SMRY
, PA_PROJECTS_ALL PRJ
, PA_TASKS TSK
, PO_VENDORS VND
, PA_IMPLEMENTATIONS_ALL IMP
WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID
AND TSK.TASK_ID = SMRY.TASK_ID
AND VND.VENDOR_ID = SMRY.VENDOR_ID

Columns