APPS.INV_KANBAN_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 342: with 'MTL_SYSTEM_ITEMS_VL'.*/

338: l_error_code NUMBER := NULL;
339: l_error_message VARCHAR2(255) := NULL;
340: BEGIN
341: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV'
342: with 'MTL_SYSTEM_ITEMS_VL'.*/
343: SELECT msiv.concatenated_segments
344: , msiv.description
345: , mkcv.kanban_size
346: , mkcv.subinventory_name

Line 375: FROM mtl_kanban_cards_v mkcv, mtl_system_items_vl msiv

371: , x_wip_line
372: , x_supplier_name
373: , supplier_site_id
374: , x_item_id
375: FROM mtl_kanban_cards_v mkcv, mtl_system_items_vl msiv
376: WHERE mkcv.kanban_card_number = p_kanban_card_number
377: AND mkcv.organization_id = p_org_id
378: AND mkcv.inventory_item_id = msiv.inventory_item_id
379: AND mkcv.organization_id = msiv.organization_id;

Line 507: 'MTL_SYSTEM_ITEMS_VL'.*/

503: , p_task_id IN NUMBER DEFAULT NULL
504: ) IS
505: BEGIN
506: /*Bug#5612236. In the below query, replaced 'MTL_SYSTEM_ITEMS_KFV' with
507: 'MTL_SYSTEM_ITEMS_VL'.*/
508: OPEN x_kanban_ref FOR
509: SELECT mkc.kanban_card_number
510: , mfg1.meaning kanban_card_type
511: , msiv.concatenated_segments item

Line 542: , mtl_system_items_vl msiv

538: , pv_act.vendor_name vendor_last_activity
539: , pvsa_act.vendor_site_code vendor_site_last_activity
540: , wl_act.line_code
541: FROM mtl_kanban_cards mkc
542: , mtl_system_items_vl msiv
543: , mfg_lookups mfg1
544: , mfg_lookups mfg2
545: , mfg_lookups mfg3
546: , mfg_lookups mfg4