DBA Data[Home] [Help]

APPS.EDW_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 178: wsh_delivery_details wdd

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';

Line 203: from wsh_delivery_details wdd,

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'