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

Line 833: FROM dual;

829: mydebug('consolidate mtlt 33: lot/serial controlled and allocate to serial ON', l_api_name);
830: END IF;
831: SELECT mtl_material_transactions_s.NEXTVAL
832: INTO l_new_serial_temp_id
833: FROM dual;
834: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
835: l_sum_same_lot_pri_qty := 0;
836: l_sum_same_lot_tra_qty := 0;
837: open c_same_lot_csr(l_transaction_temp_id, l_lot);

Line 865: FROM dual;

861: mydebug('consolidate mtlt 44: lot controlled only OR lot/serial controlled but Allocate to serial OFF', l_api_name);
862: END IF;
863: SELECT mtl_material_transactions_s.NEXTVAL
864: INTO l_new_serial_temp_id
865: FROM dual;
866: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
867: begin
868: select sum(primary_quantity), sum(transaction_quantity)
869: into l_sum_same_lot_pri_qty, l_sum_same_lot_tra_qty

Line 1237: FROM DUAL

1233: -- Added for 14699845 (Flexible Lot Allocation)
1234: BEGIN
1235: SELECT 'Y'
1236: INTO l_allocate_lot_flag
1237: FROM DUAL
1238: WHERE EXISTS (SELECT 1
1239: FROM mtl_transaction_lots_temp mtlt
1240: WHERE mtlt.transaction_temp_id = l_transaction_temp_id);
1241: EXCEPTION

Line 1321: , msik.dual_uom_deviation_high

1317: , msik.tracking_quantity_ind
1318: , msik.ont_pricing_qty_source
1319: , msik.secondary_default_ind
1320: , msik.secondary_uom_code
1321: , msik.dual_uom_deviation_high
1322: , msik.dual_uom_deviation_low
1323: , mmtt.trx_source_line_id
1324: , l_check_overpick_passed --OVPK
1325: , Sysdate

Line 1322: , msik.dual_uom_deviation_low

1318: , msik.ont_pricing_qty_source
1319: , msik.secondary_default_ind
1320: , msik.secondary_uom_code
1321: , msik.dual_uom_deviation_high
1322: , msik.dual_uom_deviation_low
1323: , mmtt.trx_source_line_id
1324: , l_check_overpick_passed --OVPK
1325: , Sysdate
1326: , mp.negative_inv_receipt_code

Line 1448: , msik.dual_uom_deviation_high

1444: , msik.tracking_quantity_ind
1445: , msik.ont_pricing_qty_source
1446: , msik.secondary_default_ind
1447: , msik.secondary_uom_code
1448: , msik.dual_uom_deviation_high
1449: , msik.dual_uom_deviation_low
1450: , mmtt.trx_source_line_id
1451: , l_check_overpick_passed --OVPK
1452: , Sysdate

Line 1449: , msik.dual_uom_deviation_low

1445: , msik.ont_pricing_qty_source
1446: , msik.secondary_default_ind
1447: , msik.secondary_uom_code
1448: , msik.dual_uom_deviation_high
1449: , msik.dual_uom_deviation_low
1450: , mmtt.trx_source_line_id
1451: , l_check_overpick_passed --OVPK
1452: , Sysdate
1453: , mp.negative_inv_receipt_code

Line 2180: FROM dual

2176: BEGIN
2177: IF nvl(p_allow_unreleased_task,'Y') = 'Y' THEN
2178: SELECT 1
2179: INTO l_mmtt_rowcnt
2180: FROM dual
2181: WHERE exists (SELECT 1
2182: FROM mtl_material_transactions_temp
2183: WHERE transaction_temp_id = p_transaction_temp_id
2184: AND organization_id = p_organization_id

Line 2190: FROM dual

2186: OR parent_line_id = transaction_temp_id)); -- bulk task
2187: ELSE
2188: SELECT 1
2189: INTO l_mmtt_rowcnt
2190: FROM dual
2191: WHERE exists (SELECT 1
2192: FROM mtl_material_transactions_temp
2193: WHERE transaction_temp_id = p_transaction_temp_id
2194: AND organization_id = p_organization_id

Line 2223: FROM dual

2219:
2220: BEGIN
2221: SELECT 1
2222: INTO l_wdt_rowcnt
2223: FROM dual
2224: WHERE exists (SELECT 1
2225: FROM wms_dispatched_tasks t
2226: WHERE t.transaction_temp_id = p_transaction_temp_id
2227: AND person_id <> p_employee_id);

Line 2270: FROM DUAL;

2266: l_user_id := fnd_global.user_id;
2267:
2268: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
2269: INTO l_txn_hdr_id
2270: FROM DUAL;
2271:
2272: UPDATE mtl_material_transactions_temp
2273: SET transaction_header_id = l_txn_hdr_id ,
2274: last_update_date = Sysdate,

Line 2289: FROM dual

2285:
2286: BEGIN
2287: SELECT 1
2288: INTO l_wdt_rowcnt
2289: FROM dual
2290: WHERE exists (SELECT 1
2291: FROM wms_dispatched_tasks t
2292: WHERE t.transaction_temp_id = p_transaction_temp_id);
2293:

Line 4068: FROM dual;

4064: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
4065: LOOP
4066: SELECT mtl_material_transactions_s.NEXTVAL
4067: INTO l_new_transaction_header_id
4068: FROM dual;
4069: SELECT mtl_material_transactions_s.NEXTVAL
4070: INTO l_new_transaction_temp_id
4071: FROM dual;
4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

Line 4071: FROM dual;

4067: INTO l_new_transaction_header_id
4068: FROM dual;
4069: SELECT mtl_material_transactions_s.NEXTVAL
4070: INTO l_new_transaction_temp_id
4071: FROM dual;
4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
4073: IF g_debug = 1 THEN
4074: mydebug( ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number,'split_task');
4075: END IF;

Line 4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

4068: FROM dual;
4069: SELECT mtl_material_transactions_s.NEXTVAL
4070: INTO l_new_transaction_temp_id
4071: FROM dual;
4072: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
4073: IF g_debug = 1 THEN
4074: mydebug( ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number,'split_task');
4075: END IF;
4076: split_mmtt(

Line 5324: FROM dual;

5320:
5321: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
5322: SELECT mtl_material_transactions_s.NEXTVAL
5323: INTO l_new_serial_txn_temp_id
5324: FROM dual;
5325: UPDATE mtl_transaction_lots_temp
5326: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
5327: last_updated_by = FND_GLOBAL.USER_ID
5328: WHERE transaction_temp_id = p_new_transaction_temp_id