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

Line 781: -- MTL_SERIAL_NUMBERS_TEMP. The argument p_trx_tmp_id is

777: -- Name: INSERT_SER_TRX
778: --
779: --
780: -- Functions: This API inserts a Serial Transaction record into
781: -- MTL_SERIAL_NUMBERS_TEMP. The argument p_trx_tmp_id is
782: -- used to couple this record with a transaction-line in
783: -- MTL_MATERIAL_TRANSACTIONS_TEMP
784: --
785: FUNCTION insert_ser_trx(

Line 961: FROM mtl_serial_numbers msn

957: END IF;
958:
959: SELECT COUNT(msn.serial_number)
960: INTO l_number_of_serial_numbers
961: FROM mtl_serial_numbers msn
962: WHERE msn.inventory_item_id = l_item_id
963: AND msn.serial_number BETWEEN p_fm_ser_num AND p_to_ser_num
964: AND LENGTH(msn.serial_number) = LENGTH(p_fm_ser_num)
965: AND current_status = 3

Line 1019: INSERT INTO mtl_serial_numbers_temp

1015: TRACE('SERIAL_PREFIX IS :' || l_serial_prefix, 'INVTRXUB', 9);
1016: END IF;
1017:
1018: /* end of bug fix 2527211 */
1019: INSERT INTO mtl_serial_numbers_temp
1020: (
1021: transaction_temp_id
1022: , last_update_date
1023: , last_updated_by

Line 1819: -- temp id from MTL_SERIAL_NUMBERS_TEMP.

1815:
1816: -- Name: DELETE_SER_TRX
1817: --
1818: -- Functions: This API deletes all records with the input transaction
1819: -- temp id from MTL_SERIAL_NUMBERS_TEMP.
1820: -- It also unmarks these serial numbers in MSN.
1821: FUNCTION delete_ser_trx(
1822: p_trx_header_id IN NUMBER
1823: , p_trx_tmp_id IN NUMBER

Line 1832: DELETE FROM mtl_serial_numbers_temp

1828: )
1829: RETURN NUMBER IS
1830: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1831: BEGIN
1832: DELETE FROM mtl_serial_numbers_temp
1833: WHERE transaction_temp_id = NVL(p_serial_trx_tmp_id, p_trx_tmp_id);
1834:
1835: serial_check.inv_unmark_serial(
1836: from_serial_number => NULL

Line 1930: UPDATE mtl_serial_numbers

1926: -- Unmarking and Deleting all the Serials associated with the Transaction
1927: IF l_serial_control_code IN(2, 5) THEN --If serial controlled
1928: IF l_lot_control_code = 2 THEN -- If lot controlled also
1929:
1930: UPDATE mtl_serial_numbers
1931: SET group_mark_id = NULL, line_mark_id = NULL, lot_line_mark_id = NULL
1932: WHERE group_mark_id IN (SELECT serial_transaction_temp_id
1933: FROM mtl_transaction_lots_temp
1934: WHERE transaction_temp_id = p_transaction_temp_id)

Line 1939: DELETE mtl_serial_numbers_temp

1935: OR group_mark_id = l_txn_hdr_id ; --Bug#6211912
1936:
1937: l_unmarked_count := SQL%ROWCOUNT;
1938:
1939: DELETE mtl_serial_numbers_temp
1940: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id
1941: FROM mtl_transaction_lots_temp
1942: WHERE transaction_temp_id = p_transaction_temp_id);
1943:

Line 1946: UPDATE mtl_serial_numbers

1942: WHERE transaction_temp_id = p_transaction_temp_id);
1943:
1944: ELSE -- only serial controlled but not lot controlled.
1945:
1946: UPDATE mtl_serial_numbers
1947: SET group_mark_id = NULL, line_mark_id = NULL, lot_line_mark_id = NULL
1948: WHERE group_mark_id = p_transaction_temp_id
1949: OR group_mark_id = l_txn_hdr_id ; --Bug#6211912
1950:

Line 1953: DELETE mtl_serial_numbers_temp

1949: OR group_mark_id = l_txn_hdr_id ; --Bug#6211912
1950:
1951: l_unmarked_count := SQL%ROWCOUNT;
1952:
1953: DELETE mtl_serial_numbers_temp
1954: WHERE transaction_temp_id = p_transaction_temp_id;
1955:
1956: END IF;
1957:

Line 2005: FROM mtl_serial_numbers_temp

2001: , x_return_status OUT NOCOPY VARCHAR2
2002: ) IS
2003: CURSOR c_serial(l_txn_tmp_id IN NUMBER) IS
2004: SELECT fm_serial_number, NVL(to_serial_number, fm_serial_number) to_serial_number
2005: FROM mtl_serial_numbers_temp
2006: WHERE transaction_temp_id = l_txn_tmp_id;
2007:
2008: CURSOR c_lot(l_txn_tmp_id IN NUMBER) IS
2009: SELECT serial_transaction_temp_id

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

2032: , lot_temp_id => NULL
2033: , p_inventory_item_id => p_item_id
2034: );
2035: END LOOP;
2036: DELETE FROM mtl_serial_numbers_temp msnt WHERE msnt.transaction_temp_id = p_trx_tmp_id;
2037: ELSIF((p_serctrl <> 1) AND(p_lotctrl = 2)) THEN
2038: --Item is lot controlled and serial controlled
2039:
2040: FOR c_lot_rec IN c_lot(p_trx_tmp_id) LOOP

Line 2058: DELETE FROM mtl_serial_numbers_temp msnt

2054: END LOOP;
2055: END LOOP;
2056:
2057: --Delete records from MSNT and MTLT
2058: DELETE FROM mtl_serial_numbers_temp msnt
2059: WHERE msnt.transaction_temp_id IN(
2060: SELECT mtlt.serial_transaction_temp_id
2061: FROM mtl_transaction_lots_temp mtlt
2062: WHERE mtlt.serial_transaction_temp_id = msnt.transaction_temp_id

Line 2140: DELETE mtl_serial_numbers_temp

2136:
2137: -- Delete the Serials
2138: IF p_serial_control_code NOT IN (1,6) THEN
2139: IF p_lot_control_code = 2 THEN
2140: DELETE mtl_serial_numbers_temp
2141: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2142: WHERE transaction_temp_id = p_parent_line_id)
2143: AND fm_serial_number IN (SELECT msnt.fm_serial_number
2144: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

Line 2144: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt

2140: DELETE mtl_serial_numbers_temp
2141: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2142: WHERE transaction_temp_id = p_parent_line_id)
2143: AND fm_serial_number IN (SELECT msnt.fm_serial_number
2144: FROM mtl_serial_numbers_temp msnt, mtl_transaction_lots_temp mtlt
2145: WHERE mtlt.transaction_temp_id = p_child_line_id
2146: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id)
2147: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2148:

Line 2150: DELETE mtl_serial_numbers_temp

2146: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id)
2147: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2148:
2149: IF SQL%ROWCOUNT = 0 THEN
2150: DELETE mtl_serial_numbers_temp
2151: WHERE transaction_temp_id IN (SELECT serial_transaction_temp_id FROM mtl_transaction_lots_temp
2152: WHERE transaction_temp_id = p_parent_line_id)
2153: AND ROWNUM <= l_child_pri_qty
2154: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;

Line 2157: DELETE mtl_serial_numbers_temp

2153: AND ROWNUM <= l_child_pri_qty
2154: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2155: END IF;
2156: ELSE
2157: DELETE mtl_serial_numbers_temp
2158: WHERE transaction_temp_id = p_parent_line_id
2159: AND fm_serial_number IN (SELECT msnt.fm_serial_number FROM mtl_serial_numbers_temp msnt
2160: WHERE msnt.transaction_temp_id = p_child_line_id)
2161: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;

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

2155: END IF;
2156: ELSE
2157: DELETE mtl_serial_numbers_temp
2158: WHERE transaction_temp_id = p_parent_line_id
2159: AND fm_serial_number IN (SELECT msnt.fm_serial_number FROM mtl_serial_numbers_temp msnt
2160: WHERE msnt.transaction_temp_id = p_child_line_id)
2161: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2162:
2163: IF SQL%ROWCOUNT = 0 THEN

Line 2164: DELETE mtl_serial_numbers_temp

2160: WHERE msnt.transaction_temp_id = p_child_line_id)
2161: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2162:
2163: IF SQL%ROWCOUNT = 0 THEN
2164: DELETE mtl_serial_numbers_temp
2165: WHERE transaction_temp_id = p_parent_line_id
2166: AND ROWNUM <= l_child_pri_qty
2167: RETURNING fm_serial_number BULK COLLECT INTO l_serials_tbl;
2168: END IF;

Line 2173: UPDATE mtl_serial_numbers

2169: END IF;
2170:
2171: IF l_serials_tbl.COUNT > 0 THEN
2172: FORALL i IN l_serials_tbl.FIRST..l_serials_tbl.LAST
2173: UPDATE mtl_serial_numbers
2174: SET group_mark_id = NULL, line_mark_id = NULL, lot_line_mark_id = NULL
2175: WHERE inventory_item_id = l_item_id
2176: AND serial_number = l_serials_tbl(i);
2177: END IF;