AP_INV_LE_DETAILS_V

Details

• Schema: FUSION

• Object owner: AP

• Object type: VIEW

Columns

Name
INVOICE_ID LEGAL_ENTITY_ID LEGAL_ENTITY_NAME TYPE_OF_COMPANY LEGAL_EMPLOYER_FLAG LEGAL_ENTITY_COUNTRY_CODE

Query

SQL_Statement
SELECT inv.invoice_id, inv.legal_entity_id, le.name "LEGAL_ENTITY_NAME", le.type_of_company "TYPE_OF_COMPANY", le.legal_employer_flag "LEGAL_EMPLOYER_FLAG", geo.country_code "LEGAL_ENTITY_COUNTRY_CODE" FROM ap_invoices_all inv, xle_entity_profiles le, hz_geographies geo WHERE inv.legal_entity_id = le.legal_entity_id AND le.geography_id = geo.geography_id