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_MO_LINE_DETAIL_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 2105: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;

2101: l_mtlt_sec_transaction_qty NUMBER; --INVCONV
2102: l_mmtt_sec_transaction_qty NUMBER; --INVCONV
2103: l_lot_control_code NUMBER;
2104: l_serial_control_code NUMBER;
2105: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
2106: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE; --INVCONV
2107: l_mmtt_rowid ROWID;
2108: l_mtlt_rowid ROWID;
2109:

Line 2106: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE; --INVCONV

2102: l_mmtt_sec_transaction_qty NUMBER; --INVCONV
2103: l_lot_control_code NUMBER;
2104: l_serial_control_code NUMBER;
2105: l_primary_uom_code mtl_system_items.primary_uom_code%TYPE;
2106: l_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE; --INVCONV
2107: l_mmtt_rowid ROWID;
2108: l_mtlt_rowid ROWID;
2109:
2110: TYPE mmtt_rec IS RECORD(

Line 2230: FROM mtl_system_items

2226: INTO l_primary_uom_code
2227: , l_lot_control_code
2228: , l_serial_control_code
2229: , l_secondary_uom_code
2230: FROM mtl_system_items
2231: WHERE inventory_item_id = p_mold_table(i).inventory_item_id
2232: AND organization_id = p_mold_table(i).organization_id;
2233: EXCEPTION
2234: WHEN NO_DATA_FOUND THEN

Line 2581: FROM mtl_system_items

2577: FOR UPDATE;
2578:
2579: CURSOR c_primary_uom IS
2580: SELECT primary_uom_code, secondary_uom_code --INVCONV
2581: FROM mtl_system_items
2582: WHERE organization_id = l_organization_id
2583: AND inventory_item_id = l_inventory_item_id;
2584:
2585: CURSOR c_lot_allocations IS

Line 2857: FROM mtl_system_items_b msi, mtl_material_transactions_temp mmtt

2853: , mmtt.primary_quantity primary_quantity
2854: , mmtt.lot_number
2855: , mmtt.lot_expiration_date
2856: , mmtt.transaction_date
2857: FROM mtl_system_items_b msi, mtl_material_transactions_temp mmtt
2858: WHERE msi.inventory_item_id = mmtt.inventory_item_id
2859: AND msi.organization_id = mmtt.organization_id
2860: AND mmtt.transaction_temp_id = c_transaction_temp_id;
2861: