149:
150: -- Get sub inventory type
151: CURSOR cur_asset_inventory(cp_rcv_transaction_id NUMBER ) IS
152: SELECT asset_inventory
153: FROM mtl_secondary_inventories subinv,
154: mtl_material_transactions mmt,
155: rcv_transactions rt
156: WHERE subinv.secondary_inventory_name = mmt.subinventory_code
157: AND subinv.organization_id = mmt.organization_id