on 12-21-2014 12:23 PM
Dear Team.
My requirement is to segregate maintenance orders for a particular plan based on system called and manual called orders thorough tables and need to print the same in permit print. I have checked all the tables but not found the required one. Can any one guide me that in which table i can check the difference of two?
Regards,
Bhanu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Bhanu,
Table MHIS
Manual calls are bearing the Call numbers >= 90,000,000, whereas Scheduled calls are having Call numbers 1,2,3 and so on. So query the MHIS table like in picture1 below for Manual calls and like in picture2 for scheduled calls. (ABNUM is for call number).
Picture1 (Gives you Manual Calls)
Picture2 (Gives you Scheduled Calls)
Also see the my reply in this similar discussion
KJogeswaraRao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.