APPS.CSE_ASSET_UTIL_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 237: mtl_material_transactions mmt,

233: DEBUG('inside '|| l_api_name || 'Get INV OU context');
234: SELECT ood.operating_unit
235: INTO l_txn_ou_context
236: FROM org_organization_definitions ood,
237: mtl_material_transactions mmt,
238: csi_inst_txn_details_v citdv
239: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
240: AND citdv.inv_material_transaction_id = mmt.transaction_id
241: AND mmt.organization_id = ood.organization_id

Line 502: mtl_material_transactions mmt

498: citdv.inv_organization_id,
499: mmt.primary_quantity
500: FROM csi_inst_txn_details_v citdv,
501: csi_i_assets cia,
502: mtl_material_transactions mmt
503: WHERE citdv.source_header_ref_id=l_wip_entity_id
504: AND cia.instance_id=citdv.instance_id
505: AND citdv.inv_material_transaction_id=mmt.transaction_id ;
506:

Line 992: FROM mtl_material_transactions mmt,

988: SELECT nvl(msi.inventory_asset_flag, 'N'),
989: mmt.organization_id
990: INTO l_inventory_asset_flag,
991: l_organization_id
992: FROM mtl_material_transactions mmt,
993: mtl_system_items msi
994: WHERE mmt.transaction_id = l_mtl_txn_id
995: AND msi.inventory_item_id = mmt.inventory_item_id
996: AND msi.organization_id = mmt.organization_id;

Line 1494: FROM mtl_material_transactions mmt

1490:
1491:
1492: CURSOR item_qty_cur(c_mmt_id IN NUMBER, c_inv_id IN NUMBER) IS
1493: SELECT mmt.primary_quantity
1494: FROM mtl_material_transactions mmt
1495: WHERE mmt.transaction_id = c_mmt_id
1496: AND mmt.inventory_item_id = c_inv_id ;
1497:
1498: CURSOR csi_sub_type_cur (c_transaction_id IN NUMBER) IS