APPS.PO_RFQS_SV dependencies on PO_VENDOR_LIST_ENTRIES_V

Line 184: Using po_vendor_list_entries_v to get the count

180:
181: X_progress := '010';
182:
183: /* Bug 875124 :
184: Using po_vendor_list_entries_v to get the count
185: as po_vendor_list_entries_v contains vendor_list with active vendors
186: */
187: SELECT count(*)
188: INTO X_vendor_count

Line 185: as po_vendor_list_entries_v contains vendor_list with active vendors

181: X_progress := '010';
182:
183: /* Bug 875124 :
184: Using po_vendor_list_entries_v to get the count
185: as po_vendor_list_entries_v contains vendor_list with active vendors
186: */
187: SELECT count(*)
188: INTO X_vendor_count
189: FROM po_vendor_list_entries_v

Line 189: FROM po_vendor_list_entries_v

185: as po_vendor_list_entries_v contains vendor_list with active vendors
186: */
187: SELECT count(*)
188: INTO X_vendor_count
189: FROM po_vendor_list_entries_v
190: WHERE vendor_list_header_id = X_vendor_list_header_id;
191:
192: X_progress := '020';
193:

Line 363: Using po_vendor_list_entries_v to insert into po_rfq_vendors

359:
360: X_progress := '020';
361:
362: /* Bug 875124 :
363: Using po_vendor_list_entries_v to insert into po_rfq_vendors
364: as po_vendor_list_entries_v contains vendor_list with active vendors
365: */
366: insert into po_rfq_vendors
367: (po_header_id,

Line 364: as po_vendor_list_entries_v contains vendor_list with active vendors

360: X_progress := '020';
361:
362: /* Bug 875124 :
363: Using po_vendor_list_entries_v to insert into po_rfq_vendors
364: as po_vendor_list_entries_v contains vendor_list with active vendors
365: */
366: insert into po_rfq_vendors
367: (po_header_id,
368: sequence_num,

Line 392: from po_vendor_list_entries_v vle

388: vle.vendor_site_id,
389: vle.vendor_contact_id,
390: 'Y',
391: '0'
392: from po_vendor_list_entries_v vle
393: where vle.vendor_list_header_id = X_list_header_id
394: and not exists (select 'vendor already there'
395: from po_rfq_vendors rv
396: where vle.vendor_site_id = rv.vendor_site_id