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.

[Home] [Help]

APPS.CST_PERIODIC_AVERAGE_PROC_CP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 776: FROM mtl_material_transactions mmt

772: , mmt.primary_quantity
773: , mmt.organization_id
774: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
775: , mmt.subinventory_code
776: FROM mtl_material_transactions mmt
777: , mtl_transaction_types mtt
778: WHERE mmt.transaction_date between p_start_date
779: AND p_end_date
780: AND mmt.transaction_action_id = 24

Line 798: FROM mtl_material_transactions mmt

794: , mmt.primary_quantity
795: , mmt.organization_id
796: , nvl(mmt.transfer_organization_id,-1) transfer_organization_id
797: , mmt.subinventory_code
798: FROM mtl_material_transactions mmt
799: , mtl_transaction_types mtt
800: WHERE mmt.transaction_date between p_start_date
801: AND p_end_date
802: AND mmt.transaction_action_id = 24

Line 1181: FROM mtl_material_transactions mmt

1177: , mmt.organization_id organization_id
1178: , NVL(mmt.transfer_organization_id,-1) transfer_organization_id
1179: , mmt.subinventory_code subinventory_code
1180: , nvl(mmt.transfer_price,0) transfer_price
1181: FROM mtl_material_transactions mmt
1182: , cst_cost_group_assignments ccga
1183: WHERE mmt.transaction_date BETWEEN c_period_start_date
1184: AND c_period_end_date
1185: AND ccga.organization_id = mmt.organization_id

Line 1211: mtl_material_transactions mmt1

1207: , nvl(mmt1.transfer_organization_id,-1) transfer_organization_id
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

Line 1275: mtl_material_transactions mmt1

1271: , nvl(mmt1.transfer_organization_id,-1) transfer_organization_id
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

Line 1326: mtl_material_transactions mmt2

1322: , nvl(mmt2.transfer_organization_id,-1) transfer_organization_id
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