APPS.WMS_BULK_PICK dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 895: select mtl_material_transactions_s.NEXTVAL

891: mydebug('BULK_PICK:create_sub_transfer:get the rec for the child:'||l_mmtt_rec.transaction_temp_id,
892: l_api_name);
893: END IF;
894:
895: select mtl_material_transactions_s.NEXTVAL
896: into l_new_temp_id
897: from dual;
898:
899: l_mmtt_rec.primary_quantity := p_pri_qty;

Line 1413: SELECT mtl_material_transactions_s.NEXTVAL

1409: END IF;
1410:
1411: -- processed child lines will get a new header id
1412:
1413: SELECT mtl_material_transactions_s.NEXTVAL
1414: INTO x_new_txn_hdr_id
1415: FROM DUAL;
1416:
1417: IF (l_debug = 1) THEN

Line 1681: SELECT mtl_material_transactions_s.NEXTVAL

1677: END IF;
1678: l_child_txn_temp_id := c_mmtt_line.transaction_temp_id;
1679: l_link_mtlt_needed := 'N';
1680: ELSE -- qty in mmtt > qty processed ,split anyway, will be cleaned up later on
1681: SELECT mtl_material_transactions_s.NEXTVAL
1682: INTO l_new_temp_id
1683: FROM dual;
1684:
1685: IF (l_debug = 1) THEN

Line 1941: SELECT mtl_material_transactions_s.NEXTVAL

1937: mydebug('mmtt qty < child ' , l_api_name);
1938: mydebug('l_process_qty ' ||l_process_qty, l_api_name);
1939: END IF;
1940: -- Split the Child mmtt and insert mtlt.
1941: SELECT mtl_material_transactions_s.NEXTVAL
1942: INTO l_new_temp_id
1943: FROM dual;
1944:
1945: l_progress := 3.2;

Line 2162: select mtl_material_transactions_s.NEXTVAL

2158: l_child_pri_qty := 0;
2159:
2160: EXIT WHEN l_parent_txn_qty = 0;
2161: ELSE -- Current Child Qty is greater than Parent Picked Qty
2162: select mtl_material_transactions_s.NEXTVAL
2163: into l_new_temp_id
2164: from dual;
2165:
2166: split_child_mmtt(l_child_txn_temp_id,