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.CSTPMECS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 134: FROM mtl_material_transactions M

130: DELETE FROM cst_lists L
131: WHERE L.list_id = I_LIST_ID
132: AND EXISTS (
133: SELECT /*+ NO_UNNEST */ 'X'
134: FROM mtl_material_transactions M
135: , mtl_parameters MP
136: WHERE MP.cost_organization_id = I_ORG_ID
137: AND M.organization_id = MP.organization_id
138: AND M.inventory_item_id = L.ENTITY_ID

Line 218: FROM mtl_material_transactions MMT

214: , I_REQUEST_ID
215: , I_PROGRAM_APPL_ID
216: , I_PROGRAM_ID
217: , SYSDATE
218: FROM mtl_material_transactions MMT
219: , mtl_parameters MP
220: WHERE MP.cost_organization_id = I_ORG_ID
221: AND MMT.organization_id = MP.organization_id
222: AND MMT.OWNING_TP_TYPE = 2

Line 324: FROM mtl_material_transactions M

320: DELETE FROM cst_lists L
321: WHERE L.list_id = I_LIST_ID
322: AND NOT EXISTS (
323: SELECT 'X'
324: FROM mtl_material_transactions M
325: , mtl_parameters MP
326: WHERE MP.cost_organization_id = I_ORG_ID
327: AND M.organization_id = MP.organization_id
328: AND M.inventory_item_id = L.ENTITY_ID

Line 443: , mtl_material_transactions MMT

439: FROM /* Select and Round FROM clause */
440: mtl_parameters MP
441: , mtl_secondary_inventories MSI
442: , mtl_onhand_quantities MOH
443: , mtl_material_transactions MMT
444:
445: WHERE /* Select and Round WHERE clause */
446: MP.cost_organization_id = I_ORG_ID
447: