DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on AP_SUPPLIERS

Line 4155: LEFT OUTER JOIN ap_suppliers s

4151: LEFT OUTER JOIN hz_cust_site_uses_all ps
4152: ON ps.site_use_id = t.party_site_id
4153: LEFT OUTER JOIN ap_supplier_sites_all ss
4154: ON ss.vendor_site_id = t.party_site_id
4155: LEFT OUTER JOIN ap_suppliers s
4156: ON s.vendor_id = t.party_id
4157: WHERE (t.party_type_code IS NULL
4158: AND ((c.cust_account_id IS NOT NULL )OR (t.party_site_id IS NOT NULL AND ps.site_use_id IS NULL ))
4159: )