APPS.WMS_TASK_LOAD dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 894: SELECT mtl_material_transactions_s.NEXTVAL

890: WHEN no_data_found THEN
891: l_row_exists := 0;
892:
893: IF p_serial_allocated_flag = 'Y' THEN
894: SELECT mtl_material_transactions_s.NEXTVAL
895: INTO l_serial_transaction_temp_id
896: FROM dual;
897: END IF;
898: END;

Line 1882: SELECT mtl_material_transactions_s.NEXTVAL

1878: mydebug ('l_confirmed_sec_qty = ' || l_confirmed_sec_qty);
1879:
1880: IF p_insert = 'Y' THEN
1881: l_progress := '110';
1882: SELECT mtl_material_transactions_s.NEXTVAL
1883: INTO l_new_transaction_temp_id
1884: FROM DUAL;
1885: x_new_transaction_temp_id := l_new_transaction_temp_id;
1886:

Line 2793: SELECT mtl_material_transactions_s.NEXTVAL

2789: IF p_serial_controlled = 'Y'
2790: THEN
2791: l_mtlt_serial_temp_id := l_rec_mtlt_to_copy_from.serial_transaction_temp_id;
2792:
2793: SELECT mtl_material_transactions_s.NEXTVAL
2794: INTO l_serial_transaction_temp_id
2795: FROM DUAL;
2796: ELSE
2797: l_serial_transaction_temp_id := NULL;

Line 4635: SELECT mtl_material_transactions_s.NEXTVAL

4631: mydebug('rec_mtlt1.group_lot_temp_id : ' || rec_mtlt1.group_lot_temp_id);
4632: mydebug('rec_mtlt1.group_lot_primary_quantity : ' || rec_mtlt1.group_lot_primary_quantity);
4633:
4634: l_serial_transaction_temp_id := NULL;
4635: SELECT mtl_material_transactions_s.NEXTVAL
4636: INTO l_serial_transaction_temp_id
4637: FROM DUAL;
4638: mydebug('l_serial_transaction_temp_id .. ' || l_serial_transaction_temp_id);
4639: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code

Line 11993: SELECT mtl_material_transactions_s.NEXTVAL

11989: AND lot_number= p_lot;
11990:
11991: IF p_serial_transaction_temp_id IS NULL THEN
11992:
11993: SELECT mtl_material_transactions_s.NEXTVAL
11994: INTO p_serial_transaction_temp_id
11995: FROM DUAL;
11996:
11997: l_progress := '50';