View: AP_INVOICE_PREPAYS_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.AP_INVOICE_PREPAYS_V

View Text

SELECT AIPP.ROWID ROW_ID
, AIPP.INVOICE_ID INVOICE_ID
, AIPP.CREATED_BY CREATED_BY
, AIPP.CREATION_DATE CREATION_DATE
, AIPP.DATE_REPORTED DATE_REPORTED
, AIPP.LAST_UPDATED_BY LAST_UPDATED_BY
, AIPP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AIPP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AIPP.ORG_ID ORG_ID
, AIPP.PREPAYMENT_AMOUNT_APPLIED PREPAYMENT_AMOUNT_APPLIED
, AIPP.PREPAY_ID PREPAY_ID
, AI.VENDOR_ID VENDOR_ID
, AI.VENDOR_PREPAY_AMOUNT VENDOR_PREPAY_AMOUNT
, AI.VENDOR_SITE_ID VENDOR_SITE_ID
, PV.VENDOR_NAME VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AI.DESCRIPTION DESCRIPTION
, AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_DATE INVOICE_DATE
, AI.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, AI.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, NVL(AI.PAY_CURR_INVOICE_AMOUNT
, AI.INVOICE_AMOUNT) PAY_CURR_INVOICE_AMOUNT
, 'PREPAYMENT' PREPAYMENT_FLAG
FROM AP_INVOICE_PREPAYS AIPP
, AP_INVOICES AI
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
WHERE AIPP.PREPAY_ID = AI.INVOICE_ID
AND AI.VENDOR_ID = PV.VENDOR_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID UNION SELECT /* PURPOSE: THE VIEW AP_INVOICE_PREPAYS_V IS FOR USE AS A BASE TABLE */ /* FOR ORACLE FORMS 4.5 PROGRAMS (RELEASE 10G) */ /* VIEW: THESE INVOICES (WITH PREPAYMENT_FLAG = 'INVOICE') */ /* RETURN ALL THE INVOICES NUM
AND AMOUNT */ /* FORM USE: APPLY PREPAYMENT (APXIWPAA) */ AIPP.ROWID ROW_ID
, AIPP.INVOICE_ID INVOICE_ID
, AIPP.CREATED_BY CREATED_BY
, AIPP.CREATION_DATE CREATION_DATE
, AIPP.DATE_REPORTED DATE_REPORTED
, AIPP.LAST_UPDATED_BY LAST_UPDATED_BY
, AIPP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AIPP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AIPP.ORG_ID ORG_ID
, AIPP.PREPAYMENT_AMOUNT_APPLIED PREPAYMENT_AMOUNT_APPLIED
, AIPP.PREPAY_ID PREPAY_ID
, AI.VENDOR_ID VENDOR_ID
, AI.VENDOR_PREPAY_AMOUNT VENDOR_PREPAY_AMOUNT
, AI.VENDOR_SITE_ID VENDOR_SITE_ID
, PV.VENDOR_NAME VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AI.DESCRIPTION DESCRIPTION
, AI.INVOICE_NUM INVOICE_NUM
, AI.INVOICE_DATE INVOICE_DATE
, AI.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, AI.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SUM(APS.AMOUNT_REMAINING) PAY_CURR_INVOICE_AMOUNT
, 'INVOICE' PREPAYMENT_FLAG
FROM AP_INVOICE_PREPAYS AIPP
, AP_INVOICES AI
, AP_PAYMENT_SCHEDULES APS
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
WHERE AIPP.INVOICE_ID = AI.INVOICE_ID
AND AI.VENDOR_ID = PV.VENDOR_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AIPP.INVOICE_ID = APS.INVOICE_ID GROUP BY AIPP.ROWID
, AIPP.INVOICE_ID
, AIPP.CREATED_BY
, AIPP.CREATION_DATE
, AIPP.DATE_REPORTED
, AIPP.LAST_UPDATED_BY
, AIPP.LAST_UPDATE_DATE
, AIPP.LAST_UPDATE_LOGIN
, AIPP.ORG_ID
, AIPP.PREPAYMENT_AMOUNT_APPLIED
, AIPP.PREPAY_ID
, AI.VENDOR_ID
, AI.VENDOR_PREPAY_AMOUNT
, AI.VENDOR_SITE_ID
, PV.VENDOR_NAME
, PV.SEGMENT1
, PVS.VENDOR_SITE_CODE
, AI.DESCRIPTION
, AI.INVOICE_NUM
, AI.INVOICE_DATE
, AI.PAYMENT_CURRENCY_CODE
, AI.SET_OF_BOOKS_ID

Columns