APPS.WMS_TASK_LOAD dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 964: SELECT mtl_material_transactions_s.NEXTVAL

960: WHEN no_data_found THEN
961: l_row_exists := 0;
962:
963: IF p_serial_allocated_flag = 'Y' THEN
964: SELECT mtl_material_transactions_s.NEXTVAL
965: INTO l_serial_transaction_temp_id
966: FROM dual;
967: END IF;
968: END;

Line 2609: SELECT mtl_material_transactions_s.NEXTVAL

2605: mydebug ('l_confirmed_sec_qty post processing before MMTT insert is ' || l_confirmed_sec_qty);
2606:
2607: IF p_insert = 'Y' THEN
2608: l_progress := '110';
2609: SELECT mtl_material_transactions_s.NEXTVAL
2610: INTO l_new_transaction_temp_id
2611: FROM DUAL;
2612: x_new_transaction_temp_id := l_new_transaction_temp_id;
2613:

Line 3726: SELECT mtl_material_transactions_s.NEXTVAL

3722: --BUG12670785 END
3723: l_mtlt_serial_temp_id := l_rec_mtlt_to_copy_from.serial_transaction_temp_id;
3724: END IF; --BUG12670785
3725:
3726: SELECT mtl_material_transactions_s.NEXTVAL
3727: INTO l_serial_transaction_temp_id
3728: FROM DUAL;
3729:
3730: ELSE

Line 5796: SELECT mtl_material_transactions_s.NEXTVAL

5792: mydebug('rec_mtlt1.group_lot_temp_id : ' || rec_mtlt1.group_lot_temp_id);
5793: mydebug('rec_mtlt1.group_lot_primary_quantity : ' || rec_mtlt1.group_lot_primary_quantity);
5794:
5795: l_serial_transaction_temp_id := NULL;
5796: SELECT mtl_material_transactions_s.NEXTVAL
5797: INTO l_serial_transaction_temp_id
5798: FROM DUAL;
5799: mydebug('l_serial_transaction_temp_id .. ' || l_serial_transaction_temp_id);
5800: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code

Line 14308: SELECT mtl_material_transactions_s.NEXTVAL

14304: end ;
14305:
14306: IF p_serial_transaction_temp_id IS NULL THEN
14307:
14308: SELECT mtl_material_transactions_s.NEXTVAL
14309: INTO p_serial_transaction_temp_id
14310: FROM DUAL;
14311:
14312: l_progress := '50';