APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on OE_ORDER_LINES_ALL

Line 221: from oe_order_lines_all l,

217: l_master_count number := 0;
218: l_master_org number := 0;
219: begin
220: select count(1) into l_org_count
221: from oe_order_lines_all l,
222: wsh_delivery_details wdd
223: where l.inventory_item_id = p_item_id
224: and l.open_flag = 'Y' -- Bug 8247770
225: and wdd.released_status not in ('C','D')

Line 239: from oe_order_lines_all l,

235: from mtl_parameters
236: where organization_id = p_org_id;
237:
238: select count(1) into l_master_count
239: from oe_order_lines_all l,
240: wsh_delivery_details wdd
241: where l.inventory_item_id = p_item_id
242: and l.open_flag = 'Y' -- Bug 8247770
243: and wdd.released_status not in ('C','D')

Line 283: from oe_order_lines_all

279: and rownum = 1;
280:
281: if (l_org_count <> 1) then
282: select count(1) into l_org_count
283: from oe_order_lines_all
284: where source_type_code = 'EXTERNAL'
285: and open_flag = 'Y'
286: and nvl(shipped_quantity,0) = 0
287: and item_type_code in ('MODEL','STANDARD','OPTION')

Line 296: from oe_order_lines_all l

292: end if;
293:
294: if (l_org_count <> 1) then
295: select count(1) into l_org_count
296: from oe_order_lines_all l
297: where booked_flag = 'Y'
298: and nvl(shipped_quantity,0) = 0
299: and inventory_item_id = p_item_id
300: and open_flag = 'Y'

Line 382: from oe_order_lines_all

378: end;
379: -- fix bug: 14396273 - end, performance issue : master item entry form
380: if nvl(l_master_count, 0) <> 1 then
381: select count(1) into l_master_count /*l_org_count */ /*Bugfix 8460461 */
382: from oe_order_lines_all
383: where source_type_code = 'EXTERNAL'
384: and open_flag = 'Y'
385: and nvl(shipped_quantity,0) = 0
386: and item_type_code in ('MODEL','STANDARD','OPTION')

Line 400: from oe_order_lines_all l

396:
397: if nvl(l_master_count, 0) <> 1 then
398:
399: select count(1) into l_master_count /*l_org_count *//*bugfix 8460461 */
400: from oe_order_lines_all l
401: where booked_flag = 'Y'
402: and nvl(shipped_quantity,0) = 0
403: and inventory_item_id = p_item_id
404: and open_flag = 'Y'

Line 584: from oe_order_lines_all

580: l_master_count number := 0;
581: l_master_org number := 0;
582: begin
583: select count(1) into l_org_count
584: from oe_order_lines_all
585: where inventory_item_id = p_item_id
586: and open_flag = 'Y' -- Bug 8247770
587: and cancelled_flag = 'N'
588: and ship_from_org_id = p_org_id

Line 597: from oe_order_lines_all

593: from mtl_parameters
594: where organization_id = p_org_id;
595:
596: select count(1) into l_master_count
597: from oe_order_lines_all
598: where inventory_item_id = p_item_id
599: and open_flag = 'Y' -- Bug 8247770
600: and cancelled_flag = 'N'
601: and ship_from_org_id in (select organization_id

Line 621: from oe_order_lines_all

617: l_master_count number := 0;
618: l_master_org number := 0;
619: begin
620: select count(1) into l_org_count
621: from oe_order_lines_all
622: where inventory_item_id = p_item_id
623: and open_flag = 'Y' -- Bug 8247770
624: and cancelled_flag = 'N'
625: and ship_from_org_id = p_org_id

Line 635: from oe_order_lines_all

631: from mtl_parameters
632: where organization_id = p_org_id;
633:
634: select count(1) into l_master_count
635: from oe_order_lines_all
636: where inventory_item_id = p_item_id
637: and open_flag = 'Y' -- Bug 8247770
638: and cancelled_flag = 'N'
639: and ship_from_org_id in