174:
175: SELECT count(*)
176: INTO l_count
177: FROM
178: wsh_delivery_details wdd
179: WHERE
180: wdd.SOURCE_LINE_ID = p_line_id
181: AND wdd.inv_interfaced_flag = 'Y'
182: and wdd.SOURCE_CODE = 'OE';
199:
200: BEGIN
201:
202: select count(*) INTO l_count
203: from wsh_delivery_details wdd,
204: oe_order_lines_all l
205: where l.top_model_line_id = p_line_id
206: and wdd.source_line_id = l.line_id
207: AND wdd.inv_interfaced_flag = 'Y'