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 133: FROM mtl_material_transactions M

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

Line 194: FROM mtl_material_transactions MMT

190: , I_REQUEST_ID
191: , I_PROGRAM_APPL_ID
192: , I_PROGRAM_ID
193: , SYSDATE
194: FROM mtl_material_transactions MMT
195: , mtl_parameters MP
196: WHERE MP.cost_organization_id = I_ORG_ID
197: AND MMT.organization_id = MP.organization_id
198: AND MMT.transaction_type_id = 18

Line 278: FROM mtl_material_transactions M

274: DELETE FROM cst_lists L
275: WHERE L.list_id = I_LIST_ID
276: AND NOT EXISTS (
277: SELECT 'X'
278: FROM mtl_material_transactions M
279: , mtl_parameters MP
280: WHERE MP.cost_organization_id = I_ORG_ID
281: AND M.organization_id = MP.organization_id
282: AND M.inventory_item_id = L.ENTITY_ID

Line 397: , mtl_material_transactions MMT

393: FROM /* Select and Round FROM clause */
394: mtl_parameters MP
395: , mtl_secondary_inventories MSI
396: , mtl_onhand_quantities MOH
397: , mtl_material_transactions MMT
398:
399: WHERE /* Select and Round WHERE clause */
400: MP.cost_organization_id = I_ORG_ID
401: