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.RCV_WSH_INTERFACE_PKG dependencies on DUAL

Line 1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232

1121: asn_debug.put_line('-------------------------------------------');
1122: asn_debug.put_line(' Processing Returns without receipts');
1123: asn_debug.put_line('-------------------------------------------');
1124: END IF;
1125: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1126: END IF;
1127: load_mtl_interfaces ('Issue out', wdd_rec, l_header_id, p_delivery_id);
1128: END LOOP;
1129:

Line 1171: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232

1167: asn_debug.put_line('-------------------------------------------');
1168: asn_debug.put_line(' Processing Returns in the Receipt org');
1169: asn_debug.put_line('-------------------------------------------');
1170: END IF;
1171: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232
1172: END IF;
1173: load_rcv_interfaces (p_delivery_id, wdd_rec,l_group_id);
1174: relieve_return_reservation (wdd_rec);
1175: END LOOP;

Line 1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232

1220: asn_debug.put_line('-------------------------------------------');
1221: asn_debug.put_line('Processing Direct transfers from Return hub');
1222: asn_debug.put_line('-------------------------------------------');
1223: END IF;
1224: SELECT mtl_material_transactions_s.nextval INTO l_header_id FROM DUAL; -- Bug 11831232
1225: END IF;
1226: load_mtl_interfaces ('Direct Transfer', wdd_rec, l_header_id, p_delivery_id);
1227: END LOOP;
1228:

Line 1267: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232

1263: asn_debug.put_line('-------------------------------------------');
1264: asn_debug.put_line(' Processing Returns after Direct txr');
1265: asn_debug.put_line('-------------------------------------------');
1266: END IF;
1267: SELECT rcv_interface_groups_s.nextval INTO l_group_id FROM DUAL; -- Bug 11831232
1268: END IF;
1269: load_rcv_interfaces (p_delivery_id, wdd_rec,l_group_id);
1270: END LOOP;
1271:

Line 1695: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232

1691: INTO l_txn_reference
1692: FROM rcv_transactions_interface
1693: WHERE interface_transaction_id = p_wdd_rec.source_line_id; -- Bug 12974284
1694: --
1695: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
1696: --
1697: INSERT INTO mtl_transactions_interface
1698: ( transaction_header_id,
1699: transaction_interface_id,

Line 1777: FROM DUAL;

1773: l_txn_reference, -- Bug 12974284
1774: l_lpn_id, -- RTV2 rtv project phase 2
1775: l_transfer_lpn_id, -- RTV2 rtv project phase 2
1776: l_transfer_lpn_id -- RTV2 rtv project phase 2
1777: FROM DUAL;
1778:
1779: IF (g_asn_debug = 'Y') THEN
1780: asn_debug.put_line('Inserted MTI with transaction_interface_id : ' || l_temp_id);
1781: END IF;

Line 1952: SELECT rcv_transactions_interface_s.nextval INTO l_rti_id FROM DUAL; -- Bug 11831232

1948: AND wdl.pick_up_stop_id = wts.stop_id
1949: AND wnd.initial_pickup_location_id = wts.stop_location_id
1950: AND wnd.delivery_id = p_delivery_id;
1951: --
1952: SELECT rcv_transactions_interface_s.nextval INTO l_rti_id FROM DUAL; -- Bug 11831232
1953: --
1954: INSERT INTO rcv_transactions_interface
1955: ( receipt_source_code,
1956: interface_transaction_id,

Line 2296: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232

2292: IF (l_source_allows_lot AND p_wdd_rec.lot_number IS NOT NULL ) THEN
2293: IF (p_source = 'INV') THEN
2294: l_temp_id := p_parent_id;
2295: ELSIF (p_source = 'RCV') THEN
2296: SELECT mtl_material_transactions_s.nextval INTO l_temp_id FROM DUAL; -- Bug 11831232
2297: END IF;
2298: --
2299: INSERT INTO mtl_transaction_lots_interface
2300: ( transaction_interface_id,

Line 2373: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232

2369:
2370: IF (l_serial_temp_id IS NULL) THEN
2371: IF (p_source = 'INV') THEN
2372: IF (l_lot_inserted) THEN
2373: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232
2374: ELSE
2375: l_serial_temp_id := p_parent_id;
2376: END IF;
2377: ELSIF (p_source = 'RCV') THEN

Line 2378: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232

2374: ELSE
2375: l_serial_temp_id := p_parent_id;
2376: END IF;
2377: ELSIF (p_source = 'RCV') THEN
2378: SELECT mtl_material_transactions_s.nextval INTO l_serial_temp_id FROM DUAL; -- Bug 11831232
2379: END IF;
2380: END IF;
2381: --
2382: -- Transfer tagged serial to receipt org if return is done from another org ie, direct txr is completed at this point.

Line 2554: FROM dual;

2550: wsn_rec.cycles_since_visit,
2551: wsn_rec.time_since_mark,
2552: wsn_rec.cycles_since_mark,
2553: wsn_rec.number_of_repairs
2554: FROM dual;
2555: --
2556: l_serial_inserted := TRUE;
2557: IF (g_asn_debug = 'Y') THEN
2558: asn_debug.put_line('Inserted MSNI : fm_serial_number : ' || wsn_rec.fm_serial_number || ' and to_serial_number : ' || wsn_rec.to_serial_number );