DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_SYSTEM_ITEMS

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

Line 1103: , mtl_system_items msi

1099: , l_secondary_uom secondary_uom -- invconv fabdi
1100:
1101: FROM wms_packaging_hist wpc
1102: , mtl_material_transactions_temp mmtt
1103: , mtl_system_items msi
1104: , cst_cost_groups ccg
1105: , mtl_item_locations milkfv
1106: -- Bug 4137707, Do not need to include this where clause,
1107: -- This will be controlled when opening this cursor