APPS.INV_KANBAN_PKG dependencies on PO_VENDORS

Line 466: FROM po_vendors

462: BEGIN
463: OPEN x_kanban_ref FOR
464: SELECT vendor_name
465: , vendor_id
466: FROM po_vendors
467: WHERE vendor_name LIKE (p_supplier_name);
468: END getsupplierlov;
469:
470: PROCEDURE getsuppliersitelov(x_kanban_ref OUT NOCOPY t_genref, p_supplier_site IN VARCHAR2, p_vendor_id IN NUMBER) IS

Line 549: , po_vendors pv

545: , mfg_lookups mfg3
546: , mfg_lookups mfg4
547: , mfg_lookups mfg5
548: , mfg_lookups mfg6
549: , po_vendors pv
550: , mtl_kanban_card_activity mka
551: , po_vendor_sites_all pvsa
552: , mtl_kanban_pull_sequences mkps
553: , wip_lines wl

Line 555: , po_vendors pv_act

551: , po_vendor_sites_all pvsa
552: , mtl_kanban_pull_sequences mkps
553: , wip_lines wl
554: , wip_lines wl_act
555: , po_vendors pv_act
556: , mtl_item_locations mil
557: , po_vendor_sites_all pvsa_act
558: WHERE mkc.kanban_card_number LIKE (p_kanban_card_number || '%') -- 3231139
559: AND mkc.organization_id = p_org_id

Line 631: FROM po_vendors pv

627: , pv.vendor_id
628: , pvs.vendor_site_id
629: , 1 tp_type
630: , 'Supplier' party_type
631: FROM po_vendors pv
632: , po_vendor_sites_all pvs
633: , org_organization_definitions ood
634: WHERE pv.vendor_id = pvs.vendor_id
635: AND pvs.org_id = ood.organization_id (+)