>Similar to crsMLE with additional fields which are not necessary for my original question.

OK! Once again, from THAT data:

* For crsMLE
>PartNum QtyPer TotalOnHand QtyRequired NetQty CurQty
>100000    2        100          20        80    10
>100001    1        100          10        90    10
>100002    3        100          30        70    10

* For crsCNT
>PartNum CurQty PartDesc
>102031    10   Assembly 101
>100001    10   Assembly 102
>100002    10   Assembly 103

* For crsPM2
PartNum PartDesc ....
100000  Part A
100001  Part B
100002  Part C

After SELECT WHAT cursor you want to get?
Similar to crsMLE is just:
SELECT ( field list here ) from crsMLE isn't it?