APPS.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on AP_VENDORS_V

Line 179: FROM ap_vendors_v

175: x.GLOBAL_ATTRIBUTE11, x.GLOBAL_ATTRIBUTE12, x.GLOBAL_ATTRIBUTE13, x.GLOBAL_ATTRIBUTE14,
176: x.GLOBAL_ATTRIBUTE15, x.GLOBAL_ATTRIBUTE16, x.GLOBAL_ATTRIBUTE17, x.GLOBAL_ATTRIBUTE18,
177: x.GLOBAL_ATTRIBUTE19, x.GLOBAL_ATTRIBUTE20, x.GLOBAL_ATTRIBUTE_CATEGORY, x.BANK_CHARGE_BEARER,
178: x.MATCH_OPTION, x.CREATE_DEBIT_MEMO_FLAG, x.TERMS_NAME, x.NI_NUMBER
179: FROM ap_vendors_v
180: WHERE vendor_id = p_vendor_id ;
181:
182: IF l_debug_level <= 1 then
183: itg_debug_pub.add('Exiting get_vendor_rec normal');

Line 315: from ap_vendors_v

311:
312: IF UPPER(p_syncind) = 'A' THEN
313: select count(*)
314: into l_var
315: from ap_vendors_v
316: Where upper(vendor_name) = upper(p_name);
317:
318: IF to_number(l_var) > 0 THEN
319: itg_msg.dup_vendor;

Line 350: from ap_vendors_v

346:
347: -- change
348: select count(*)
349: into l_var
350: from ap_vendors_v
351: where nvl(vendor_number,'@@') = nvl(to_char(p_partnerid),'@@')
352: and nvl(upper(p_name),'@@') <> nvl(Upper(vendor_name),'@@');
353:
354: IF to_number(l_var) > 0 THEN

Line 654: FROM ap_vendors_v

650: g_action := 'verifying vendor_number';
651: BEGIN
652: SELECT vendor_number
653: INTO l_override_vendornum
654: FROM ap_vendors_v
655: WHERE vendor_id = r_vendor_rec.vendor_id;
656: IF l_debug_level <= 1 THEN
657: itg_debug_pub.Add('SV - segment1 '|| l_override_vendornum ,1);
658: END IF;

Line 686: FROM ap_vendors_v

682:
683: BEGIN
684: SELECT vendor_id
685: INTO r_vendor_rec.vendor_id
686: FROM ap_vendors_v
687: WHERE vendor_name = p_name;
688:
689: x_vinfo_rec.vendor_id := r_vendor_rec.vendor_id;
690:

Line 964: l_ven_rec ap_vendors_v%ROWTYPE;

960: l_msg_count NUMBER;
961: l_vendor_site_id NUMBER;
962: l_party_id NUMBER;
963: l_location_id NUMBER;
964: l_ven_rec ap_vendors_v%ROWTYPE;
965: l_api_name VARCHAR2(50);
966: l_vendorsite_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
967: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
968: p_object_version_number NUMBER;

Line 1053: FROM ap_vendors_v

1049: g_action := 'query vendor details';
1050:
1051: SELECT *
1052: INTO l_ven_rec
1053: FROM ap_vendors_v
1054: WHERE vendor_id = p_vinfo_rec.vendor_id;
1055:
1056: EXCEPTION
1057: WHEN NO_DATA_FOUND THEN