APPS.INV_KANBAN_PKG dependencies on PO_VENDORS

Line 455: FROM po_vendors

451: BEGIN
452: OPEN x_kanban_ref FOR
453: SELECT vendor_name
454: , vendor_id
455: FROM po_vendors
456: WHERE vendor_name LIKE (p_supplier_name);
457: END getsupplierlov;
458:
459: PROCEDURE getsuppliersitelov(x_kanban_ref OUT NOCOPY t_genref, p_supplier_site IN VARCHAR2, p_vendor_id IN NUMBER) IS

Line 538: , po_vendors pv

534: , mfg_lookups mfg3
535: , mfg_lookups mfg4
536: , mfg_lookups mfg5
537: , mfg_lookups mfg6
538: , po_vendors pv
539: , mtl_kanban_card_activity mka
540: , po_vendor_sites_all pvsa
541: , mtl_kanban_pull_sequences mkps
542: , wip_lines wl

Line 544: , po_vendors pv_act

540: , po_vendor_sites_all pvsa
541: , mtl_kanban_pull_sequences mkps
542: , wip_lines wl
543: , wip_lines wl_act
544: , po_vendors pv_act
545: , mtl_item_locations mil
546: , po_vendor_sites_all pvsa_act
547: WHERE mkc.kanban_card_number LIKE (p_kanban_card_number || '%') -- 3231139
548: AND mkc.organization_id = p_org_id

Line 620: FROM po_vendors pv

616: , pv.vendor_id
617: , pvs.vendor_site_id
618: , 1 tp_type
619: , 'Supplier' party_type
620: FROM po_vendors pv
621: , po_vendor_sites_all pvs
622: , org_organization_definitions ood
623: WHERE pv.vendor_id = pvs.vendor_id
624: AND pvs.org_id = ood.organization_id (+)