eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_PARAMETERS

Line 78: from mtl_parameters

74: end if;
75: --check at master level
76: if (l_org_count <> 1 and get_attribute_control(p_source_item) = 1) then
77: select master_organization_id into l_master_org
78: from mtl_parameters
79: where organization_id = p_org_id;
80:
81: select count(1)
82: into l_master_count

Line 87: from mtl_parameters

83: from mtl_cycle_count_entries
84: where inventory_item_id = p_item_id and
85: (organization_id in
86: (select organization_id
87: from mtl_parameters
88: where master_organization_id = l_master_org
89: )
90: )
91: /*Change for bug 8208397*/ /*Check should be for status 1-Uncounted/2-Pending Approval/3-Recount*/

Line 105: from mtl_parameters

101: from mtl_physical_adjustments
102: where inventory_item_id = p_item_id
103: and (organization_id in
104: (select organization_id
105: from mtl_parameters
106: where master_organization_id = l_master_org
107: )
108: )
109: and approval_status = 1

Line 149: from mtl_parameters

145:
146: if (l_org_count <> 1 and
147: get_attribute_control('RESERVABLE_TYPE') = 1 ) then
148: select master_organization_id into l_master_org
149: from mtl_parameters
150: where organization_id = p_org_id;
151:
152: select count(1) into l_master_count
153: from wsh_delivery_details

Line 159: from mtl_parameters

155: and released_status = 'S'
156: and source_code = 'OE'
157: and organization_id in
158: (select organization_id
159: from mtl_parameters
160: where master_organization_id = l_master_org)
161: and rownum = 1;
162: end if;
163: if (l_org_count = 1 or l_master_count = 1) then

Line 189: from mtl_parameters

185:
186: if (l_org_count <> 1 and
187: get_attribute_control('RESERVABLE_TYPE') = 1 ) then
188: select master_organization_id into l_master_org
189: from mtl_parameters
190: where organization_id = p_org_id;
191:
192: select count(1) into l_master_count
193: from wsh_delivery_details

Line 199: from mtl_parameters

195: and released_status = 'Y'
196: and source_code = 'OE'
197: and organization_id in
198: (select organization_id
199: from mtl_parameters
200: where master_organization_id = l_master_org)
201: and rownum = 1;
202: end if;
203: if (l_org_count = 1 or l_master_count = 1) then

Line 235: from mtl_parameters

231:
232: if (l_org_count <> 1 and
233: get_attribute_control('MTL_TRANSACTIONS_ENABLED_FLAG') = 1 ) then
234: select master_organization_id into l_master_org
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,

Line 249: from mtl_parameters

245: --and wdd.source_code = 'OE'
246: and l.line_id = wdd.source_line_id
247: and l.ship_from_org_id in
248: (select organization_id
249: from mtl_parameters
250: where master_organization_id = l_master_org)
251: and rownum = 1;
252: end if;
253: if (l_org_count = 1 or l_master_count = 1) then

Line 337: from mtl_parameters

333: if (l_org_count <> 1 and
334: get_attribute_control('MTL_TRANSACTIONS_ENABLED_FLAG') = 1 ) then
335:
336: select master_organization_id into l_master_org
337: from mtl_parameters
338: where organization_id = p_org_id;
339: -- Bug: 4060557 For performance improvement, breaking the SQL
340: -- fix bug: 14396273 - start, performance issue : master item entry form
341: /*

Line 343: from mtl_parameters

339: -- Bug: 4060557 For performance improvement, breaking the SQL
340: -- fix bug: 14396273 - start, performance issue : master item entry form
341: /*
342: for i in (select organization_id
343: from mtl_parameters
344: where master_organization_id = l_master_org)
345: loop
346: select count(1) into l_master_count
347: from wsh_delivery_details

Line 365: join mtl_parameters mp using (organization_id)

361: */
362: begin
363: select count(1) into l_master_count
364: from wsh_delivery_details
365: join mtl_parameters mp using (organization_id)
366: where inventory_item_id = p_item_id
367: and pickable_flag = 'Y'
368: --Bug 4643978 - Perf fix
369: and inv_interfaced_flag IN ('N','P')

Line 391: from mtl_parameters

387: and FLOW_STATUS_CODE = 'AWAITING_RECEIPT'
388: and inventory_item_id = p_item_id
389: -- bug 9558897, base bug 9327156, perf issue
390: and ship_from_org_id in (select organization_id
391: from mtl_parameters
392: where master_organization_id = l_master_org)
393: -- bug 9558897, base bug 9327156, perf issue
394: and rownum = 1;
395: end if;

Line 407: from mtl_parameters

403: and inventory_item_id = p_item_id
404: and open_flag = 'Y'
405: -- bug 9558897, base bug 9327156, perf issue
406: and ship_from_org_id in (select organization_id
407: from mtl_parameters
408: where master_organization_id = l_master_org)
409: -- bug 9558897, base bug 9327156, perf issue
410: and exists (select 1
411: from mtl_transactions_interface

Line 423: from mtl_parameters

419: if nvl(l_master_count, 0) <> 1 then -- Added for bug#8460461 Starts here
420: -- fix bug: 14396273 - start, performance issue : master item entry form
421: /*
422: for i in (select organization_id
423: from mtl_parameters
424: where master_organization_id = l_master_org)
425: loop
426: select count(1) into l_master_count
427: from mtl_supply

Line 440: join mtl_parameters mp on to_organization_id = organization_id

436: */
437: begin
438: select count(1) into l_master_count
439: from mtl_supply
440: join mtl_parameters mp on to_organization_id = organization_id
441: where item_id = p_item_id
442: and mp.master_organization_id = l_master_org
443: group by to_organization_id
444: having count(1) = 1;

Line 461: from mtl_parameters

457: FROM GME_MATERIAL_DETAILS D, GME_BATCH_HEADER H
458: WHERE D.INVENTORY_ITEM_ID = p_item_id
459: AND D.ORGANIZATION_ID in
460: (select organization_id
461: from mtl_parameters
462: where master_organization_id = l_master_org)
463: AND D.BATCH_ID = H.BATCH_ID
464: AND (NVL(H.GL_POSTED_IND, 0) = 0 AND
465: H.BATCH_STATUS IN (1, 2, 3, 4))

Line 504: from mtl_parameters

500: -- check at master level
501: if (l_org_count <> 1 and
502: get_attribute_control(p_source_item) = 1 ) then
503: select master_organization_id into l_master_org
504: from mtl_parameters
505: where organization_id = p_org_id;
506: select count(1)
507: into l_master_count
508: from wsh_delivery_details

Line 516: from mtl_parameters

512: and released_status = 'C'
513: and source_code = 'OE'
514: and organization_id in
515: (select organization_id
516: from mtl_parameters
517: where master_organization_id = l_master_org)
518: and rownum = 1;
519: end if;
520:

Line 552: from mtl_parameters

548: -- check at master level
549: if (l_org_count <> 1 and
550: get_attribute_control('SERIAL_NUMBER_CONTROL_CODE') = 1 ) then
551: select master_organization_id into l_master_org
552: from mtl_parameters
553: where organization_id = p_org_id;
554: select count(1)
555: into l_master_count
556: from wsh_delivery_details

Line 564: from mtl_parameters

560: and pickable_flag = 'Y'
561: and source_code = 'OE'
562: and organization_id in
563: (select organization_id
564: from mtl_parameters
565: where master_organization_id = l_master_org)
566: and rownum = 1;
567: end if;
568:

Line 593: from mtl_parameters

589: and rownum = 1;
590: if (l_org_count <> 1 and
591: get_attribute_control('REPLENISH_TO_ORDER_FLAG') = 1 ) then
592: select master_organization_id into l_master_org
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

Line 602: from mtl_parameters

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
602: from mtl_parameters
603: where master_organization_id = l_master_org)
604: and rownum = 1;
605: end if;
606: if (l_org_count = 1 or l_master_count = 1) then

Line 631: from mtl_parameters

627:
628: if (l_org_count <> 1 and
629: get_attribute_control('SHIPPABLE_ITEM_FLAG') = 1 ) then
630: select master_organization_id into l_master_org
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

Line 641: from mtl_parameters

637: and open_flag = 'Y' -- Bug 8247770
638: and cancelled_flag = 'N'
639: and ship_from_org_id in
640: (select organization_id
641: from mtl_parameters
642: where master_organization_id = l_master_org)
643: and rownum = 1;
644: end if;
645: if (l_org_count = 1 or l_master_count = 1) then