[Home] [Help]
209: BEGIN
210: select count(*)
211: into l_untrxd_rec_count
212: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
213: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts
214: where
215: wdd.source_code = 'OE'
216: and wdd.released_status = 'C'
217: and wdd.inv_interfaced_flag in ('N' ,'P')
243: -- Check for Expense Destination Type Code Receiving Transactions
244: select count(*)
245: into l_rec_exp_count
246: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
247: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
248: oe_order_lines_all oel, po_requisition_lines_all pl
249: where
250: wdd.source_code = 'OE'
251: and wdd.released_status = 'C'
282: -- Check for Direct Shipment which are not Expense Destination Type Code Related
283: select count(*)
284: into l_rec_direct_count
285: from wsh_delivery_details wdd, wsh_delivery_assignments wda,
286: wsh_new_deliveries wnd, wsh_delivery_legs wdl, wsh_trip_stops wts,
287: oe_order_lines_all oel, po_requisition_lines_all pl,
288: mtl_interorg_parameters mip
289: where
290: wdd.source_code = 'OE'
1681: wdd.source_line_id = p_source_line_id
1682: and wdd.source_code = p_source_code
1683: and not exists (select 'x' from
1684: wsh_delivery_assignments wda,
1685: wsh_new_deliveries wnd
1686: where
1687: wda.delivery_detail_id = wdd.delivery_detail_id
1688: and wda.delivery_id = wnd.delivery_id
1689: and wnd.status_code in ('CL','CO', 'IT') )