DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 770: , MTL_SYSTEM_ITEMS_KFV msik

766: FROM WMS_LICENSE_PLATE_NUMBERS lpn
767: , WMS_PACKAGING_HIST wph
768: , WMS_LICENSE_PLATE_NUMBERS plpn
769: , WMS_LICENSE_PLATE_NUMBERS olpn
770: , MTL_SYSTEM_ITEMS_KFV msik
771: /*Commented for bug# 6334460 start
772: , DUAL d
773: WHERE d.dummy = 'X'
774: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)

Line 877: ,mtl_system_items_kfv msik

873: , mln.hold_date hold_date
874: , mln.expiration_action_code expiration_action_code
875: , mln.supplier_lot_number supplier_lot_number -- invconv changes end
876: FROM mtl_parameters mp
877: ,mtl_system_items_kfv msik
878: , mtl_lot_numbers mln
879: , po_hazard_classes poh
880: , mtl_material_statuses_vl mmsv
881: WHERE msik.inventory_item_id = p_item_id