VIEW: HR.PER_ASSIGNMENT_LIST#

Source

View Text - Preformatted

select USER_ID USER_ID, SECURITY_PROFILE_ID SECURITY_PROFILE_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PERSON_ID PERSON_ID, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "HR"."PER_ASSIGNMENT_LIST"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, SECURITY_PROFILE_ID SECURITY_PROFILE_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PERSON_ID PERSON_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "HR"."PER_ASSIGNMENT_LIST"