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

Line 4240: INSERT INTO mtl_material_transactions

4236: l_stmt_num := 5;
4237: p_err_num := 0;
4238:
4239: l_stmt_num := 10;
4240: INSERT INTO mtl_material_transactions
4241: (TRANSACTION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
4242: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4243: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE,
4244: INVENTORY_ITEM_ID, ORGANIZATION_ID, TRANSACTION_TYPE_ID,

Line 4279: || 'into mtl_material_transactions.'

4275:
4276: IF (l_rows_inserted > 0 ) and (p_debug = 'Y') THEN
4277: FND_FILE.put_line(FND_FILE.LOG,to_char(l_rows_inserted)
4278: || ' row(s) inserted '
4279: || 'into mtl_material_transactions.'
4280: || ', mtl_txn_id: '
4281: || p_mtl_txn_id
4282: || ', action_id: '
4283: || p_action_id

Line 4329: MTL_MATERIAL_TRANSACTIONS MMT

4325:
4326: SELECT MMT.TRANSACTION_UOM, MSI.PRIMARY_UOM_CODE
4327: INTO l_txn_uom, l_pr_uom
4328: FROM MTL_SYSTEM_ITEMS MSI,
4329: MTL_MATERIAL_TRANSACTIONS MMT
4330: WHERE MMT.TRANSACTION_ID = p_txn_id
4331: AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID
4332: AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID;
4333:

Line 4458: mtl_material_transactions mmt

4454: 4, p_tl_osp_cost,
4455: 5, p_tl_ovh_cost)/p_min_acct_unit) * p_min_acct_unit,
4456: p_txn_qty
4457: FROM wip_discrete_jobs dj,
4458: mtl_material_transactions mmt
4459: WHERE dj.wip_entity_id = p_wip_id
4460: AND mmt.transaction_id = p_mtl_txn_id
4461: HAVING ROUND(DECODE(p_cost_element_id,
4462: 1, p_tl_mtl_cost,