DBA Data[Home] [Help]

APPS.GMI_PICK_RELEASE_PVT dependencies on WSH_DELIVERY_DETAILS

Line 96: FROM wsh_delivery_details

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

Line 115: FROM wsh_delivery_details

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'