FV Party Trading Partner TAS

Categories: BI Publisher
Application: Federal Financials
Source: Party Trading Partner TAS Report
DB package:
Run FV Party Trading Partner TAS and other Oracle EBS reports with Blitz Report™ on our demo environment
 SELECT ftso.treasury_symbol old_tp_tas_sup
      ,ftsn.treasury_symbol new_tp_tas_sup
  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