eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_DIAGNOSTICS_PKG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 153: FROM mtl_material_transactions_temp MMTP

149: nvl(logical_transactions_created, 1) = 2
150: OR
151: EXISTS (
152: SELECT null
153: FROM mtl_material_transactions_temp MMTP
154: WHERE MMT.transaction_action_id IN (30, 31)
155: AND MMT.organization_id = MMTP.organization_id
156: AND (MMT.COMPLETION_TRANSACTION_ID = MMTP.COMPLETION_TRANSACTION_ID
157: -- Added for bug 4256685

Line 306: FROM mtl_material_transactions_temp MMTP

302: nvl(logical_transactions_created, 1) = 2
303: OR
304: EXISTS (
305: SELECT null
306: FROM mtl_material_transactions_temp MMTP
307: WHERE MMT.transaction_action_id IN (30, 31)
308: AND MMT.organization_id = MMTP.organization_id
309: AND (MMT.COMPLETION_TRANSACTION_ID = MMTP.COMPLETION_TRANSACTION_ID
310: -- Added for bug 4256685

Line 832: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,

828: ( L_TXN_SOURCE_TYPE_ID =5 ) THEN
829:
830: SELECT COUNT(MMTT.COMPLETION_TRANSACTION_ID)
831: INTO L_MMTT_COUNT
832: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
833: CST_DIAG_ERRORED_TXNS SC
834: WHERE SC.ORGANIZATION_ID = L_ORGANIZATION_ID
835: AND SC.TRANSACTION_SOURCE_TYPE_ID = 5
836: AND MMTT.ORGANIZATION_ID = SC.ORGANIZATION_ID