APPS.WSH_DELIVERY_DETAILS_INV dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2117: sequence mtl_material_transactions_s as group_mark_id.

2113: detail id as the group mark id, temp lot id and temp id to
2114: identify the serial numbers in mtl serial numbers.
2115: - after fix : When serial_number is
2116: not null, use the transaction_temp_id created by using the
2117: sequence mtl_material_transactions_s as group_mark_id.
2118: - frontport bug 5028993 : change to here
2119: If the qty
2120: is greater than 1, then it uses the transaction temp id to
2121: fetch all the serial number ranges and then calls the mark API

Line 2145: SELECT mtl_material_transactions_s.nextval

2141: WHERE transaction_temp_id = p_transaction_temp_id;
2142:
2143: -- Bug 5028993: needs to pass transaction_temp_id
2144: CURSOR c_temp_id IS
2145: SELECT mtl_material_transactions_s.nextval
2146: FROM dual;
2147:
2148: l_inv_item_id NUMBER;
2149: l_org_id NUMBER;