VIEW: APPS.PA_AP_INV_EXCEPTIONS_DET_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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