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

Line 32: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;

28: , p_transaction_identifier IN NUMBER
29: ) IS
30:
31: p_organization_id MTL_PARAMETERS.ORGANIZATION_ID%TYPE := null;
32: p_inventory_item_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE := null;
33: p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE :=null;
34: p_revision MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION%TYPE := null;
35: p_qty MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_QUANTITY%TYPE := null;
36: p_uom MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSACTION_UOM%TYPE := null;

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

475: SELECT distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
476: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
477: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
478: msik.concatenated_segments container_item, lpn.license_plate_number, wph2.pack_level
479: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,
480: WMS_LICENSE_PLATE_NUMBERS lpn
481: WHERE wph.rowid in (select rowid
482: from wms_packaging_hist
483: where pack_level = 0

Line 497: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv

493: SELECT distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
494: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
495: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
496: msik.concatenated_segments container_item,lpn.license_plate_number
497: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv
498: msik, WMS_LICENSE_PLATE_NUMBERS lpn
499: WHERE wph.rowid in (select rowid
500: from wms_packaging_hist
501: where pack_level = 0

Line 600: , MTL_SYSTEM_ITEMS_KFV msik

596: FROM WMS_LICENSE_PLATE_NUMBERS lpn
597: , WMS_PACKAGING_HIST wph
598: , WMS_LICENSE_PLATE_NUMBERS plpn
599: , WMS_LICENSE_PLATE_NUMBERS olpn
600: , MTL_SYSTEM_ITEMS_KFV msik
601: , DUAL d
602: WHERE d.dummy = 'X'
603: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)
604: AND lpn.lpn_id (+) = p_lpn_id

Line 706: , mtl_system_items_kfv msik

702: , mln.hold_date
703: , mln.expiration_action_code
704: , mln.supplier_lot_number -- invconv fabdi end
705: FROM mtl_parameters mp
706: , mtl_system_items_kfv msik
707: , mtl_lot_numbers mln
708: , po_hazard_classes poh
709: , mtl_material_statuses_vl mmsv
710: WHERE msik.inventory_item_id = p_item_id

Line 854: , mtl_system_items msi

850: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
851: , l_secondary_uom_code secondary_uom -- invconv fabdi
852: FROM wms_packaging_hist wpc
853: , mtl_material_transactions_temp mmtt
854: , mtl_system_items msi
855: , cst_cost_groups ccg
856: , mtl_item_locations milkfv
857: -- Bug 4137707, Do not need to include this where clause,
858: -- This will be controlled when opening this cursor