VIEW: APPS.IGS_AS_ORD_ITM_INT_V

Source

View Text - Preformatted

SELECT INT.ROWID, INT.order_number, INT.person_id, INT.document_type, INT.document_sub_type, INT.item_number, INT.item_status, INT.date_produced, INT.num_of_copies, INT.programs_on_file, INT.comments, INT.recip_pers_name, INT.recip_inst_name, INT.recip_addr_line_1, INT.recip_addr_line_2, INT.recip_addr_line_3, INT.recip_addr_line_4, INT.recip_city, INT.recip_postal_code, INT.recip_state, INT.recip_province, INT.recip_county, INT.recip_country, INT.recip_fax_area_code, INT.recip_fax_country_code, INT.recip_fax_number, INT.delivery_method_type, INT.dup_requested, INT.dup_req_date, INT.dup_sent_date, INT.fgrade_cal_type, INT.fgrade_seq_num, INT.deghold_cal_type, INT.deghold_seq_num, INT.hold_for_grade_chg, INT.hold_degree_expected, INT.hold_release_of_final_grades, INT.incl_curr_course, INT.missing_acad_record_data_ind, INT.missing_academic_record_data, INT.send_transcript_immediately, INT.special_instr, INT.express_mail_type, INT.express_mail_track_num, INT.ge_certification, INT.external_comments, INT.internal_comments, INT.enr_term_cal_type, INT.enr_ci_sequence_number, INT.incl_attempted_hours, INT.incl_class_rank, INT.incl_progresssion_status, INT.incl_class_standing, INT.incl_cum_hours_earned, INT.incl_gpa, INT.incl_date_of_graduation, INT.incl_degree_dates, INT.incl_degree_earned, INT.incl_date_of_entry, INT.incl_drop_withdrawal_dates, INT.incl_hrs_earned_for_curr_term, INT.incl_majors, INT.incl_last_date_of_enrollment, INT.incl_professional_licensure, INT.incl_college_affiliation, INT.incl_instruction_dates, INT.incl_usec_dates, INT.incl_program_attempt, INT.incl_attendence_type, INT.incl_last_term_enrolled, INT.incl_ssn, INT.incl_date_of_birth, INT.incl_disciplin_standing, INT.incl_no_future_term, INT.incl_acurat_till_copmp_dt, INT.incl_cant_rel_without_sign, INT.created_by, INT.creation_date, INT.last_updated_by, INT.last_update_date, INT.last_update_login, INT.request_id, INT.program_application_id, INT.program_id, INT.program_update_date, INT.recip_inst_cd, INT.recip_email, RANK () OVER (PARTITION BY INT.order_number ORDER BY INT.item_number) display_item_number FROM igs_as_ord_itm_int INT

View Text - HTML Formatted

SELECT INT.ROWID
, INT.ORDER_NUMBER
, INT.PERSON_ID
, INT.DOCUMENT_TYPE
, INT.DOCUMENT_SUB_TYPE
, INT.ITEM_NUMBER
, INT.ITEM_STATUS
, INT.DATE_PRODUCED
, INT.NUM_OF_COPIES
, INT.PROGRAMS_ON_FILE
, INT.COMMENTS
, INT.RECIP_PERS_NAME
, INT.RECIP_INST_NAME
, INT.RECIP_ADDR_LINE_1
, INT.RECIP_ADDR_LINE_2
, INT.RECIP_ADDR_LINE_3
, INT.RECIP_ADDR_LINE_4
, INT.RECIP_CITY
, INT.RECIP_POSTAL_CODE
, INT.RECIP_STATE
, INT.RECIP_PROVINCE
, INT.RECIP_COUNTY
, INT.RECIP_COUNTRY
, INT.RECIP_FAX_AREA_CODE
, INT.RECIP_FAX_COUNTRY_CODE
, INT.RECIP_FAX_NUMBER
, INT.DELIVERY_METHOD_TYPE
, INT.DUP_REQUESTED
, INT.DUP_REQ_DATE
, INT.DUP_SENT_DATE
, INT.FGRADE_CAL_TYPE
, INT.FGRADE_SEQ_NUM
, INT.DEGHOLD_CAL_TYPE
, INT.DEGHOLD_SEQ_NUM
, INT.HOLD_FOR_GRADE_CHG
, INT.HOLD_DEGREE_EXPECTED
, INT.HOLD_RELEASE_OF_FINAL_GRADES
, INT.INCL_CURR_COURSE
, INT.MISSING_ACAD_RECORD_DATA_IND
, INT.MISSING_ACADEMIC_RECORD_DATA
, INT.SEND_TRANSCRIPT_IMMEDIATELY
, INT.SPECIAL_INSTR
, INT.EXPRESS_MAIL_TYPE
, INT.EXPRESS_MAIL_TRACK_NUM
, INT.GE_CERTIFICATION
, INT.EXTERNAL_COMMENTS
, INT.INTERNAL_COMMENTS
, INT.ENR_TERM_CAL_TYPE
, INT.ENR_CI_SEQUENCE_NUMBER
, INT.INCL_ATTEMPTED_HOURS
, INT.INCL_CLASS_RANK
, INT.INCL_PROGRESSSION_STATUS
, INT.INCL_CLASS_STANDING
, INT.INCL_CUM_HOURS_EARNED
, INT.INCL_GPA
, INT.INCL_DATE_OF_GRADUATION
, INT.INCL_DEGREE_DATES
, INT.INCL_DEGREE_EARNED
, INT.INCL_DATE_OF_ENTRY
, INT.INCL_DROP_WITHDRAWAL_DATES
, INT.INCL_HRS_EARNED_FOR_CURR_TERM
, INT.INCL_MAJORS
, INT.INCL_LAST_DATE_OF_ENROLLMENT
, INT.INCL_PROFESSIONAL_LICENSURE
, INT.INCL_COLLEGE_AFFILIATION
, INT.INCL_INSTRUCTION_DATES
, INT.INCL_USEC_DATES
, INT.INCL_PROGRAM_ATTEMPT
, INT.INCL_ATTENDENCE_TYPE
, INT.INCL_LAST_TERM_ENROLLED
, INT.INCL_SSN
, INT.INCL_DATE_OF_BIRTH
, INT.INCL_DISCIPLIN_STANDING
, INT.INCL_NO_FUTURE_TERM
, INT.INCL_ACURAT_TILL_COPMP_DT
, INT.INCL_CANT_REL_WITHOUT_SIGN
, INT.CREATED_BY
, INT.CREATION_DATE
, INT.LAST_UPDATED_BY
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATE_LOGIN
, INT.REQUEST_ID
, INT.PROGRAM_APPLICATION_ID
, INT.PROGRAM_ID
, INT.PROGRAM_UPDATE_DATE
, INT.RECIP_INST_CD
, INT.RECIP_EMAIL
, RANK () OVER (PARTITION BY INT.ORDER_NUMBER ORDER BY INT.ITEM_NUMBER) DISPLAY_ITEM_NUMBER
FROM IGS_AS_ORD_ITM_INT INT