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_SERIAL_NUMBERS_TEMP

Line 909: -- MTL_SERIAL_NUMBERS_TEMP. The argument p_trx_tmp_id is

905: -- Name: INSERT_SER_TRX
906: --
907: --
908: -- Functions: This API inserts a Serial Transaction record into
909: -- MTL_SERIAL_NUMBERS_TEMP. The argument p_trx_tmp_id is
910: -- used to couple this record with a transaction-line in
911: -- MTL_MATERIAL_TRANSACTIONS_TEMP
912: --
913: FUNCTION insert_ser_trx(

Line 1147: INSERT INTO mtl_serial_numbers_temp

1143: TRACE('SERIAL_PREFIX IS :' || l_serial_prefix, 'INVTRXUB', 9);
1144: END IF;
1145:
1146: /* end of bug fix 2527211 */
1147: INSERT INTO mtl_serial_numbers_temp
1148: (
1149: transaction_temp_id
1150: , last_update_date
1151: , last_updated_by

Line 1958: -- temp id from MTL_SERIAL_NUMBERS_TEMP.

1954:
1955: -- Name: DELETE_SER_TRX
1956: --
1957: -- Functions: This API deletes all records with the input transaction
1958: -- temp id from MTL_SERIAL_NUMBERS_TEMP.
1959: -- It also unmarks these serial numbers in MSN.
1960: FUNCTION delete_ser_trx(
1961: p_trx_header_id IN NUMBER
1962: , p_trx_tmp_id IN NUMBER

Line 1971: DELETE FROM mtl_serial_numbers_temp

1967: )
1968: RETURN NUMBER IS
1969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1970: BEGIN
1971: DELETE FROM mtl_serial_numbers_temp
1972: WHERE transaction_temp_id = NVL(p_serial_trx_tmp_id, p_trx_tmp_id);
1973:
1974: serial_check.inv_unmark_serial(
1975: from_serial_number => NULL

Line 2089: DELETE mtl_serial_numbers_temp

2085: FROM dual );-- 14259665 Added to select temp id since for unallocated lots the MSNTs are inserted with
2086: -- mmtt transaction_temp_id and group_mark_id is stamped as transaction_temp_id.
2087: l_unmarked_count := SQL%ROWCOUNT;
2088:
2089: DELETE mtl_serial_numbers_temp
2090: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id
2091: FROM mtl_transaction_lots_temp
2092: WHERE transaction_temp_id = p_transaction_temp_id
2093: UNION ALL

Line 2108: DELETE mtl_serial_numbers_temp

2104: --Bug#6157372
2105:
2106: l_unmarked_count := SQL%ROWCOUNT;
2107:
2108: DELETE mtl_serial_numbers_temp
2109: WHERE transaction_temp_id = p_transaction_temp_id;
2110:
2111: END IF;
2112:

Line 2160: FROM mtl_serial_numbers_temp

2156: , x_return_status OUT NOCOPY VARCHAR2
2157: ) IS
2158: CURSOR c_serial(l_txn_tmp_id IN NUMBER) IS
2159: SELECT fm_serial_number, NVL(to_serial_number, fm_serial_number) to_serial_number
2160: FROM mtl_serial_numbers_temp
2161: WHERE transaction_temp_id = l_txn_tmp_id;
2162:
2163: CURSOR c_lot(l_txn_tmp_id IN NUMBER) IS
2164: SELECT serial_transaction_temp_id

Line 2191: DELETE FROM mtl_serial_numbers_temp msnt WHERE msnt.transaction_temp_id = p_trx_tmp_id;

2187: , lot_temp_id => NULL
2188: , p_inventory_item_id => p_item_id
2189: );
2190: END LOOP;
2191: DELETE FROM mtl_serial_numbers_temp msnt WHERE msnt.transaction_temp_id = p_trx_tmp_id;
2192: ELSIF((p_serctrl <> 1) AND(p_lotctrl = 2)) THEN
2193: --Item is lot controlled and serial controlled
2194:
2195: FOR c_lot_rec IN c_lot(p_trx_tmp_id) LOOP

Line 2213: DELETE FROM mtl_serial_numbers_temp msnt

2209: END LOOP;
2210: END LOOP;
2211:
2212: --Delete records from MSNT and MTLT
2213: DELETE FROM mtl_serial_numbers_temp msnt
2214: WHERE msnt.transaction_temp_id IN(
2215: SELECT mtlt.serial_transaction_temp_id
2216: FROM mtl_transaction_lots_temp mtlt
2217: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id

Line 2311: DELETE mtl_serial_numbers_temp

2307:
2308: -- Delete the Serials
2309: IF p_serial_control_code NOT IN (1,6) THEN
2310: IF p_lot_control_code = 2 THEN
2311: DELETE mtl_serial_numbers_temp
2312: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2313: WHERE transaction_temp_id = p_parent_line_id)
2314: AND fm_serial_number IN (SELECT msnt.fm_serial_number
2315: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

Line 2315: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

2311: DELETE mtl_serial_numbers_temp
2312: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2313: WHERE transaction_temp_id = p_parent_line_id)
2314: AND fm_serial_number IN (SELECT msnt.fm_serial_number
2315: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2316: WHERE mtlt.transaction_temp_id = p_child_line_id
2317: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id)
2318: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2319:

Line 2321: DELETE mtl_serial_numbers_temp

2317: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id)
2318: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2319:
2320: IF SQL%ROWCOUNT = 0 THEN
2321: DELETE mtl_serial_numbers_temp
2322: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2323: WHERE transaction_temp_id = p_parent_line_id)
2324: AND ROWNUM <= l_child_pri_qty
2325: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;

Line 2328: DELETE mtl_serial_numbers_temp

2324: AND ROWNUM <= l_child_pri_qty
2325: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2326: END IF;
2327: ELSE
2328: DELETE mtl_serial_numbers_temp
2329: WHERE transaction_temp_id = p_parent_line_id
2330: AND fm_serial_number IN (SELECT msnt.fm_serial_number FROM mtl_serial_numbers_temp msnt
2331: WHERE msnt.transaction_temp_id = p_child_line_id)
2332: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;

Line 2330: AND fm_serial_number IN (SELECT msnt.fm_serial_number FROM mtl_serial_numbers_temp msnt

2326: END IF;
2327: ELSE
2328: DELETE mtl_serial_numbers_temp
2329: WHERE transaction_temp_id = p_parent_line_id
2330: AND fm_serial_number IN (SELECT msnt.fm_serial_number FROM mtl_serial_numbers_temp msnt
2331: WHERE msnt.transaction_temp_id = p_child_line_id)
2332: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2333:
2334: IF SQL%ROWCOUNT = 0 THEN

Line 2335: DELETE mtl_serial_numbers_temp

2331: WHERE msnt.transaction_temp_id = p_child_line_id)
2332: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2333:
2334: IF SQL%ROWCOUNT = 0 THEN
2335: DELETE mtl_serial_numbers_temp
2336: WHERE transaction_temp_id = p_parent_line_id
2337: AND ROWNUM <= l_child_pri_qty
2338: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2339: END IF;