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 DUAL

Line 184: FROM DUAL; */

180: END IF;
181:
182: /* SELECT mtl_material_transactions_s.NEXTVAL
183: INTO x_trx_tmp_id
184: FROM DUAL; */
185:
186: -- If content Item Id is not NULL then set ItemId = -1;
187: IF (p_cnt_lpn_id IS NOT NULL) THEN
188: v_item_id := -1;

Line 1541: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;

1537: (SELECT decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1538: FROM mtl_material_transactions_temp
1539: WHERE transaction_temp_id = p_transaction_temp_id)
1540: AND msi.organization_id = l_organization_id;
1541: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1542:
1543: INSERT INTO mtl_material_transactions_temp(
1544: transaction_header_id
1545: , transaction_temp_id

Line 2082: FROM dual --Bug#6157372 -- 12419592

2078: FROM mtl_transaction_lots_temp
2079: WHERE transaction_temp_id = p_transaction_temp_id
2080: UNION ALL
2081: SELECT l_txn_hdr_id
2082: FROM dual --Bug#6157372 -- 12419592
2083: UNION ALL
2084: SELECT p_transaction_temp_id
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.

Line 2085: FROM dual );-- 14259665 Added to select temp id since for unallocated lots the MSNTs are inserted with

2081: SELECT l_txn_hdr_id
2082: FROM dual --Bug#6157372 -- 12419592
2083: UNION ALL
2084: SELECT p_transaction_temp_id
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

Line 2095: FROM dual );-- 14259665 Added to select temp id since for unallocated lots the MSNTs are inserted with

2091: FROM mtl_transaction_lots_temp
2092: WHERE transaction_temp_id = p_transaction_temp_id
2093: UNION ALL
2094: SELECT p_transaction_temp_id
2095: FROM dual );-- 14259665 Added to select temp id since for unallocated lots the MSNTs are inserted with
2096: -- mmtt transaction_temp_id. The MTLT is inserted later and then the serial_transaction_temp_id
2097: -- is back updated.
2098:
2099: ELSE -- only serial controlled but not lot controlled.

Line 2498: FROM dual;

2494: IF l_count > 0 THEN
2495:
2496: SELECT rcv_interface_groups_s.NEXTVAL
2497: INTO l_group_id
2498: FROM dual;
2499:
2500: UPDATE rcv_transactions_interface rti
2501: SET group_id = l_group_id
2502: WHERE rti.processing_status_code = 'RUNNING'