APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS

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 131: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'

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
131: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
132: FROM MTL_MATERIAL_TRANSACTIONS MMT
133: WHERE MMT.COSTED_FLAG IN ('N','E')
134: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
135: AND MMT.ORGANIZATION_ID = p_organization_id

Line 132: FROM MTL_MATERIAL_TRANSACTIONS MMT

128: AND MMTT.TRANSACTION_SOURCE_TYPE_ID = 5
129: AND MMTT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)
130: AND NOT EXISTS
131: (SELECT /*+ index(mmt MTL_MATERIAL_TRANSACTIONS_n2) */ 'X'
132: FROM MTL_MATERIAL_TRANSACTIONS MMT
133: WHERE MMT.COSTED_FLAG IN ('N','E')
134: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
135: AND MMT.ORGANIZATION_ID = p_organization_id
136: AND MMT.TRANSACTION_SOURCE_ID = WE.WIP_ENTITY_ID)

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

Line 508: FROM MTL_MATERIAL_TRANSACTIONS

504: AND ORGANIZATION_ID = MMTT.ORGANIZATION_ID
505: AND LINE_STATUS = 9)
506: UNION ALL
507: SELECT TRANSACTION_SOURCE_ID
508: FROM MTL_MATERIAL_TRANSACTIONS
509: WHERE COSTED_FLAG IN ('N','E')
510: AND TRANSACTION_SOURCE_TYPE_ID = 5
511: AND ORGANIZATION_ID = p_organization_id
512: UNION ALL

Line 887: FROM MTL_MATERIAL_TRANSACTIONS mmt,

883: AND wt.ORGANIZATION_ID = p_organization_id
884: AND wt.TRANSACTION_DATE > wdct.ACTUAL_CLOSE_DATE
885: UNION
886: SELECT wdct.WIP_ENTITY_ID
887: FROM MTL_MATERIAL_TRANSACTIONS mmt,
888: WIP_DJ_CLOSE_TEMP wdct
889: WHERE wdct.GROUP_ID = p_group_id
890: AND wdct.ORGANIZATION_ID = p_organization_id
891: AND wdct.WIP_ENTITY_ID = mmt.TRANSACTION_SOURCE_ID