APPS.INV_TRX_UTIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1272: l_primary_uom mtl_system_items.primary_uom_code%TYPE;

1268: l_inventory_item_id NUMBER;
1269: l_txn_qty NUMBER;
1270: l_primary_qty NUMBER;
1271: l_new_txn_temp_id NUMBER;
1272: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1273: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;
1274:
1275: CURSOR c_mmtt_info IS
1276: SELECT mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom

Line 1273: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;

1269: l_txn_qty NUMBER;
1270: l_primary_qty NUMBER;
1271: l_new_txn_temp_id NUMBER;
1272: l_primary_uom mtl_system_items.primary_uom_code%TYPE;
1273: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;
1274:
1275: CURSOR c_mmtt_info IS
1276: SELECT mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom
1277: FROM mtl_material_transactions_temp mmtt

Line 1282: FROM mtl_system_items msi

1278: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
1279:
1280: CURSOR c_item_info IS
1281: SELECT primary_uom_code
1282: FROM mtl_system_items msi
1283: WHERE msi.inventory_item_id = l_inventory_item_id
1284: AND msi.organization_id = l_organization_id;
1285: BEGIN
1286: x_return_status := fnd_api.g_ret_sts_success;

Line 1879: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

1875:
1876: CURSOR c_item_info IS
1877: SELECT msi.inventory_item_id, msi.lot_control_code, msi.serial_number_control_code, mmtt.parent_line_id
1878: ,mmtt.transaction_header_id --Bug#6211912
1879: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
1880: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1881: AND msi.inventory_item_id = mmtt.inventory_item_id
1882: AND msi.organization_id = mmtt.organization_id;
1883: