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 1761: mtl_material_transactions mmt

1757: p_prg_id,
1758: sysdate,
1759: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1760: FROM mtl_pac_actual_cost_details mpacd,
1761: mtl_material_transactions mmt
1762: WHERE mpacd.txn_category = 8
1763: AND mpacd.inventory_item_id = p_inventory_item_id
1764: AND mpacd.pac_period_id = p_pac_period_id
1765: AND mpacd.cost_group_id = l_cost_group_id

Line 1803: mtl_material_transactions mmt

1799: UPDATE CST_PAC_PERIOD_BALANCES cppb
1800: SET txn_category_value =
1801: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1802: FROM mtl_pac_actual_cost_details mpacd,
1803: mtl_material_transactions mmt
1804: WHERE mpacd.txn_category = 9
1805: AND mpacd.inventory_item_id = cppb.inventory_item_id
1806: AND mpacd.pac_period_id = cppb.pac_period_id
1807: AND mpacd.transaction_id = mmt.transaction_id

Line 2903: mtl_material_transactions mmt

2899: , decode(c1.cost_group_id, p_cost_group_id, c2.cost_group_id, c1.cost_group_id) transfer_cost_group_id
2900: , l_txn_type txn_type
2901: , p_period_id pac_period_id
2902: FROM
2903: mtl_material_transactions mmt
2904: , mtl_parameters mp
2905: , cst_cost_group_assignments c1
2906: , cst_cost_group_assignments c2
2907: WHERE

Line 2965: mtl_material_transactions mmt

2961: , decode(c1.cost_group_id, p_cost_group_id, c2.cost_group_id, c1.cost_group_id) transfer_cost_group_id
2962: , l_txn_type txn_type
2963: , p_period_id pac_period_id
2964: FROM
2965: mtl_material_transactions mmt
2966: , mtl_parameters mp
2967: , cst_cost_group_assignments c1
2968: , cst_cost_group_assignments c2
2969: WHERE

Line 3068: mtl_material_transactions mmt

3064: , NULL transfer_cost_group_id
3065: , l_txn_type txn_type
3066: , p_period_id pac_period_id
3067: FROM
3068: mtl_material_transactions mmt
3069: , mtl_parameters mp
3070: , mtl_parameters mptrans
3071: WHERE
3072: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date

Line 3147: mtl_material_transactions mmt1

3143: , NULL transfer_cost_group_id
3144: , l_txn_type txn_type
3145: , p_period_id pac_period_id
3146: FROM
3147: mtl_material_transactions mmt1
3148: , mtl_parameters mp1
3149: , mtl_parameters mptrans1
3150: WHERE
3151: mmt1.transaction_date BETWEEN p_period_start_date AND p_period_end_date