DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 799: , MTL_SYSTEM_ITEMS_KFV msik

795: FROM WMS_LICENSE_PLATE_NUMBERS lpn
796: , WMS_PACKAGING_HIST wph
797: , WMS_LICENSE_PLATE_NUMBERS plpn
798: , WMS_LICENSE_PLATE_NUMBERS olpn
799: , MTL_SYSTEM_ITEMS_KFV msik
800: /*Commented for bug# 6334460 start
801: , DUAL d
802: WHERE d.dummy = 'X'
803: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)

Line 909: , mtl_system_items_kfv msik

905: , mtlt. hold_date
906: , mtlt.expiration_action_code
907: , mtlt.supplier_lot_number
908: FROM mtl_parameters mp
909: , mtl_system_items_kfv msik
910: , mtl_transaction_lots_temp mtlt
911: , mtl_material_transactions_temp mmtt
912: , po_hazard_classes poh
913: , mtl_material_statuses_vl mmsv

Line 1021: ,mtl_system_items_kfv msik

1017: , mln.hold_date hold_date
1018: , mln.expiration_action_code expiration_action_code
1019: , mln.supplier_lot_number supplier_lot_number -- invconv changes end
1020: FROM mtl_parameters mp
1021: ,mtl_system_items_kfv msik
1022: , mtl_lot_numbers mln
1023: , po_hazard_classes poh
1024: , mtl_material_statuses_vl mmsv
1025: WHERE msik.inventory_item_id = p_item_id