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

Line 202: FROM mtl_system_items

198: BEGIN
199:
200: SELECT lot_control_code, serial_number_control_code, revision_qty_control_code, location_control_code
201: INTO l_lot_ctrl_code, l_ser_ctrl_code, l_rev_ctrl_code, l_loc_ctrl_code
202: FROM mtl_system_items
203: WHERE organization_id = p_org_id
204: AND inventory_item_id = p_item_id;
205:
206: IF (l_debug = 1) THEN

Line 1400: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

1396: l_inventory_item_id NUMBER;
1397: l_txn_qty NUMBER;
1398: l_primary_qty NUMBER;
1399: l_new_txn_temp_id NUMBER;
1400: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1401: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;
1402: l_secondary_uom varchar2(3);
1403:
1404: CURSOR c_mmtt_info IS

Line 1401: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;

1397: l_txn_qty NUMBER;
1398: l_primary_qty NUMBER;
1399: l_new_txn_temp_id NUMBER;
1400: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1401: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;
1402: l_secondary_uom varchar2(3);
1403:
1404: CURSOR c_mmtt_info IS
1405: SELECT mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom

Line 1411: FROM mtl_system_items msi

1407: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
1408:
1409: CURSOR c_item_info IS
1410: SELECT primary_uom_code
1411: FROM mtl_system_items msi
1412: WHERE msi.inventory_item_id = l_inventory_item_id
1413: AND msi.organization_id = l_organization_id;
1414: BEGIN
1415: x_return_status := fnd_api.g_ret_sts_success;

Line 1535: FROM mtl_system_items msi

1531:
1532: /*Bug#7716563,To fetch secondary_uom_code so as to update child MMTT with secondary_uom_code */
1533: SELECT secondary_uom_code
1534: INTO l_secondary_uom
1535: FROM mtl_system_items msi
1536: WHERE msi.inventory_item_id =
1537: (SELECT decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1538: FROM mtl_material_transactions_temp
1539: WHERE transaction_temp_id = p_transaction_temp_id)

Line 2020: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

2016: CURSOR c_item_info IS
2017: SELECT msi.inventory_item_id, msi.lot_control_code, msi.serial_number_control_code, mmtt.parent_line_id
2018: ,mmtt.transaction_header_id --Bug#6211912
2019: ,mmtt.organization_id -- 14259665 Performance Issue
2020: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
2021: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2022: AND msi.inventory_item_id = mmtt.inventory_item_id
2023: AND msi.organization_id = mmtt.organization_id;
2024: