VIEW: APPS.AP_INVOICE_PREPAYS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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