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 656: FROM ap_vendors_v

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

Line 688: FROM ap_vendors_v

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

Line 966: l_ven_rec ap_vendors_v%ROWTYPE;

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

Line 1055: FROM ap_vendors_v

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