DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 126: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

122: WHERE WCTI.ORGANIZATION_ID = p_organization_id
123: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
124: AND NOT EXISTS
125: (SELECT 'X'
126: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
127: WHERE ORGANIZATION_ID = p_organization_id
128: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
129: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
130: AND NOT EXISTS

Line 497: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

493: FROM WIP_COST_TXN_INTERFACE
494: WHERE ORGANIZATION_ID = p_organization_id
495: UNION ALL
496: SELECT TRANSACTION_SOURCE_ID
497: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
498: WHERE ORGANIZATION_ID = p_organization_id
499: AND TRANSACTION_SOURCE_TYPE_ID = 5
500: AND TRANSACTION_SOURCE_ID NOT IN
501: (SELECT TXN_SOURCE_ID