APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 68: ap_supplier_sites_all c,

64: b.segment1 C_OLD_VENDOR_NUMBER
65: FROM ap_duplicate_vendors_all dv,
66: ap_suppliers a,
67: ap_suppliers b,
68: ap_supplier_sites_all c,
69: ap_supplier_sites_all d
70: WHERE dv.process_flag='S'
71: AND a.vendor_id=dv.vendor_id
72: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)

Line 69: ap_supplier_sites_all d

65: FROM ap_duplicate_vendors_all dv,
66: ap_suppliers a,
67: ap_suppliers b,
68: ap_supplier_sites_all c,
69: ap_supplier_sites_all d
70: WHERE dv.process_flag='S'
71: AND a.vendor_id=dv.vendor_id
72: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)
73: AND b.vendor_id=dv.duplicate_vendor_id

Line 103: ap_supplier_sites_all c,

99: b.segment1 C_OLD_VENDOR_NUMBER
100: FROM ap_duplicate_vendors_all dv,
101: ap_suppliers a,
102: ap_suppliers b,
103: ap_supplier_sites_all c,
104: ap_supplier_sites_all d
105: WHERE dv.process_flag in ('S','D')
106: AND a.vendor_id=dv.vendor_id
107: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)

Line 104: ap_supplier_sites_all d

100: FROM ap_duplicate_vendors_all dv,
101: ap_suppliers a,
102: ap_suppliers b,
103: ap_supplier_sites_all c,
104: ap_supplier_sites_all d
105: WHERE dv.process_flag in ('S','D')
106: AND a.vendor_id=dv.vendor_id
107: AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id)
108: AND b.vendor_id=dv.duplicate_vendor_id

Line 151: from ap_supplier_sites_all

147: /* Bug 9551257 End */
148: /* Bug 12555081 - pos not merged after vendor merge completes successfully-start */
149: select org_id
150: into l_org_id
151: from ap_supplier_sites_all
152: where vendor_site_id = v_dup_vendor_site_id;
153:
154: mo_global.set_policy_context('S', l_org_id);
155:

Line 168: FROM ap_supplier_sites_all

164: l_invoice_row.C_VENDOR_SITE_ID IS NULL THEN
165:
166: SELECT vendor_site_id
167: INTO l_invoice_row.C_VENDOR_SITE_ID
168: FROM ap_supplier_sites_all
169: WHERE vendor_id = l_invoice_row.C_VENDOR_ID
170: AND vendor_site_code = l_invoice_row.C_VENDOR_SITE_CODE
171: AND org_id = l_invoice_row.C_ORG_ID; --Bug#7307532
172:

Line 181: FROM ap_suppliers aps, ap_supplier_sites_all apps

177: FND_FILE.Put_Line(FND_FILE.Log,'Calling IBY API - Start');
178:
179: SELECT count(apps.vendor_site_id)
180: INTO l_active_site_count
181: FROM ap_suppliers aps, ap_supplier_sites_all apps
182: WHERE aps.vendor_id = l_invoice_row.C_DUP_VENDOR_ID
183: AND aps.vendor_id = apps.vendor_id
184: AND apps.vendor_site_id <> l_invoice_row.C_DUP_VENDOR_SITE_ID
185: AND apps.pay_site_flag = 'Y'

Line 649: FROM ap_supplier_sites_all

645: l_po_row.C_VENDOR_SITE_ID IS NULL THEN
646:
647: SELECT vendor_site_id
648: INTO l_po_row.C_VENDOR_SITE_ID
649: FROM ap_supplier_sites_all
650: WHERE vendor_id = l_po_row.C_VENDOR_ID
651: AND vendor_site_code = l_po_row.C_VENDOR_SITE_CODE
652: AND org_id = l_po_row.C_ORG_ID; --Bug#7307532
653: