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

Line 30: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

26: , p_mo_line_id NUMBER
27: ) IS
28: CURSOR c_item_controls IS
29: SELECT msi.lot_control_code, msi.serial_number_control_code
30: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
31: WHERE p_transaction_temp_id IS NOT NULL
32: AND mmtt.transaction_temp_id = p_transaction_temp_id
33: AND msi.inventory_item_id = mmtt.inventory_item_id
34: AND msi.organization_id = mmtt.organization_id

Line 37: FROM mtl_system_items msi, mtl_txn_request_lines mtrl

33: AND msi.inventory_item_id = mmtt.inventory_item_id
34: AND msi.organization_id = mmtt.organization_id
35: UNION ALL
36: SELECT msi.lot_control_code, msi.serial_number_control_code
37: FROM mtl_system_items msi, mtl_txn_request_lines mtrl
38: WHERE p_transaction_temp_id IS NULL AND p_mo_line_id IS NOT NULL
39: AND mtrl.line_id = p_mo_line_id
40: AND msi.inventory_item_id = mtrl.inventory_item_id
41: AND msi.organization_id = mtrl.organization_id;

Line 245: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

241: , mmtt.lot_number -- 9758641
242: , msi.tracking_quantity_ind -- 9758641
243: , mmtt.move_order_line_id -- 9896283
244: , msi.secondary_uom_code --INVCONV kkillams
245: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
246: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
247: AND msi.inventory_item_id = mmtt.inventory_item_id
248: AND msi.organization_id = mmtt.organization_id;
249:

Line 475: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

471:
472: l_txn_header_id NUMBER;
473: l_org_id NUMBER;
474: l_item_id NUMBER;
475: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
476: l_txn_uom mtl_system_items.primary_uom_code%TYPE;
477: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams
478: l_rem_txn_qty NUMBER;
479: l_rem_pri_qty NUMBER;

Line 476: l_txn_uom mtl_system_items.primary_uom_code%TYPE;

472: l_txn_header_id NUMBER;
473: l_org_id NUMBER;
474: l_item_id NUMBER;
475: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
476: l_txn_uom mtl_system_items.primary_uom_code%TYPE;
477: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams
478: l_rem_txn_qty NUMBER;
479: l_rem_pri_qty NUMBER;
480: l_lot_txn_qty NUMBER;

Line 477: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams

473: l_org_id NUMBER;
474: l_item_id NUMBER;
475: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
476: l_txn_uom mtl_system_items.primary_uom_code%TYPE;
477: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams
478: l_rem_txn_qty NUMBER;
479: l_rem_pri_qty NUMBER;
480: l_lot_txn_qty NUMBER;
481: l_lot_pri_qty NUMBER;

Line 491: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

487:
488: CURSOR c_mmtt_info IS
489: SELECT mmtt.transaction_header_id, mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom, msi.primary_uom_code
490: , msi.secondary_uom_code --INVCONV kkillams
491: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
492: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
493: AND msi.inventory_item_id = mmtt.inventory_item_id
494: AND msi.organization_id = mmtt.organization_id;
495:

Line 1146: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

1142: , mmtt.locator_id
1143: , mmtt.transaction_uom
1144: , msi.primary_uom_code
1145: , msi.secondary_uom_code --INVCONV kkillams
1146: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
1147: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1148: AND msi.inventory_item_id = mmtt.inventory_item_id
1149: AND msi.organization_id = mmtt.organization_id;
1150:

Line 1642: SELECT primary_uom_code INTO l_primary_uom FROM mtl_system_items

1638:
1639: SELECT inventory_item_id, organization_id INTO l_inventory_item_id,l_organization_id
1640: FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_transaction_temp_id;
1641:
1642: SELECT primary_uom_code INTO l_primary_uom FROM mtl_system_items
1643: WHERE inventory_item_id =l_inventory_item_id
1644: AND organization_id =l_organization_id;
1645:
1646: