eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AP_APPLY_PREPAYS_FR_PREPAY_V

Source

View Text - Preformatted


SELECT AI.ROWID ROW_ID, AI.INVOICE_ID INVOICE_ID, AI.INVOICE_NUM INVOICE_NUM, AI.VENDOR_ID VENDOR_ID, AI.VENDOR_SITE_ID VENDOR_SITE_ID, PV.VENDOR_NAME VENDOR_NAME, PV.SEGMENT1 VENDOR_NUMBER, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, AI.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE, AI.INVOICE_DATE INVOICE_DATE, AI.PAYMENT_CROSS_RATE_DATE PAYMENT_CROSS_RATE_DATE, AI.PAYMENT_CROSS_RATE_TYPE PAYMENT_CROSS_RATE_TYPE, AI.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, AI.DESCRIPTION DESCRIPTION, AI.ORG_ID ORG_ID, AP_PREPAY_UTILS_PKG.GET_INVOICE_UNPAID_AMOUNT( AI.INVOICE_ID) AMOUNT_UNPAID, NULLIF(AP_PREPAY_UTILS_PKG.GET_INCLUSIVE_TAX_UNPAID_AMT( AI.INVOICE_ID), 0) TAX_AMOUNT_UNPAID FROM AP_INVOICES AI, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS WHERE AI.VENDOR_ID = PV.VENDOR_ID AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID AND AI.INVOICE_TYPE_LOOKUP_CODE NOT IN ('PREPAYMENT', 'CREDIT','DEBIT') AND AI.PAYMENT_STATUS_FLAG IN ('N','P') AND 0 < (SELECT SUM(APS.AMOUNT_REMAINING) FROM AP_PAYMENT_SCHEDULES_ALL APS WHERE APS.INVOICE_ID = AI.INVOICE_ID) AND NOT EXISTS (SELECT 'INVOICE SELECTED FOR PAYMENT' FROM AP_SELECTED_INVOICES_ALL ASI WHERE ASI.INVOICE_ID = AI.INVOICE_ID)

View Text - HTML Formatted

SELECT AI.ROWID ROW_ID
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_NUM INVOICE_NUM
, AI.VENDOR_ID VENDOR_ID
, AI.VENDOR_SITE_ID VENDOR_SITE_ID
, PV.VENDOR_NAME VENDOR_NAME
, PV.SEGMENT1 VENDOR_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, AI.PAYMENT_CURRENCY_CODE PAYMENT_CURRENCY_CODE
, AI.INVOICE_DATE INVOICE_DATE
, AI.PAYMENT_CROSS_RATE_DATE PAYMENT_CROSS_RATE_DATE
, AI.PAYMENT_CROSS_RATE_TYPE PAYMENT_CROSS_RATE_TYPE
, AI.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AI.DESCRIPTION DESCRIPTION
, AI.ORG_ID ORG_ID
, AP_PREPAY_UTILS_PKG.GET_INVOICE_UNPAID_AMOUNT( AI.INVOICE_ID) AMOUNT_UNPAID
, NULLIF(AP_PREPAY_UTILS_PKG.GET_INCLUSIVE_TAX_UNPAID_AMT( AI.INVOICE_ID)
, 0) TAX_AMOUNT_UNPAID
FROM AP_INVOICES AI
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
WHERE AI.VENDOR_ID = PV.VENDOR_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AI.INVOICE_TYPE_LOOKUP_CODE NOT IN ('PREPAYMENT'
, 'CREDIT'
, 'DEBIT')
AND AI.PAYMENT_STATUS_FLAG IN ('N'
, 'P')
AND 0 < (SELECT SUM(APS.AMOUNT_REMAINING)
FROM AP_PAYMENT_SCHEDULES_ALL APS
WHERE APS.INVOICE_ID = AI.INVOICE_ID)
AND NOT EXISTS (SELECT 'INVOICE SELECTED FOR PAYMENT'
FROM AP_SELECTED_INVOICES_ALL ASI
WHERE ASI.INVOICE_ID = AI.INVOICE_ID)