APPS.OPI_EDW_IDS_CALC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 974: from mtl_material_transactions

970: -- no cost in the CST_STANDARD_COST table.
971: CURSOR new_item_cost_csr (org_id NUMBER, item_id NUMBER,p_cost_date DATE)
972: IS
973: select actual_cost
974: from mtl_material_transactions
975: where transaction_id = (
976: select max(transaction_id)
977: from mtl_material_transactions
978: where inventory_item_id=item_id

Line 977: from mtl_material_transactions

973: select actual_cost
974: from mtl_material_transactions
975: where transaction_id = (
976: select max(transaction_id)
977: from mtl_material_transactions
978: where inventory_item_id=item_id
979: and organization_id=org_id
980: and actual_cost is not null
981: and transaction_date =

Line 983: from mtl_material_transactions

979: and organization_id=org_id
980: and actual_cost is not null
981: and transaction_date =
982: (select max(transaction_date)
983: from mtl_material_transactions
984: where inventory_item_id=item_id
985: and organization_id=org_id
986: and trunc(transaction_date) <= p_cost_date
987: and actual_cost is not null));

Line 1132: -- registered cost update transaction in the mtl_material_transactions

1128: PRIMARY_COST_METHOD_UPDATE CONSTANT NUMBER := 1;
1129:
1130:
1131: -- cursor for all the distinct item-org combinations that have a
1132: -- registered cost update transaction in the mtl_material_transactions
1133: -- within the specified period dates (inclusive).
1134: -- We need to know the item id, the organization id, the transaction
1135: -- date.
1136: --

Line 1145: FROM mtl_material_transactions mmt, mtl_parameters mp,

1141: p_organization_id NUMBER)
1142: IS
1143: SELECT DISTINCT mmt.inventory_item_id inventory_item_id,
1144: mmt.transaction_date transaction_date
1145: FROM mtl_material_transactions mmt, mtl_parameters mp,
1146: mtl_system_items_b msi
1147: WHERE mmt.transaction_type_id = 24
1148: AND mmt.transaction_date BETWEEN p_from_date AND p_to_date
1149: AND mmt.organization_id = p_organization_id