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 475: FROM po_vendor_sites_all

471: BEGIN
472: OPEN x_kanban_ref FOR
473: SELECT vendor_site_code
474: , vendor_site_code_alt
475: FROM po_vendor_sites_all
476: WHERE vendor_site_code LIKE (p_supplier_site)
477: AND vendor_id = p_vendor_id;
478: END getsuppliersitelov;
479:

Line 551: , po_vendor_sites_all pvsa

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
554: , wip_lines wl_act
555: , po_vendors pv_act

Line 557: , po_vendor_sites_all pvsa_act

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

Line 632: , po_vendor_sites_all pvs

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