Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.7K
|
hi experts SELECT porh.segment1, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' THEN prall.full_name END directman_pr,[QUOTE]to get the dept.head[/QUOTE] porh.description, porl.line_num, CASE WHEN popr.action_code = 'APPROVE' AND prall.full_name <> 'Sudheer T. Paraputhra' AND grdpr.short_name < 'PS-10' AND poph.action_code = 'SUBMIT' THEN TO_NUMBER ( …
|