VIEW: APPS.ICX_PO_MATCHED_INVOICES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)