APPS.INV_ENHANCED_TM_PERF dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 43: from org_organization_definitions ood

39: WHERE MTT.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
40: AND MTT.TRANSACTION_SOURCE_TYPE_ID IN (2,8,16))
41: and exists (
42: select 1
43: from org_organization_definitions ood
44: where ood.organization_id = mti.organization_id
45: and nvl(ood.disable_date, sysdate + 1) > sysdate)
46: order by mti.inventory_item_id;
47:

Line 60: from org_organization_definitions ood

56: WHERE MTT.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
57: AND MTT.TRANSACTION_SOURCE_TYPE_ID NOT IN (2,5,8,16))
58: and exists (
59: select 1
60: from org_organization_definitions ood
61: where ood.organization_id = mti.organization_id
62: and nvl(ood.disable_date, sysdate + 1) > sysdate)
63: order by mti.inventory_item_id;
64:

Line 112: from org_organization_definitions ood

108: WHERE MTT.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
109: AND MTT.TRANSACTION_SOURCE_TYPE_ID IN (2,8,16))
110: and exists (
111: select 1
112: from org_organization_definitions ood
113: where ood.organization_id = mti.organization_id
114: and nvl(ood.disable_date, sysdate + 1) > sysdate)
115: group by inventory_item_id
116: having count(*) >= p_maxrows

Line 151: from org_organization_definitions ood

147: where mtt.transaction_type_id = mti.transaction_type_id
148: and mtt.transaction_source_type_id in (2,8,16))
149: and exists (
150: select 1
151: from org_organization_definitions ood
152: where ood.organization_id = mti.organization_id
153: and nvl(ood.disable_date, sysdate + 1) > sysdate);
154:
155: l_rowcount := l_rowcount + sql%rowcount;

Line 190: from org_organization_definitions ood

186: and mti2.error_code is null
187: and mti2.error_explanation is null)
188: and exists ( /* Bug 6223219 */
189: select 1
190: from org_organization_definitions ood
191: where ood.organization_id = mti.organization_id
192: and nvl(ood.disable_date, sysdate + 1) > sysdate);
193:
194: l_rowcount := l_rowcount + sql%rowcount;

Line 298: from org_organization_definitions ood

294: and mti2.error_code is null
295: and mti2.ERROR_EXPLANATION is NULL)
296: and exists ( /* Bug 5951465 */
297: SELECT 1
298: from org_organization_definitions ood
299: where ood.organization_id = mti.organization_id
300: and nvl(ood.disable_date, sysdate + 1) > sysdate);
301:
302: l_rowcount := l_rowcount + sql%rowcount;

Line 339: from org_organization_definitions ood

335: and mti2.error_code is null
336: and mti2.error_explanation is null)
337: and exists ( /* Bug 6223219 */
338: select 1
339: from org_organization_definitions ood
340: where ood.organization_id = mti.organization_id
341: and nvl(ood.disable_date, sysdate + 1) > sysdate);
342:
343: l_rowcount := l_rowcount + SQL%ROWCOUNT;

Line 387: from org_organization_definitions ood

383: WHERE MTT.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
384: AND MTT.TRANSACTION_SOURCE_TYPE_ID NOT IN (2,5,8,16))
385: and exists (
386: select 1
387: from org_organization_definitions ood
388: where ood.organization_id = mti.organization_id
389: and nvl(ood.disable_date, sysdate + 1) > sysdate)
390: group by inventory_item_id
391: having count(*) >= p_maxrows

Line 426: from org_organization_definitions ood

422: where mtt.transaction_type_id = mti.transaction_type_id
423: and mtt.transaction_source_type_id not in (2,5,8,16))
424: and exists (
425: select 1
426: from org_organization_definitions ood
427: where ood.organization_id = mti.organization_id
428: and nvl(ood.disable_date, sysdate + 1) > sysdate);
429:
430: l_rowcount := l_rowcount + sql%rowcount;

Line 465: from org_organization_definitions ood

461: and mti2.error_code is null
462: and mti2.error_explanation is null)
463: and exists ( /* Bug 6223219 */
464: select 1
465: from org_organization_definitions ood
466: where ood.organization_id = mti.organization_id
467: and nvl(ood.disable_date, sysdate + 1) > sysdate);
468:
469: l_rowcount := l_rowcount + sql%rowcount;

Line 573: from org_organization_definitions ood

569: and mti2.error_code is null
570: and mti2.ERROR_EXPLANATION is NULL)
571: and exists ( /* Bug 5951465 */
572: SELECT 1
573: from org_organization_definitions ood
574: where ood.organization_id = mti.organization_id
575: and nvl(ood.disable_date, sysdate + 1) > sysdate);
576:
577: l_rowcount := l_rowcount + sql%rowcount;

Line 614: from org_organization_definitions ood

610: and mti2.error_code is null
611: and mti2.error_explanation is null)
612: and exists ( /* Bug 6223219 */
613: select 1
614: from org_organization_definitions ood
615: where ood.organization_id = mti.organization_id
616: and nvl(ood.disable_date, sysdate + 1) > sysdate);
617:
618: l_rowcount := l_rowcount + SQL%ROWCOUNT;