ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF9F3869E053B46B63588994 SELECT ftso.treasury_symbol old_tp_tas_sup ,ftsn.treasury_symbol new_tp_tas_sup ,aps.vendor_name ,apsa.vendor_site_code ,exception_type FROM fv_roll_tp_tas fvr, fv_tp_treasury_symbols ftso, fv_tp_treasury_symbols ftsn, ap_suppliers aps, ap_supplier_sites_all apsa WHERE fvr.org_id = :P_ORG_ID AND fvr.party_type = 'S' AND fvr.new_tp_tas_id IS NOT NULL AND fvr.exception_type IS NULL AND ftso.treasury_symbol_id = fvr.old_tp_tas_id AND ftsn.treasury_symbol_id(+) = fvr.new_tp_tas_id AND aps.vendor_id = fvr.party_id AND apsa.vendor_site_id = fvr.party_acct_site_id ORDER BY aps.vendor_name Y FV FVRLTPTAS US FV Party Trading Partner TAS Application: Federal Financials Source: Party Trading Partner TAS Report Short Name: FVRLTPTAS DB package: BI Publisher :p_org_id