AP_INV_VENDOR_DETAILS_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name
INVOICE_ID VENDOR_ID INVOICE_SUPPLIER_TYPE INVOICE_SUPP_ORG_TYPE INVOICE_SUPP_TAX_COUNTRY

Query

SQL_Statement
SELECT inv.invoice_id, inv.vendor_id, vendor.vendor_type_lookup_code "INVOICE_SUPPLIER_TYPE", vendor.organization_type_lookup_code "INVOICE_SUPP_ORG_TYPE", vendor.taxpayer_country "INVOICE_SUPP_TAX_COUNTRY" FROM poz_suppliers vendor, ap_invoices_all inv WHERE vendor.vendor_id = inv.vendor_id