APPS.INV_KANBAN_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 331: with 'MTL_SYSTEM_ITEMS_VL'.*/

327: l_error_code NUMBER := NULL;
328: l_error_message VARCHAR2(255) := NULL;
329: BEGIN
330: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV'
331: with 'MTL_SYSTEM_ITEMS_VL'.*/
332: SELECT msiv.concatenated_segments
333: , msiv.description
334: , mkcv.kanban_size
335: , mkcv.subinventory_name

Line 364: FROM mtl_kanban_cards_v mkcv, mtl_system_items_vl msiv

360: , x_wip_line
361: , x_supplier_name
362: , supplier_site_id
363: , x_item_id
364: FROM mtl_kanban_cards_v mkcv, mtl_system_items_vl msiv
365: WHERE mkcv.kanban_card_number = p_kanban_card_number
366: AND mkcv.organization_id = p_org_id
367: AND mkcv.inventory_item_id = msiv.inventory_item_id
368: AND mkcv.organization_id = msiv.organization_id;

Line 496: 'MTL_SYSTEM_ITEMS_VL'.*/

492: , p_task_id IN NUMBER DEFAULT NULL
493: ) IS
494: BEGIN
495: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
496: 'MTL_SYSTEM_ITEMS_VL'.*/
497: OPEN x_kanban_ref FOR
498: SELECT mkc.kanban_card_number
499: , mfg1.meaning kanban_card_type
500: , msiv.concatenated_segments item

Line 531: , mtl_system_items_vl msiv

527: , pv_act.vendor_name vendor_last_activity
528: , pvsa_act.vendor_site_code vendor_site_last_activity
529: , wl_act.line_code
530: FROM mtl_kanban_cards mkc
531: , mtl_system_items_vl msiv
532: , mfg_lookups mfg1
533: , mfg_lookups mfg2
534: , mfg_lookups mfg3
535: , mfg_lookups mfg4