View: AP_INVOICES_WWW_V

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

View Text

SELECT AI.DESCRIPTION DESCRIPTION
, AI.INVOICE_AMOUNT INVOICE_AMOUNT
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TO_CHAR(AI.INVOICE_AMOUNT) || ' ' || AI.INVOICE_CURRENCY_CODE INVOICE_AMOUNT_CURRENCY_CODE
, TO_CHAR(AP_INVOICES_PKG.GET_AMOUNT_WITHHELD(AI.INVOICE_ID)) || ' ' || AI.INVOICE_CURRENCY_CODE WITHHELD_AMOUNT_CURRENCY_CODE
, AI.INVOICE_DATE INVOICE_DATE
, AI.INVOICE_ID INVOICE_ID
, AI.INVOICE_NUM INVOICE_NUM
, APS.DUE_DATE DUE_DATE
, APS.GROSS_AMOUNT GROSS_AMOUNT
, APS.AMOUNT_REMAINING AMOUNT_REMAINING
, APS.DISCOUNT_DATE DISCOUNT_DATE
, APS.DISCOUNT_AMOUNT_AVAILABLE DISCOUNT_AMOUNT_AVAILABLE
, ALC1.DISPLAYED_FIELD INVOICE_TYPE
, ALC2.DISPLAYED_FIELD PAYMENT_STATUS
, AP_INVOICES_PKG.GET_PO_NUMBER_LIST( AI.INVOICE_ID) PO_NUMBER
, AP_INVOICE_PAYMENTS_PKG.GET_PAID_BY_LIST( AI.INVOICE_ID
, APS.PAYMENT_NUM) PAYMENT_NUMBER
, PVS.VENDOR_SITE_CODE VENDOR_SITE_CODE
, AI.VENDOR_SITE_ID VENDOR_SITE_ID
, AI.VENDOR_ID VENDOR_ID
FROM AP_INVOICES AI
, AP_PAYMENT_SCHEDULES APS
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, PO_VENDOR_SITES PVS
WHERE AI.INVOICE_ID = APS.INVOICE_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND ALC1.LOOKUP_TYPE (+) = 'INVOICE TYPE'
AND ALC1.LOOKUP_CODE (+) = AI.INVOICE_TYPE_LOOKUP_CODE
AND ALC2.LOOKUP_TYPE (+) = 'INVOICE PAYMENT STATUS'
AND ALC2.LOOKUP_CODE (+) = AI.PAYMENT_STATUS_FLAG

Columns