APPS.INV_KANBAN_PKG dependencies on PO_VENDOR_SITES_ALL

Line 83: FROM po_vendor_sites_all

79: RETURN NULL;
80: ELSE
81: SELECT vendor_site_code
82: INTO supplier_site_name
83: FROM po_vendor_sites_all
84: WHERE vendor_site_id = supplier_site_id;
85:
86: RETURN supplier_site_name;
87: END IF;

Line 464: FROM po_vendor_sites_all

460: BEGIN
461: OPEN x_kanban_ref FOR
462: SELECT vendor_site_code
463: , vendor_site_code_alt
464: FROM po_vendor_sites_all
465: WHERE vendor_site_code LIKE (p_supplier_site)
466: AND vendor_id = p_vendor_id;
467: END getsuppliersitelov;
468:

Line 540: , po_vendor_sites_all pvsa

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
543: , wip_lines wl_act
544: , po_vendors pv_act

Line 546: , po_vendor_sites_all pvsa_act

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
549: AND mkc.inventory_item_id = NVL(p_item_id, mkc.inventory_item_id)
550: AND mkc.source_type = NVL(p_source_type_id, mkc.source_type)

Line 621: , po_vendor_sites_all pvs

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 (+)
625: AND pv.vendor_name || '-' || pvs.vendor_site_code LIKE p_vendor