View: POS_AP_INVOICES_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_AP_INVOICES_V

View Text

SELECT AI.DESCRIPTION DESCRIPTION
, TO_CHAR(AI.INVOICE_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) INVOICE_AMOUNT
, AI.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TO_CHAR( POS_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
, TO_CHAR(APS.GROSS_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) GROSS_AMOUNT
, TO_CHAR(APS.AMOUNT_REMAINING
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) AMOUNT_REMAINING
, APS.DISCOUNT_DATE DISCOUNT_DATE
, TO_CHAR(APS.DISCOUNT_AMOUNT_AVAILABLE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( AI.INVOICE_CURRENCY_CODE
, 30)) DISCOUNT_AMOUNT_AVAILABLE
, NULL INVOICE_TYPE
, NULL PAYMENT_STATUS
, POS_AP_INVOICES_PKG.GET_PO_NUMBER_LIST( AI.INVOICE_ID) PO_NUMBER
, POS_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
, PV.EMPLOYEE_ID
, AI.ORG_ID
, HOU.NAME
FROM AP_INVOICES_ALL AI
, AP_PAYMENT_SCHEDULES_ALL APS
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE AI.INVOICE_ID = APS.INVOICE_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND AI.VENDOR_ID = PV.VENDOR_ID
AND HOU.ORGANIZATION_ID = AI.ORG_ID
AND HOU.LANGUAGE = USERENV('LANG')

Columns