92: SELECT delivery_detail_id
93: , requested_quantity
94: , requested_quantity2
95: , source_line_id
96: FROM wsh_delivery_details
97: WHERE move_order_line_id = p_mo_line_rec.line_id
98: AND released_status = 'S';
99:
100: CURSOR c_get_trans_for_del(source_line_id NUMBER
111: FROM ic_tran_pnd
112: WHERE line_id = p_mo_line_rec.txn_source_line_id
113: AND line_detail_id IN (
114: SELECT delivery_detail_id
115: FROM wsh_delivery_details
116: WHERE move_order_line_id = p_mo_line_rec.line_id
117: AND source_line_id = p_mo_line_rec.txn_source_line_id
118: AND released_status IN ('R', 'S'))
119: AND doc_type = 'OMSO'