eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT4 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 530: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,

526: SELECT distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
527: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
528: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
529: msik.concatenated_segments container_item, lpn.license_plate_number, wph2.pack_level
530: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,
531: WMS_LICENSE_PLATE_NUMBERS lpn
532: WHERE wph.rowid in (select rowid
533: from wms_packaging_hist
534: where pack_level = 0

Line 549: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv

545: SELECT /*+ rowid(WPH) */ distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
546: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
547: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
548: msik.concatenated_segments container_item,lpn.license_plate_number
549: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv
550: msik, WMS_LICENSE_PLATE_NUMBERS lpn
551: WHERE wph.rowid in (select /*+ cardinality(1) */ rowid
552: from wms_packaging_hist
553: where pack_level = 0

Line 653: , MTL_SYSTEM_ITEMS_KFV msik

649: FROM WMS_LICENSE_PLATE_NUMBERS lpn
650: , WMS_PACKAGING_HIST wph
651: , WMS_LICENSE_PLATE_NUMBERS plpn
652: , WMS_LICENSE_PLATE_NUMBERS olpn
653: , MTL_SYSTEM_ITEMS_KFV msik
654: , DUAL d
655: WHERE d.dummy = 'X'
656: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)
657: AND lpn.lpn_id (+) = p_lpn_id

Line 762: , mtl_system_items_kfv msik

758: , mtlt. hold_date
759: , mtlt.expiration_action_code
760: , mtlt.supplier_lot_number
761: FROM mtl_parameters mp
762: , mtl_system_items_kfv msik
763: , mtl_transaction_lots_temp mtlt
764: , mtl_material_transactions_temp mmtt
765: , po_hazard_classes poh
766: , mtl_material_statuses_vl mmsv

Line 871: , mtl_system_items_kfv msik

867: , mln.hold_date
868: , mln.expiration_action_code
869: , mln.supplier_lot_number -- invconv fabdi end
870: FROM mtl_parameters mp
871: , mtl_system_items_kfv msik
872: , mtl_lot_numbers mln
873: , po_hazard_classes poh
874: , mtl_material_statuses_vl mmsv
875: WHERE msik.inventory_item_id = p_item_id