Query To Check Intercompany Suppliers – Fusion
FUN_IC_CUST_SUPP_MAP --Intercompany customer and supplier assignments.
poz_suppliers -- vendor_type_lookup_code -- Inter Company Vendors
-------------
select
ps.*
from FUN_IC_CUST_SUPP_MAP fics, poz_suppliers ps
where 1=1
and fics.vendor_id = ps.vendor_id
Comments |0|
Category: OracleSaaSQueries