APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS

Line 143: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

139: WHERE WCTI.ORGANIZATION_ID = p_organization_id
140: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
141: AND NOT EXISTS
142: (SELECT 'X'
143: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
144: WHERE ORGANIZATION_ID = p_organization_id
145: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
146: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
147: AND NOT EXISTS

Line 148: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'

144: WHERE ORGANIZATION_ID = p_organization_id
145: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
146: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
147: AND NOT EXISTS
148: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
149: FROM MTL_MATERIAL_TRANSACTIONS MMT
150: WHERE MMT.COSTED_FLAG IN ('N','E')
151: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
152: AND MMT.ORGANIZATION_ID = p_organization_id

Line 149: FROM MTL_MATERIAL_TRANSACTIONS MMT

145: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
146: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
147: AND NOT EXISTS
148: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
149: FROM MTL_MATERIAL_TRANSACTIONS MMT
150: WHERE MMT.COSTED_FLAG IN ('N','E')
151: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
152: AND MMT.ORGANIZATION_ID = p_organization_id
153: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)

Line 252: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

248: FROM WIP_COST_TXN_INTERFACE WCTI
249: WHERE WCTI.ORGANIZATION_ID = p_organization_id
250: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
251: AND NOT EXISTS ( SELECT 'X'
252: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
253: WHERE ORGANIZATION_ID = p_organization_id
254: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
255: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
256: AND NOT EXISTS ( SELECT /*+ index ( mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'

Line 256: AND NOT EXISTS ( SELECT /*+ index ( mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'

252: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
253: WHERE ORGANIZATION_ID = p_organization_id
254: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
255: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
256: AND NOT EXISTS ( SELECT /*+ index ( mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
257: FROM MTL_MATERIAL_TRANSACTIONS MMT
258: WHERE MMT.COSTED_FLAG IN ( 'N' , 'E' )
259: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
260: AND MMT.ORGANIZATION_ID = p_organization_id

Line 257: FROM MTL_MATERIAL_TRANSACTIONS MMT

253: WHERE ORGANIZATION_ID = p_organization_id
254: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
255: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
256: AND NOT EXISTS ( SELECT /*+ index ( mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
257: FROM MTL_MATERIAL_TRANSACTIONS MMT
258: WHERE MMT.COSTED_FLAG IN ( 'N' , 'E' )
259: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
260: AND MMT.ORGANIZATION_ID = p_organization_id
261: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)

Line 358: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

354: WHERE WCTI.ORGANIZATION_ID = p_organization_id
355: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
356: AND NOT EXISTS
357: (SELECT 'X'
358: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
359: WHERE ORGANIZATION_ID = p_organization_id
360: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
361: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
362: AND NOT EXISTS

Line 363: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'

359: WHERE ORGANIZATION_ID = p_organization_id
360: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
361: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
362: AND NOT EXISTS
363: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
364: FROM MTL_MATERIAL_TRANSACTIONS MMT
365: WHERE MMT.COSTED_FLAG IN ('N','E')
366: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
367: AND MMT.ORGANIZATION_ID = p_organization_id

Line 364: FROM MTL_MATERIAL_TRANSACTIONS MMT

360: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
361: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
362: AND NOT EXISTS
363: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
364: FROM MTL_MATERIAL_TRANSACTIONS MMT
365: WHERE MMT.COSTED_FLAG IN ('N','E')
366: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
367: AND MMT.ORGANIZATION_ID = p_organization_id
368: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)

Line 764: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

760: FROM WIP_COST_TXN_INTERFACE
761: WHERE ORGANIZATION_ID = p_organization_id
762: UNION ALL
763: SELECT TRANSACTION_SOURCE_ID
764: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
765: WHERE ORGANIZATION_ID = p_organization_id
766: AND TRANSACTION_SOURCE_TYPE_ID = 5
767: AND TRANSACTION_SOURCE_ID NOT IN
768: (SELECT TXN_SOURCE_ID

Line 775: FROM MTL_MATERIAL_TRANSACTIONS

771: AND ORGANIZATION_ID = MMTT.ORGANIZATION_ID
772: AND LINE_STATUS = 9)
773: UNION ALL
774: SELECT TRANSACTION_SOURCE_ID
775: FROM MTL_MATERIAL_TRANSACTIONS
776: WHERE COSTED_FLAG IN ('N','E')
777: AND TRANSACTION_SOURCE_TYPE_ID = 5
778: AND ORGANIZATION_ID = p_organization_id
779: UNION ALL

Line 1154: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1150: AND wt.ORGANIZATION_ID = p_organization_id
1151: AND wt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE
1152: UNION
1153: SELECT wdct.WIP_ENTITY_ID
1154: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1155: WIP_DJ_CLOSE_TEMP wdct
1156: WHERE wdct.GROUP_ID = p_group_id
1157: AND wdct.ORGANIZATION_ID = p_organization_id
1158: AND wdct.WIP_ENTITY_ID = mmt.TRANSACTION_SOURCE_ID