VIEW: APPS.AP_PA_HEADER_REF_V

Source

View Text - Preformatted

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, AI.Payment_Method_Code AI_Payment_Method_Code 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

View Text - HTML Formatted

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
, AI.PAYMENT_METHOD_CODE AI_PAYMENT_METHOD_CODE
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