APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 1891: sequence mtl_material_transactions_s as group_mark_id.

1887: detail id as the group mark id, temp lot id and temp id to
1888: identify the serial numbers in mtl serial numbers.
1889: - after fix : When serial_number is
1890: not null, use the transaction_temp_id created by using the
1891: sequence mtl_material_transactions_s as group_mark_id.
1892: - frontport bug 5028993 : change to here
1893: If the qty
1894: is greater than 1, then it uses the transaction temp id to
1895: fetch all the serial number ranges and then calls the mark API

Line 1919: SELECT mtl_material_transactions_s.nextval

1915: WHERE transaction_temp_id = p_transaction_temp_id;
1916:
1917: -- Bug 5028993: needs to pass transaction_temp_id
1918: CURSOR c_temp_id IS
1919: SELECT mtl_material_transactions_s.nextval
1920: FROM dual;
1921:
1922: l_inv_item_id NUMBER;
1923: l_org_id NUMBER;