APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on OE_ORDER_LINES_ALL

Line 184: from oe_order_lines_all l,

180: l_master_count number := 0;
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')

Line 202: from oe_order_lines_all l,

198: from mtl_parameters
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')

Line 246: from oe_order_lines_all

242: and rownum = 1;
243:
244: if (l_org_count <> 1) then
245: select count(1) into l_org_count
246: from oe_order_lines_all
247: where source_type_code = 'EXTERNAL'
248: and open_flag = 'Y'
249: and nvl(shipped_quantity,0) = 0
250: and item_type_code in ('MODEL','STANDARD','OPTION')

Line 259: from oe_order_lines_all l

255: end if;
256:
257: if (l_org_count <> 1) then
258: select count(1) into l_org_count
259: from oe_order_lines_all l
260: where booked_flag = 'Y'
261: and nvl(shipped_quantity,0) = 0
262: and inventory_item_id = p_item_id
263: and open_flag = 'Y'

Line 306: from oe_order_lines_all

302: from mtl_parameters
303: where master_organization_id = l_master_org)
304: loop
305: select count(1) into l_org_count
306: from oe_order_lines_all
307: where source_type_code = 'EXTERNAL'
308: and open_flag = 'Y'
309: and nvl(shipped_quantity,0) = 0
310: and item_type_code in ('MODEL','STANDARD','OPTION')

Line 328: from oe_order_lines_all l

324: from mtl_parameters
325: where master_organization_id = l_master_org)
326: loop
327: select count(1) into l_org_count
328: from oe_order_lines_all l
329: where booked_flag = 'Y'
330: and nvl(shipped_quantity,0) = 0
331: and inventory_item_id = p_item_id
332: and open_flag = 'Y'

Line 460: from oe_order_lines_all

456: l_master_count number := 0;
457: l_master_org number := 0;
458: begin
459: select count(1) into l_org_count
460: from oe_order_lines_all
461: where inventory_item_id = p_item_id
462: and nvl(open_flag,'Y') = 'Y'
463: and cancelled_flag = 'N'
464: and ship_from_org_id = p_org_id

Line 473: from oe_order_lines_all

469: from mtl_parameters
470: where organization_id = p_org_id;
471:
472: select count(1) into l_master_count
473: from oe_order_lines_all
474: where inventory_item_id = p_item_id
475: and nvl(open_flag,'Y') = 'Y'
476: and cancelled_flag = 'N'
477: and ship_from_org_id in (select organization_id

Line 497: from oe_order_lines_all

493: l_master_count number := 0;
494: l_master_org number := 0;
495: begin
496: select count(1) into l_org_count
497: from oe_order_lines_all
498: where inventory_item_id = p_item_id
499: and nvl(open_flag,'Y') = 'Y'
500: and cancelled_flag = 'N'
501: and ship_from_org_id = p_org_id

Line 511: from oe_order_lines_all

507: from mtl_parameters
508: where organization_id = p_org_id;
509:
510: select count(1) into l_master_count
511: from oe_order_lines_all
512: where inventory_item_id = p_item_id
513: and nvl(open_flag,'Y') = 'Y'
514: and cancelled_flag = 'N'
515: and ship_from_org_id in