eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 56: ap_supplier_sites_all c,

52: b.segment1 C_OLD_VENDOR_NUMBER
53: FROM ap_duplicate_vendors_all dv,
54: ap_suppliers a,
55: ap_suppliers b,
56: ap_supplier_sites_all c,
57: ap_supplier_sites_all d
58: WHERE dv.process_flag='S'
59: AND a.vendor_id=dv.vendor_id
60: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)

Line 57: ap_supplier_sites_all d

53: FROM ap_duplicate_vendors_all dv,
54: ap_suppliers a,
55: ap_suppliers b,
56: ap_supplier_sites_all c,
57: ap_supplier_sites_all d
58: WHERE dv.process_flag='S'
59: AND a.vendor_id=dv.vendor_id
60: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)
61: AND b.vendor_id=dv.duplicate_vendor_id

Line 90: ap_supplier_sites_all c,

86: b.segment1 C_OLD_VENDOR_NUMBER
87: FROM ap_duplicate_vendors_all dv,
88: ap_suppliers a,
89: ap_suppliers b,
90: ap_supplier_sites_all c,
91: ap_supplier_sites_all d
92: WHERE dv.process_flag in ('S','D')
93: AND a.vendor_id=dv.vendor_id
94: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)

Line 91: ap_supplier_sites_all d

87: FROM ap_duplicate_vendors_all dv,
88: ap_suppliers a,
89: ap_suppliers b,
90: ap_supplier_sites_all c,
91: ap_supplier_sites_all d
92: WHERE dv.process_flag in ('S','D')
93: AND a.vendor_id=dv.vendor_id
94: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)
95: AND b.vendor_id=dv.duplicate_vendor_id

Line 119: FROM ap_supplier_sites_all

115: l_invoice_row.C_VENDOR_SITE_ID IS NULL THEN
116:
117: SELECT vendor_site_id
118: INTO l_invoice_row.C_VENDOR_SITE_ID
119: FROM ap_supplier_sites_all
120: WHERE vendor_id = l_invoice_row.C_VENDOR_ID
121: AND vendor_site_code = l_invoice_row.C_VENDOR_SITE_CODE
122: AND org_id = l_invoice_row.C_ORG_ID; --Bug#7307532
123:

Line 451: FROM ap_supplier_sites_all

447: l_po_row.C_VENDOR_SITE_ID IS NULL THEN
448:
449: SELECT vendor_site_id
450: INTO l_po_row.C_VENDOR_SITE_ID
451: FROM ap_supplier_sites_all
452: WHERE vendor_id = l_po_row.C_VENDOR_ID
453: AND vendor_site_code = l_po_row.C_VENDOR_SITE_CODE
454: AND org_id = l_po_row.C_ORG_ID; --Bug#7307532
455: