DBA Data[Home] [Help]

APPS.OE_AR_ACCEPTANCE_GRP dependencies on WSH_DELIVERY_DETAILS

Line 186: wsh_delivery_details dd

182: SELECT min(dl.delivery_id)
183: INTO l_delivery_line_id
184: FROM wsh_new_deliveries dl,
185: wsh_delivery_assignments da,
186: wsh_delivery_details dd
187: WHERE dd.delivery_detail_id = da.delivery_detail_id
188: AND da.delivery_id = dl.delivery_id
189: AND dd.source_code = 'OE'
190: AND dd.source_line_id = l_line_rec.line_id;

Line 210: wsh_delivery_details dd

206: SELECT min(dl.delivery_id)
207: INTO l_delivery_line_id
208: FROM wsh_new_deliveries dl,
209: wsh_delivery_assignments da,
210: wsh_delivery_details dd
211: WHERE dd.delivery_detail_id = da.delivery_detail_id
212: AND da.delivery_id = dl.delivery_id
213: AND dd.source_code = 'OE'
214: AND dd.top_model_line_id = l_line_rec.line_id;