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 668: FROM dual;

664: mydebug('consolidate mtlt 33: lot/serial controlled and allocate to serial ON', l_api_name);
665: END IF;
666: SELECT mtl_material_transactions_s.NEXTVAL
667: INTO l_new_serial_temp_id
668: FROM dual;
669: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
670: l_sum_same_lot_pri_qty := 0;
671: l_sum_same_lot_tra_qty := 0;
672: open c_same_lot_csr(l_transaction_temp_id, l_lot);

Line 700: FROM dual;

696: mydebug('consolidate mtlt 44: lot controlled only OR lot/serial controlled but Allocate to serial OFF', l_api_name);
697: END IF;
698: SELECT mtl_material_transactions_s.NEXTVAL
699: INTO l_new_serial_temp_id
700: FROM dual;
701: l_mtlt_rec.serial_transaction_temp_id := l_new_serial_temp_id;
702: begin
703: select sum(primary_quantity), sum(transaction_quantity)
704: into l_sum_same_lot_pri_qty, l_sum_same_lot_tra_qty

Line 1082: , msik.dual_uom_deviation_high

1078: , msik.tracking_quantity_ind
1079: , msik.ont_pricing_qty_source
1080: , msik.secondary_default_ind
1081: , msik.secondary_uom_code
1082: , msik.dual_uom_deviation_high
1083: , msik.dual_uom_deviation_low
1084: , mmtt.trx_source_line_id
1085: , l_check_overpick_passed --OVPK
1086: , Sysdate

Line 1083: , msik.dual_uom_deviation_low

1079: , msik.ont_pricing_qty_source
1080: , msik.secondary_default_ind
1081: , msik.secondary_uom_code
1082: , msik.dual_uom_deviation_high
1083: , msik.dual_uom_deviation_low
1084: , mmtt.trx_source_line_id
1085: , l_check_overpick_passed --OVPK
1086: , Sysdate
1087: , mp.negative_inv_receipt_code

Line 1193: , msik.dual_uom_deviation_high

1189: , msik.tracking_quantity_ind
1190: , msik.ont_pricing_qty_source
1191: , msik.secondary_default_ind
1192: , msik.secondary_uom_code
1193: , msik.dual_uom_deviation_high
1194: , msik.dual_uom_deviation_low
1195: , mmtt.trx_source_line_id
1196: , l_check_overpick_passed --OVPK
1197: , Sysdate

Line 1194: , msik.dual_uom_deviation_low

1190: , msik.ont_pricing_qty_source
1191: , msik.secondary_default_ind
1192: , msik.secondary_uom_code
1193: , msik.dual_uom_deviation_high
1194: , msik.dual_uom_deviation_low
1195: , mmtt.trx_source_line_id
1196: , l_check_overpick_passed --OVPK
1197: , Sysdate
1198: , mp.negative_inv_receipt_code

Line 1920: FROM dual

1916: BEGIN
1917: IF nvl(p_allow_unreleased_task,'Y') = 'Y' THEN
1918: SELECT 1
1919: INTO l_mmtt_rowcnt
1920: FROM dual
1921: WHERE exists (SELECT 1
1922: FROM mtl_material_transactions_temp
1923: WHERE transaction_temp_id = p_transaction_temp_id
1924: AND organization_id = p_organization_id

Line 1930: FROM dual

1926: OR parent_line_id = transaction_temp_id)); -- bulk task
1927: ELSE
1928: SELECT 1
1929: INTO l_mmtt_rowcnt
1930: FROM dual
1931: WHERE exists (SELECT 1
1932: FROM mtl_material_transactions_temp
1933: WHERE transaction_temp_id = p_transaction_temp_id
1934: AND organization_id = p_organization_id

Line 1963: FROM dual

1959:
1960: BEGIN
1961: SELECT 1
1962: INTO l_wdt_rowcnt
1963: FROM dual
1964: WHERE exists (SELECT 1
1965: FROM wms_dispatched_tasks t
1966: WHERE t.transaction_temp_id = p_transaction_temp_id
1967: AND person_id <> p_employee_id);

Line 2010: FROM DUAL;

2006: l_user_id := fnd_global.user_id;
2007:
2008: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
2009: INTO l_txn_hdr_id
2010: FROM DUAL;
2011:
2012: UPDATE mtl_material_transactions_temp
2013: SET transaction_header_id = l_txn_hdr_id ,
2014: last_update_date = Sysdate,

Line 2029: FROM dual

2025:
2026: BEGIN
2027: SELECT 1
2028: INTO l_wdt_rowcnt
2029: FROM dual
2030: WHERE exists (SELECT 1
2031: FROM wms_dispatched_tasks t
2032: WHERE t.transaction_temp_id = p_transaction_temp_id);
2033:

Line 3640: FROM dual;

3636: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
3637: LOOP
3638: SELECT mtl_material_transactions_s.NEXTVAL
3639: INTO l_new_transaction_header_id
3640: FROM dual;
3641: SELECT mtl_material_transactions_s.NEXTVAL
3642: INTO l_new_transaction_temp_id
3643: FROM dual;
3644: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;

Line 3643: FROM dual;

3639: INTO l_new_transaction_header_id
3640: FROM dual;
3641: SELECT mtl_material_transactions_s.NEXTVAL
3642: INTO l_new_transaction_temp_id
3643: FROM dual;
3644: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
3645: IF g_debug = 1 THEN
3646: mydebug( ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number,'split_task');
3647: END IF;

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

3640: FROM dual;
3641: SELECT mtl_material_transactions_s.NEXTVAL
3642: INTO l_new_transaction_temp_id
3643: FROM dual;
3644: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
3645: IF g_debug = 1 THEN
3646: mydebug( ' Calling split_mmtt for Txn. temp id : '||p_source_transaction_number,'split_task');
3647: END IF;
3648: split_mmtt(

Line 4894: FROM dual;

4890:
4891: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
4892: SELECT mtl_material_transactions_s.NEXTVAL
4893: INTO l_new_serial_txn_temp_id
4894: FROM dual;
4895: UPDATE mtl_transaction_lots_temp
4896: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
4897: last_updated_by = FND_GLOBAL.USER_ID
4898: WHERE transaction_temp_id = p_new_transaction_temp_id