DBA Data[Home] [Help]

APPS.OE_AR_ACCEPTANCE_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 185: wsh_delivery_assignments da,

181: BEGIN
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'

Line 209: wsh_delivery_assignments da,

205: BEGIN
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'