DBA Data[Home] [Help]

APPS.OE_AR_ACCEPTANCE_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 187: wsh_delivery_assignments da,

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

Line 211: wsh_delivery_assignments da,

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