APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on WSH_DELIVERY_DETAILS

Line 102: from wsh_delivery_details

98: l_master_count number := 0;
99: l_master_org number := 0;
100: begin
101: select count(1) into l_org_count
102: from wsh_delivery_details
103: where inventory_item_id = p_item_id
104: and released_status = 'S'
105: and source_code = 'OE'
106: and organization_id = p_org_id

Line 116: from wsh_delivery_details

112: from mtl_parameters
113: where organization_id = p_org_id;
114:
115: select count(1) into l_master_count
116: from wsh_delivery_details
117: where inventory_item_id = p_item_id
118: and released_status = 'S'
119: and source_code = 'OE'
120: and organization_id in

Line 142: from wsh_delivery_details

138: l_master_count number := 0;
139: l_master_org number := 0;
140: begin
141: select count(1) into l_org_count
142: from wsh_delivery_details
143: where inventory_item_id = p_item_id
144: and released_status = 'Y'
145: and source_code = 'OE'
146: and organization_id = p_org_id

Line 156: from wsh_delivery_details

152: from mtl_parameters
153: where organization_id = p_org_id;
154:
155: select count(1) into l_master_count
156: from wsh_delivery_details
157: where inventory_item_id = p_item_id
158: and released_status = 'Y'
159: and source_code = 'OE'
160: and organization_id in

Line 185: wsh_delivery_details wdd

181: l_master_org number := 0;
182: begin
183: select count(1) into l_org_count
184: from oe_order_lines_all l,
185: wsh_delivery_details wdd
186: where l.inventory_item_id = p_item_id
187: and nvl(l.open_flag,'Y') = 'Y'
188: and wdd.released_status not in ('C','D')
189: and wdd.pickable_flag = 'N'

Line 203: wsh_delivery_details wdd

199: where organization_id = p_org_id;
200:
201: select count(1) into l_master_count
202: from oe_order_lines_all l,
203: wsh_delivery_details wdd
204: where l.inventory_item_id = p_item_id
205: and nvl(l.open_flag,'Y') = 'Y'
206: and wdd.released_status not in ('C','D')
207: and wdd.pickable_flag = 'N'

Line 234: from wsh_delivery_details

230: l_master_count number := 0;
231: l_master_org number := 0;
232: begin
233: select count(1) into l_org_count
234: from wsh_delivery_details
235: where inventory_item_id = p_item_id
236: and pickable_flag = 'Y'
237: --Bug 4643978 - Perf fix
238: and inv_interfaced_flag IN ('N','P')

Line 285: from wsh_delivery_details

281: from mtl_parameters
282: where master_organization_id = l_master_org)
283: loop
284: select count(1) into l_master_count
285: from wsh_delivery_details
286: where inventory_item_id = p_item_id
287: and pickable_flag = 'Y'
288: --Bug 4643978 - Perf fix
289: and inv_interfaced_flag IN ('N','P')

Line 367: from wsh_delivery_details

363: l_master_org number := 0;
364: begin
365: -- check at org level
366: select count(1) into l_org_count
367: from wsh_delivery_details
368: where inventory_item_id = p_item_id
369: and oe_interfaced_flag = 'Y'
370: and nvl(inv_interfaced_flag,'N') not in ('Y','X')
371: and released_status = 'C'

Line 384: from wsh_delivery_details

380: from mtl_parameters
381: where organization_id = p_org_id;
382: select count(1)
383: into l_master_count
384: from wsh_delivery_details
385: where inventory_item_id = p_item_id
386: and oe_interfaced_flag = 'Y'
387: and nvl(inv_interfaced_flag,'N') not in ('Y','X')
388: and released_status = 'C'

Line 415: from wsh_delivery_details

411: begin
412: -- check at org level
413: select count(1)
414: into l_org_count
415: from wsh_delivery_details
416: where inventory_item_id = p_item_id
417: and released_status not in ('B','R','D')
418: and nvl(inv_interfaced_flag,'N') not in ('Y','X')
419: and pickable_flag = 'Y'

Line 432: from wsh_delivery_details

428: from mtl_parameters
429: where organization_id = p_org_id;
430: select count(1)
431: into l_master_count
432: from wsh_delivery_details
433: where inventory_item_id = p_item_id
434: and released_status not in ('B','R','D')
435: and nvl(inv_interfaced_flag,'N') not in ('Y','X')
436: and pickable_flag = 'Y'