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_PAC_ITERATION_PROCESS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1877: mtl_material_transactions mmt

1873: p_prg_id,
1874: sysdate,
1875: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1876: FROM mtl_pac_actual_cost_details mpacd,
1877: mtl_material_transactions mmt
1878: WHERE mpacd.txn_category = 8
1879: AND mpacd.inventory_item_id = p_inventory_item_id
1880: AND mpacd.pac_period_id = p_pac_period_id
1881: AND mpacd.cost_group_id = l_cost_group_id

Line 1919: mtl_material_transactions mmt

1915: UPDATE CST_PAC_PERIOD_BALANCES cppb
1916: SET txn_category_value =
1917: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1918: FROM mtl_pac_actual_cost_details mpacd,
1919: mtl_material_transactions mmt
1920: WHERE mpacd.txn_category = 9
1921: AND mpacd.inventory_item_id = cppb.inventory_item_id
1922: AND mpacd.pac_period_id = cppb.pac_period_id
1923: AND mpacd.transaction_id = mmt.transaction_id

Line 3049: mtl_material_transactions mmt

3045: , decode(c1.cost_group_id, p_cost_group_id, c2.cost_group_id, c1.cost_group_id) transfer_cost_group_id
3046: , l_txn_type txn_type
3047: , p_period_id pac_period_id
3048: FROM
3049: mtl_material_transactions mmt
3050: , mtl_parameters mp
3051: , cst_cost_group_assignments c1
3052: , cst_cost_group_assignments c2
3053: , cst_cost_groups ccg1

Line 3116: mtl_material_transactions mmt

3112: , decode(c1.cost_group_id, p_cost_group_id, c2.cost_group_id, c1.cost_group_id) transfer_cost_group_id
3113: , l_txn_type txn_type
3114: , p_period_id pac_period_id
3115: FROM
3116: mtl_material_transactions mmt
3117: , mtl_parameters mp
3118: , cst_cost_group_assignments c1
3119: , cst_cost_group_assignments c2
3120: , cst_cost_groups ccg1

Line 3224: mtl_material_transactions mmt

3220: , NULL transfer_cost_group_id
3221: , l_txn_type txn_type
3222: , p_period_id pac_period_id
3223: FROM
3224: mtl_material_transactions mmt
3225: , mtl_parameters mp
3226: , mtl_parameters mptrans
3227: WHERE
3228: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date

Line 3303: mtl_material_transactions mmt1

3299: , NULL transfer_cost_group_id
3300: , l_txn_type txn_type
3301: , p_period_id pac_period_id
3302: FROM
3303: mtl_material_transactions mmt1
3304: , mtl_parameters mp1
3305: , mtl_parameters mptrans1
3306: WHERE
3307: mmt1.transaction_date BETWEEN p_period_start_date AND p_period_end_date