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 mp1

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

Line 1327: , mtl_parameters mp2

1323: , mmt2.subinventory_code subinventory_code
1324: , nvl(mmt2.transfer_price,0) transfer_price
1325: FROM
1326: mtl_material_transactions mmt2
1327: , mtl_parameters mp2
1328: WHERE mmt2.transaction_date BETWEEN c_period_start_date AND c_period_end_date
1329: AND mmt2.organization_id = nvl(mmt2.owning_organization_id, mmt2.organization_id)
1330: AND nvl(mmt2.owning_tp_type,2) = 2
1331: AND mmt2.organization_id = mp2.organization_id

Line 1348: ,mtl_parameters mp3

1344: AND ccga2.cost_group_id = c_cost_group_id))
1345: OR (mmt2.transaction_action_id = 3
1346: AND EXISTS ( SELECT 'X'
1347: FROM cst_cost_group_assignments ccga3
1348: ,mtl_parameters mp3
1349: WHERE mp3.organization_id = mmt2.transfer_organization_id
1350: AND nvl(mp3.process_enabled_flag,'N') = 'Y'
1351: AND ccga3.organization_id = mmt2.organization_id
1352: AND ccga3.cost_group_id = c_cost_group_id ))