APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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 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 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 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