VIEW: APPS.IGS_AS_SUA_SES_ATTS_V

Source

View Text - Preformatted

SELECT atts.ROWID ROW_ID, atts.PERSON_ID Person_Id, hz.PARTY_NUMBER Person_Number, hz.PARTY_NAME Person_Name, atts.COURSE_CD Program_cd , atts.UOO_ID uoo_id , atts.SESSION_NAME Session_Name , sessns.SESSION_DESCRIPTION Session_Description, sessns.SESSION_START_DATE_TIME Start_Date, sessns.SESSION_END_DATE_TIME End_Date, DECODE( sessns.UNIT_SECTION_OCCURRENCE_ID, NULL, NULL,igs_as_gen_008.Get_Occur_details (atts.UOO_ID,sessns.UNIT_SECTION_OCCURRENCE_ID)) OCCURENCE_DESC, atts.ATTENDANCE_FLAG Attendance_Flag, atts.CREATED_BY Created_By, atts.CREATION_DATE Creation_Date, atts.LAST_UPDATED_BY Last_Updated_By , atts.LAST_UPDATE_DATE Last_Update_Date , atts.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AS_SUA_SES_ATTS atts, IGS_AS_USEC_SESSNS sessns, hz_parties hz WHERE atts.session_name = sessns.session_name AND atts.uoo_id = sessns.uoo_id AND atts.person_id = hz.party_id

View Text - HTML Formatted

SELECT ATTS.ROWID ROW_ID
, ATTS.PERSON_ID PERSON_ID
, HZ.PARTY_NUMBER PERSON_NUMBER
, HZ.PARTY_NAME PERSON_NAME
, ATTS.COURSE_CD PROGRAM_CD
, ATTS.UOO_ID UOO_ID
, ATTS.SESSION_NAME SESSION_NAME
, SESSNS.SESSION_DESCRIPTION SESSION_DESCRIPTION
, SESSNS.SESSION_START_DATE_TIME START_DATE
, SESSNS.SESSION_END_DATE_TIME END_DATE
, DECODE( SESSNS.UNIT_SECTION_OCCURRENCE_ID
, NULL
, NULL
, IGS_AS_GEN_008.GET_OCCUR_DETAILS (ATTS.UOO_ID
, SESSNS.UNIT_SECTION_OCCURRENCE_ID)) OCCURENCE_DESC
, ATTS.ATTENDANCE_FLAG ATTENDANCE_FLAG
, ATTS.CREATED_BY CREATED_BY
, ATTS.CREATION_DATE CREATION_DATE
, ATTS.LAST_UPDATED_BY LAST_UPDATED_BY
, ATTS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ATTS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AS_SUA_SES_ATTS ATTS
, IGS_AS_USEC_SESSNS SESSNS
, HZ_PARTIES HZ
WHERE ATTS.SESSION_NAME = SESSNS.SESSION_NAME
AND ATTS.UOO_ID = SESSNS.UOO_ID
AND ATTS.PERSON_ID = HZ.PARTY_ID