View: ICX_PO_MATCHED_INVOICES_V

Product:	ICX - Oracle iProcurement
Description:	Obsolete
Implementation/DBA Data:	APPS.ICX_PO_MATCHED_INVOICES_V

View Text

SELECT API.INVOICE_ID
, API.INVOICE_NUM
, API.INVOICE_DATE
, API.DUE_DATE
, TO_CHAR( API.GROSS_AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( API.INVOICE_CURRENCY_CODE
, 30 ))
, TO_CHAR( API.DISCOUNT_AMOUNT_AVAILABLE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( API.INVOICE_CURRENCY_CODE
, 30 ))
, API.INVOICE_CURRENCY_CODE
, TO_CHAR( API.AMOUNT_REMAINING
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( API.INVOICE_CURRENCY_CODE
, 30 ))
, API.PAYMENT_STATUS
, API.PAYMENT_NUMBER
, PSO.PO_NUM
, TO_CHAR( PSO.AMOUNT
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PSO.CURRENCY_CODE
, 30 ))
, PSO.CURRENCY_CODE
, PSO.AGENT_NAME
, PSO.AGENT_ID
, PSO.VENDOR_NAME
, PSO.VENDOR_ID
, PSO.VENDOR_SITE_CODE
, PSO.VENDOR_SITE_ID
, PSO.VENDOR_CONTACT
, PSO.VENDOR_CONTACT_ID
, PSO.PO_HEADER_ID
, PSO.PO_RELEASE_ID
, PSO.SUPPLIER_URL
FROM ICX_AP_INVOICES_V API
, ICX_PO_SUPPLIER_ORDERS_V PSO
WHERE (PSO.PO_HEADER_ID
, API.INVOICE_ID
, NVL(PSO.PO_RELEASE_ID
, -1)) IN (SELECT POD.PO_HEADER_ID
, APD.INVOICE_ID
, NVL(POD.PO_RELEASE_ID
, -1)
FROM PO_DISTRIBUTIONS POD
, AP_INVOICE_DISTRIBUTIONS APD
WHERE POD.PO_DISTRIBUTION_ID = APD.PO_DISTRIBUTION_ID
AND POD.PO_HEADER_ID = PSO.PO_HEADER_ID
AND APD.INVOICE_ID = API.INVOICE_ID)

Columns