FV Party Trading Partner TAS Not Found

➜ Back to Library
Description
Categories: BI Publisher
Application: Federal Financials
Source: Party Trading Partner TAS Not Found Report
Short Name: FVTPTASNF
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

 SELECT ftso.treasury_symbol old_tp_tas_sup
      ,aps.vendor_name
      ,apsa.vendor_site_code
      ,exception_type
  FROM fv_roll_tp_tas fvr, fv_tp_treasury_symbols ftso,
       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 NULL
 AND fvr.exception_type = 'NO_NEW_TP_TAS'
 AND ftso.treasury_symbol_id = fvr.old_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
Download
 
Related Blitz Reports
FV Party Trading Partner TAS FV GTAS Interface Exception FV GTAS Activity Balance Exception ECC G-Invoicing, Projects: G-Invoicing AP Cash Requirement - draft FV GTAS Bulk File Interface AP Supplier Statement AP Supplier Upload INV Onhand Quantities
Blitz Report™

Blitz Report™ provides multiple benefits: