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 242: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

238: , msi.primary_uom_code
239: , msi.replenish_to_order_flag
240: , msi.bom_item_type
241: , msi.secondary_uom_code --INVCONV kkillams
242: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
243: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
244: AND msi.inventory_item_id = mmtt.inventory_item_id
245: AND msi.organization_id = mmtt.organization_id;
246:

Line 392: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

388:
389: l_txn_header_id NUMBER;
390: l_org_id NUMBER;
391: l_item_id NUMBER;
392: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
393: l_txn_uom mtl_system_items.primary_uom_code%TYPE;
394: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams
395: l_rem_txn_qty NUMBER;
396: l_rem_pri_qty NUMBER;

Line 393: l_txn_uom mtl_system_items.primary_uom_code%TYPE;

389: l_txn_header_id NUMBER;
390: l_org_id NUMBER;
391: l_item_id NUMBER;
392: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
393: l_txn_uom mtl_system_items.primary_uom_code%TYPE;
394: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams
395: l_rem_txn_qty NUMBER;
396: l_rem_pri_qty NUMBER;
397: l_lot_txn_qty NUMBER;

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

390: l_org_id NUMBER;
391: l_item_id NUMBER;
392: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
393: l_txn_uom mtl_system_items.primary_uom_code%TYPE;
394: l_sec_uom_code mtl_system_items.primary_uom_code%TYPE; --INVCONV kkillams
395: l_rem_txn_qty NUMBER;
396: l_rem_pri_qty NUMBER;
397: l_lot_txn_qty NUMBER;
398: l_lot_pri_qty NUMBER;

Line 408: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

404:
405: CURSOR c_mmtt_info IS
406: SELECT mmtt.transaction_header_id, mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom, msi.primary_uom_code
407: , msi.secondary_uom_code --INVCONV kkillams
408: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
409: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
410: AND msi.inventory_item_id = mmtt.inventory_item_id
411: AND msi.organization_id = mmtt.organization_id;
412:

Line 999: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi

995: , mmtt.locator_id
996: , mmtt.transaction_uom
997: , msi.primary_uom_code
998: , msi.secondary_uom_code --INVCONV kkillams
999: FROM mtl_material_transactions_temp mmtt, mtl_system_items msi
1000: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1001: AND msi.inventory_item_id = mmtt.inventory_item_id
1002: AND msi.organization_id = mmtt.organization_id;
1003:

Line 1495: SELECT primary_uom_code INTO l_primary_uom FROM mtl_system_items

1491:
1492: SELECT inventory_item_id, organization_id INTO l_inventory_item_id,l_organization_id
1493: FROM mtl_material_transactions_temp WHERE transaction_temp_id = p_transaction_temp_id;
1494:
1495: SELECT primary_uom_code INTO l_primary_uom FROM mtl_system_items
1496: WHERE inventory_item_id =l_inventory_item_id
1497: AND organization_id =l_organization_id;
1498:
1499: