[Home] [Help]
48: end if;
49: --check at master level
50: if (l_org_count <> 1 and get_attribute_control(p_source_item) = 1) then
51: select master_organization_id into l_master_org
52: from mtl_parameters
53: where organization_id = p_org_id;
54:
55: select count(1)
56: into l_master_count
57: from mtl_cycle_count_entries
58: where inventory_item_id = p_item_id and
59: (organization_id in
60: (select organization_id
61: from mtl_parameters
62: where master_organization_id = l_master_org
63: )
64: )
65: and entry_status_code = 2
72: from mtl_physical_adjustments
73: where inventory_item_id = p_item_id
74: and (organization_id in
75: (select organization_id
76: from mtl_parameters
77: where master_organization_id = l_master_org
78: )
79: )
80: and approval_status = 1
108:
109: if (l_org_count <> 1 and
110: get_attribute_control('RESERVABLE_TYPE') = 1 ) then
111: select master_organization_id into l_master_org
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
118: and released_status = 'S'
119: and source_code = 'OE'
120: and organization_id in
121: (select organization_id
122: from mtl_parameters
123: where master_organization_id = l_master_org)
124: and rownum = 1;
125: end if;
126: if (l_org_count = 1 or l_master_count = 1) then
148:
149: if (l_org_count <> 1 and
150: get_attribute_control('RESERVABLE_TYPE') = 1 ) then
151: select master_organization_id into l_master_org
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
158: and released_status = 'Y'
159: and source_code = 'OE'
160: and organization_id in
161: (select organization_id
162: from mtl_parameters
163: where master_organization_id = l_master_org)
164: and rownum = 1;
165: end if;
166: if (l_org_count = 1 or l_master_count = 1) then
194:
195: if (l_org_count <> 1 and
196: get_attribute_control('MTL_TRANSACTIONS_ENABLED_FLAG') = 1 ) then
197: select master_organization_id into l_master_org
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,
208: --and wdd.source_code = 'OE'
209: and l.line_id = wdd.source_line_id
210: and l.ship_from_org_id in
211: (select organization_id
212: from mtl_parameters
213: where master_organization_id = l_master_org)
214: and rownum = 1;
215: end if;
216: if (l_org_count = 1 or l_master_count = 1) then
273: if (l_org_count <> 1 and
274: get_attribute_control('MTL_TRANSACTIONS_ENABLED_FLAG') = 1 ) then
275:
276: select master_organization_id into l_master_org
277: from mtl_parameters
278: where organization_id = p_org_id;
279: -- Bug: 4060557 For performance improvement, breaking the SQL
280: for i in (select organization_id
281: from mtl_parameters
277: from mtl_parameters
278: where organization_id = p_org_id;
279: -- Bug: 4060557 For performance improvement, breaking the SQL
280: for i in (select organization_id
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
298: end loop;
299:
300: if nvl(l_master_count, 0) <> 1 then
301: for i in (select organization_id
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
320:
321: if nvl(l_master_count, 0) <> 1 then
322:
323: for i in (select organization_id
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
376: -- check at master level
377: if (l_org_count <> 1 and
378: get_attribute_control(p_source_item) = 1 ) then
379: select master_organization_id into l_master_org
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
388: and released_status = 'C'
389: and source_code = 'OE'
390: and organization_id in
391: (select organization_id
392: from mtl_parameters
393: where master_organization_id = l_master_org)
394: and rownum = 1;
395: end if;
396:
424: -- check at master level
425: if (l_org_count <> 1 and
426: get_attribute_control('SERIAL_NUMBER_CONTROL_CODE') = 1 ) then
427: select master_organization_id into l_master_org
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
436: and pickable_flag = 'Y'
437: and source_code = 'OE'
438: and organization_id in
439: (select organization_id
440: from mtl_parameters
441: where master_organization_id = l_master_org)
442: and rownum = 1;
443: end if;
444:
465: and rownum = 1;
466: if (l_org_count <> 1 and
467: get_attribute_control('REPLENISH_TO_ORDER_FLAG') = 1 ) then
468: select master_organization_id into l_master_org
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
478: from mtl_parameters
479: where master_organization_id = l_master_org)
480: and rownum = 1;
481: end if;
482: if (l_org_count = 1 or l_master_count = 1) then
503:
504: if (l_org_count <> 1 and
505: get_attribute_control('SHIPPABLE_ITEM_FLAG') = 1 ) then
506: select master_organization_id into l_master_org
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
513: and nvl(open_flag,'Y') = 'Y'
514: and cancelled_flag = 'N'
515: and ship_from_org_id in
516: (select organization_id
517: from mtl_parameters
518: where master_organization_id = l_master_org)
519: and rownum = 1;
520: end if;
521: if (l_org_count = 1 or l_master_count = 1) then