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_PERIODIC_AVERAGE_PROC_CP dependencies on MTL_PARAMETERS

Line 1212: , mtl_parameters mp1

1208: , mmt1.subinventory_code subinventory_code
1209: , nvl(mmt1.transfer_price,0) transfer_price
1210: FROM
1211: mtl_material_transactions mmt1
1212: , mtl_parameters mp1
1213: WHERE mmt1.transaction_date BETWEEN c_period_start_date AND c_period_end_date
1214: AND mmt1.organization_id = nvl(mmt1.owning_organization_id, mmt1.organization_id)
1215: AND nvl(mmt1.owning_tp_type,2) = 2
1216: AND mmt1.organization_id = mp1.organization_id

Line 1276: , mtl_parameters mp2

1272: , mmt2.subinventory_code subinventory_code
1273: , nvl(mmt2.transfer_price,0) transfer_price
1274: FROM
1275: mtl_material_transactions mmt2
1276: , mtl_parameters mp2
1277: WHERE mmt2.transaction_date BETWEEN c_period_start_date AND c_period_end_date
1278: AND mmt2.organization_id = nvl(mmt2.owning_organization_id, mmt2.organization_id)
1279: AND nvl(mmt2.owning_tp_type,2) = 2
1280: AND mmt2.organization_id = mp2.organization_id

Line 1297: ,mtl_parameters mp3

1293: AND ccga2.cost_group_id = c_cost_group_id))
1294: OR (mmt2.transaction_action_id = 3
1295: AND EXISTS ( SELECT 'X'
1296: FROM cst_cost_group_assignments ccga3
1297: ,mtl_parameters mp3
1298: WHERE mp3.organization_id = mmt2.transfer_organization_id
1299: AND nvl(mp3.process_enabled_flag,'N') = 'Y'
1300: AND ccga3.organization_id = mmt2.organization_id
1301: AND ccga3.cost_group_id = c_cost_group_id ))