View: AP_PA_HEADER_REF_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_PA_HEADER_REF_V

View Text

SELECT AI.INVOICE_ID AI_INVOICE_ID
, AI.INVOICE_NUM INV_TRANSACTION_NUMBER
, AI.INVOICE_TYPE_LOOKUP_CODE AI_INVOICE_TYPE_LOOKUP_CODE
, AI.INVOICE_CURRENCY_CODE AI_INVOICE_CURRENCY_CODE
, AI.INVOICE_DATE AI_INVOICE_DATE
, AI.CANCELLED_DATE AI_CANCELLED_DATE
, AI.DESCRIPTION AI_DESCRIPTION
, AI.VENDOR_ID AI_VENDOR_ID
, APS.VENDOR_NAME POV_VENDOR_NAME
, AI.VENDOR_SITE_ID AI_VENDOR_SITE_ID
, APSS.VENDOR_SITE_CODE POS_VENDOR_SITE_CODE
, AI.PARTY_ID AI_PARTY_ID
, AI.PARTY_SITE_ID AI_PARTY_SITE_ID
, (SELECT HZP.PARTY_NAME
FROM HZ_PARTIES HZP
WHERE HZP.PARTY_ID = AI.PARTY_ID) AI_PARTY_NAME
, (SELECT HPS.PARTY_SITE_NAME
FROM HZ_PARTY_SITES HPS
WHERE HPS.PARTY_SITE_ID = AI.PARTY_SITE_ID) AI_PARTY_SITE_NAME
FROM AP_INVOICES_ALL AI
, AP_SUPPLIERS APS
, AP_SUPPLIER_SITES_ALL APSS
WHERE AI.VENDOR_ID = APS.VENDOR_ID
AND AI.VENDOR_SITE_ID = APSS.VENDOR_SITE_ID
AND APS.VENDOR_ID = APSS.VENDOR_ID

Columns