34: AND NVL(LOCK_FLAG,2) = 2
35: AND TRANSACTION_MODE = 3
36: AND EXISTS (
37: SELECT 'X'
38: FROM MTL_TRANSACTION_TYPES MTT
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
51: AND NVL(LOCK_FLAG,2) = 2
52: AND TRANSACTION_MODE = 3
53: AND EXISTS (
54: SELECT 'X'
55: FROM MTL_TRANSACTION_TYPES MTT
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
103: AND NVL(LOCK_FLAG,2) = 2
104: AND TRANSACTION_MODE = 3
105: AND EXISTS (
106: SELECT 'X'
107: FROM MTL_TRANSACTION_TYPES MTT
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
142: and nvl(lock_flag,2) = 2
143: and transaction_mode = 3
144: and exists (
145: select 'X'
146: FROM MTL_TRANSACTION_TYPES MTT
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
172: and nvl(lock_flag,2) = 2
173: and transaction_mode = 3
174: and exists (
175: select 'X'
176: from mtl_transaction_types mtt
177: where mtt.transaction_type_id = mti.transaction_type_id
178: and mtt.transaction_source_type_id in (2,8,16))
179: and transaction_batch_id is not null
180: and transaction_batch_id in (
282: and nvl(lock_flag,2) = 2
283: and transaction_mode = 3
284: and exists (
285: select 'X'
286: from mtl_transaction_types mtt
287: where mtt.transaction_type_id = mti.transaction_type_id
288: and mtt.transaction_source_type_id in (2,8,16))
289: and inventory_item_id in (
290: select mti2.inventory_item_id
321: and nvl(lock_flag,2) = 2
322: and transaction_mode = 3
323: and exists (
324: select 'X'
325: from mtl_transaction_types mtt
326: where mtt.transaction_type_id = mti.transaction_type_id
327: and mtt.transaction_source_type_id in (2,8,16))
328: and transaction_batch_id is not null
329: and transaction_batch_id in (
378: AND NVL(LOCK_FLAG,2) = 2
379: AND TRANSACTION_MODE = 3
380: AND EXISTS (
381: SELECT 'X'
382: FROM MTL_TRANSACTION_TYPES MTT
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
417: and nvl(lock_flag,2) = 2
418: and transaction_mode = 3
419: and exists (
420: select 'X'
421: FROM MTL_TRANSACTION_TYPES MTT
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
447: and nvl(lock_flag,2) = 2
448: and transaction_mode = 3
449: and exists (
450: select 'X'
451: from mtl_transaction_types mtt
452: where mtt.transaction_type_id = mti.transaction_type_id
453: and mtt.transaction_source_type_id not in (2,5,8,16))
454: and transaction_batch_id is not null
455: and transaction_batch_id in (
557: and nvl(lock_flag,2) = 2
558: and transaction_mode = 3
559: and exists (
560: select 'X'
561: from mtl_transaction_types mtt
562: where mtt.transaction_type_id = mti.transaction_type_id
563: and mtt.transaction_source_type_id not in (2,5,8,16))
564: and inventory_item_id in (
565: select mti2.inventory_item_id
596: and nvl(lock_flag,2) = 2
597: and transaction_mode = 3
598: and exists (
599: select 'X'
600: from mtl_transaction_types mtt
601: where mtt.transaction_type_id = mti.transaction_type_id
602: and mtt.transaction_source_type_id not in (2,5,8,16))
603: and transaction_batch_id is not null
604: and transaction_batch_id in (