Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Person.FIRST_NAME,
- Person.LAST_NAME,
- Person.PERSON_ID,
- Person.COMPANY_NR,
- VoPersonCategory.NAME CAT_NAME
- FROM V_UPDATABLE_PERSON Person, GU_PERSON GuPerson, V_UPDATABLE_VO_PERSON_CATEGORY VoPersonCategory, PERSON_ROLE PersonRole, VO_ROLE VoRole, ROLE Role
- WHERE GuPerson.PERSON_ID = Person.PERSON_ID
- AND Person.VO_PERSON_CATEGORY_ID = VoPersonCategory.VO_PERSON_CATEGORY_ID
- AND GuPerson.GUI_USER_ID = 144151
- AND person.person_status_id = 0
- AND Person.PERSON_ID = PersonRole.PERSON_ID
- AND PersonRole.VO_ROLE_ID = VoRole.VO_ROLE_ID
- AND VoRole.ROLE_ID = Role.ROLE_ID
- AND Role.VALIDATION_STATUS_ID >= 81
- GROUP BY Person.FIRST_NAME,Person.LAST_NAME,Person.PERSON_ID, Person.COMPANY_NR,VoPersonCategory.NAME
- ORDER BY Person.LAST_NAME,Person.FIRST_NAME;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement