VIEW: APPS.IGS_AS_DOC_DETAILS_V

Source

View Text - Preformatted

SELECT dtl.ROWID, dtl.plan_id, NVL (dtl.overridden_doc_delivery_fee, dtl.delivery_fee), NVL (dtl.overridden_document_fee, dtl.doc_fee_per_copy), dtl.delivery_fee, dtl.doc_fee_per_copy, dtl.overridden_doc_delivery_fee, dtl.overridden_document_fee, dtl.fee_overridden_by, dtl.fee_overridden_date, dtl.doc_purpose_code, dtl.incl_department, dtl.incl_field_of_stdy, dtl.incl_attend_mode, dtl.incl_yop_acad_prd, dtl.incl_intrmsn_st_end, dtl.incl_hnrs_lvl, dtl.incl_awards, dtl.incl_award_aim, dtl.incl_acad_sessions, dtl.incl_st_end_acad_ses, dtl.incl_hesa_num, dtl.incl_location, dtl.incl_program_type, dtl.incl_program_name, dtl.incl_prog_atmpt_stat, dtl.incl_prog_atmpt_end, dtl.incl_prog_atmpt_strt, dtl.incl_req_cmplete, dtl.incl_expected_compl_dt, dtl.incl_conferral_dt, dtl.incl_thesis_title, dtl.incl_program_code, dtl.incl_program_ver, dtl.incl_stud_no, dtl.incl_surname, dtl.incl_fore_name, dtl.incl_prev_names, dtl.incl_initials, dtl.order_number, dtl.document_type, dtl.document_sub_type, dtl.item_number, dtl.item_status, dtl.date_produced, dtl.incl_curr_course, dtl.num_of_copies, dtl.comments, dtl.recip_pers_name, dtl.recip_inst_cd, dtl.recip_inst_name, dtl.recip_addr_line_1, dtl.recip_addr_line_2, dtl.recip_addr_line_3, dtl.recip_addr_line_4, dtl.recip_city, dtl.recip_postal_code, dtl.recip_state, dtl.recip_province, dtl.recip_county, dtl.recip_country, dtl.recip_fax_area_code, dtl.recip_fax_country_code, dtl.recip_fax_number, dtl.delivery_method_type, dtl.programs_on_file, dtl.missing_acad_record_data_ind, dtl.missing_academic_record_data, dtl.send_transcript_immediately, dtl.hold_release_of_final_grades, dtl.fgrade_cal_type, dtl.fgrade_seq_num, dtl.hold_degree_expected, dtl.deghold_cal_type, dtl.deghold_seq_num, dtl.hold_for_grade_chg, dtl.special_instr, dtl.express_mail_type, dtl.express_mail_track_num, dtl.ge_certification, dtl.external_comments, dtl.internal_comments, dtl.dup_requested, dtl.dup_req_date, dtl.dup_sent_date, dtl.enr_term_cal_type, dtl.enr_ci_sequence_number, dtl.incl_attempted_hours, dtl.incl_class_rank, dtl.incl_progresssion_status, dtl.incl_class_standing, dtl.incl_cum_hours_earned, dtl.incl_gpa, dtl.incl_date_of_graduation, dtl.incl_degree_dates, dtl.incl_degree_earned, dtl.incl_date_of_entry, dtl.incl_drop_withdrawal_dates, dtl.incl_hrs_earned_for_curr_term, dtl.incl_majors, dtl.incl_last_date_of_enrollment, dtl.incl_professional_licensure, dtl.incl_college_affiliation, dtl.incl_instruction_dates, dtl.incl_usec_dates, dtl.incl_program_attempt, dtl.incl_attendence_type, dtl.incl_last_term_enrolled, dtl.incl_ssn, dtl.incl_date_of_birth, dtl.incl_disciplin_standing, dtl.incl_no_future_term, dtl.incl_acurat_till_copmp_dt, dtl.incl_cant_rel_without_sign, dtl.created_by, dtl.creation_date, dtl.last_updated_by, dtl.last_update_date, dtl.last_update_login, dtl.request_id, dtl.program_application_id, dtl.program_id, dtl.program_update_date, dtyp.description, l3.meaning, l2.meaning, ci1.description, ci2.description, ci3.description, dtl.person_id, tr.territory_short_name, l4.meaning, dtl.recip_email, dtl.produced_by, hz.party_name FROM igs_as_doc_details dtl, igs_as_doc_dlvy_typ dtyp, fnd_lookup_values l2, fnd_lookup_values l3, fnd_lookup_values l4, igs_ca_inst_all ci1, igs_ca_inst_all ci2, igs_ca_inst_all ci3, igs_as_doc_dlvy_fee dlv, fnd_territories_tl tr, hz_parties hz WHERE dtl.delivery_method_type = dtyp.delivery_method_type AND dtl.document_sub_type = l2.lookup_code AND l2.lookup_type = 'IGS_AS_DOCUMENT_SUB_TYPE' AND dtl.document_type = l3.lookup_code AND l3.lookup_type = 'IGS_AS_DOCUMENT_TYPE' AND dtl.item_status = l4.lookup_code(+) AND l4.lookup_type(+) = 'IGS_AS_ITEM_STATUS' AND dtl.fgrade_cal_type = ci1.cal_type(+) AND dtl.fgrade_seq_num = ci1.sequence_number(+) AND dtl.deghold_cal_type = ci2.cal_type(+) AND dtl.deghold_seq_num = ci2.sequence_number(+) AND dtl.enr_term_cal_type = ci3.cal_type(+) AND dtl.enr_ci_sequence_number = ci3.sequence_number(+) AND dtl.delivery_method_type = dlv.delivery_method_type(+) AND dtl.recip_country = tr.territory_code(+) AND hz.party_id(+) = dtl.produced_by AND tr.LANGUAGE(+) = USERENV ('LANG') AND l2.LANGUAGE = USERENV ('LANG') AND l2.view_application_id = 8405 AND l2.security_group_id = 0 AND l3.LANGUAGE = USERENV ('LANG') AND l3.view_application_id = 8405 AND l3.security_group_id = 0 AND l4.LANGUAGE = USERENV ('LANG') AND l4.view_application_id = 8405 AND l4.security_group_id = 0

View Text - HTML Formatted

SELECT DTL.ROWID
, DTL.PLAN_ID
, NVL (DTL.OVERRIDDEN_DOC_DELIVERY_FEE
, DTL.DELIVERY_FEE)
, NVL (DTL.OVERRIDDEN_DOCUMENT_FEE
, DTL.DOC_FEE_PER_COPY)
, DTL.DELIVERY_FEE
, DTL.DOC_FEE_PER_COPY
, DTL.OVERRIDDEN_DOC_DELIVERY_FEE
, DTL.OVERRIDDEN_DOCUMENT_FEE
, DTL.FEE_OVERRIDDEN_BY
, DTL.FEE_OVERRIDDEN_DATE
, DTL.DOC_PURPOSE_CODE
, DTL.INCL_DEPARTMENT
, DTL.INCL_FIELD_OF_STDY
, DTL.INCL_ATTEND_MODE
, DTL.INCL_YOP_ACAD_PRD
, DTL.INCL_INTRMSN_ST_END
, DTL.INCL_HNRS_LVL
, DTL.INCL_AWARDS
, DTL.INCL_AWARD_AIM
, DTL.INCL_ACAD_SESSIONS
, DTL.INCL_ST_END_ACAD_SES
, DTL.INCL_HESA_NUM
, DTL.INCL_LOCATION
, DTL.INCL_PROGRAM_TYPE
, DTL.INCL_PROGRAM_NAME
, DTL.INCL_PROG_ATMPT_STAT
, DTL.INCL_PROG_ATMPT_END
, DTL.INCL_PROG_ATMPT_STRT
, DTL.INCL_REQ_CMPLETE
, DTL.INCL_EXPECTED_COMPL_DT
, DTL.INCL_CONFERRAL_DT
, DTL.INCL_THESIS_TITLE
, DTL.INCL_PROGRAM_CODE
, DTL.INCL_PROGRAM_VER
, DTL.INCL_STUD_NO
, DTL.INCL_SURNAME
, DTL.INCL_FORE_NAME
, DTL.INCL_PREV_NAMES
, DTL.INCL_INITIALS
, DTL.ORDER_NUMBER
, DTL.DOCUMENT_TYPE
, DTL.DOCUMENT_SUB_TYPE
, DTL.ITEM_NUMBER
, DTL.ITEM_STATUS
, DTL.DATE_PRODUCED
, DTL.INCL_CURR_COURSE
, DTL.NUM_OF_COPIES
, DTL.COMMENTS
, DTL.RECIP_PERS_NAME
, DTL.RECIP_INST_CD
, DTL.RECIP_INST_NAME
, DTL.RECIP_ADDR_LINE_1
, DTL.RECIP_ADDR_LINE_2
, DTL.RECIP_ADDR_LINE_3
, DTL.RECIP_ADDR_LINE_4
, DTL.RECIP_CITY
, DTL.RECIP_POSTAL_CODE
, DTL.RECIP_STATE
, DTL.RECIP_PROVINCE
, DTL.RECIP_COUNTY
, DTL.RECIP_COUNTRY
, DTL.RECIP_FAX_AREA_CODE
, DTL.RECIP_FAX_COUNTRY_CODE
, DTL.RECIP_FAX_NUMBER
, DTL.DELIVERY_METHOD_TYPE
, DTL.PROGRAMS_ON_FILE
, DTL.MISSING_ACAD_RECORD_DATA_IND
, DTL.MISSING_ACADEMIC_RECORD_DATA
, DTL.SEND_TRANSCRIPT_IMMEDIATELY
, DTL.HOLD_RELEASE_OF_FINAL_GRADES
, DTL.FGRADE_CAL_TYPE
, DTL.FGRADE_SEQ_NUM
, DTL.HOLD_DEGREE_EXPECTED
, DTL.DEGHOLD_CAL_TYPE
, DTL.DEGHOLD_SEQ_NUM
, DTL.HOLD_FOR_GRADE_CHG
, DTL.SPECIAL_INSTR
, DTL.EXPRESS_MAIL_TYPE
, DTL.EXPRESS_MAIL_TRACK_NUM
, DTL.GE_CERTIFICATION
, DTL.EXTERNAL_COMMENTS
, DTL.INTERNAL_COMMENTS
, DTL.DUP_REQUESTED
, DTL.DUP_REQ_DATE
, DTL.DUP_SENT_DATE
, DTL.ENR_TERM_CAL_TYPE
, DTL.ENR_CI_SEQUENCE_NUMBER
, DTL.INCL_ATTEMPTED_HOURS
, DTL.INCL_CLASS_RANK
, DTL.INCL_PROGRESSSION_STATUS
, DTL.INCL_CLASS_STANDING
, DTL.INCL_CUM_HOURS_EARNED
, DTL.INCL_GPA
, DTL.INCL_DATE_OF_GRADUATION
, DTL.INCL_DEGREE_DATES
, DTL.INCL_DEGREE_EARNED
, DTL.INCL_DATE_OF_ENTRY
, DTL.INCL_DROP_WITHDRAWAL_DATES
, DTL.INCL_HRS_EARNED_FOR_CURR_TERM
, DTL.INCL_MAJORS
, DTL.INCL_LAST_DATE_OF_ENROLLMENT
, DTL.INCL_PROFESSIONAL_LICENSURE
, DTL.INCL_COLLEGE_AFFILIATION
, DTL.INCL_INSTRUCTION_DATES
, DTL.INCL_USEC_DATES
, DTL.INCL_PROGRAM_ATTEMPT
, DTL.INCL_ATTENDENCE_TYPE
, DTL.INCL_LAST_TERM_ENROLLED
, DTL.INCL_SSN
, DTL.INCL_DATE_OF_BIRTH
, DTL.INCL_DISCIPLIN_STANDING
, DTL.INCL_NO_FUTURE_TERM
, DTL.INCL_ACURAT_TILL_COPMP_DT
, DTL.INCL_CANT_REL_WITHOUT_SIGN
, DTL.CREATED_BY
, DTL.CREATION_DATE
, DTL.LAST_UPDATED_BY
, DTL.LAST_UPDATE_DATE
, DTL.LAST_UPDATE_LOGIN
, DTL.REQUEST_ID
, DTL.PROGRAM_APPLICATION_ID
, DTL.PROGRAM_ID
, DTL.PROGRAM_UPDATE_DATE
, DTYP.DESCRIPTION
, L3.MEANING
, L2.MEANING
, CI1.DESCRIPTION
, CI2.DESCRIPTION
, CI3.DESCRIPTION
, DTL.PERSON_ID
, TR.TERRITORY_SHORT_NAME
, L4.MEANING
, DTL.RECIP_EMAIL
, DTL.PRODUCED_BY
, HZ.PARTY_NAME
FROM IGS_AS_DOC_DETAILS DTL
, IGS_AS_DOC_DLVY_TYP DTYP
, FND_LOOKUP_VALUES L2
, FND_LOOKUP_VALUES L3
, FND_LOOKUP_VALUES L4
, IGS_CA_INST_ALL CI1
, IGS_CA_INST_ALL CI2
, IGS_CA_INST_ALL CI3
, IGS_AS_DOC_DLVY_FEE DLV
, FND_TERRITORIES_TL TR
, HZ_PARTIES HZ
WHERE DTL.DELIVERY_METHOD_TYPE = DTYP.DELIVERY_METHOD_TYPE
AND DTL.DOCUMENT_SUB_TYPE = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'IGS_AS_DOCUMENT_SUB_TYPE'
AND DTL.DOCUMENT_TYPE = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'IGS_AS_DOCUMENT_TYPE'
AND DTL.ITEM_STATUS = L4.LOOKUP_CODE(+)
AND L4.LOOKUP_TYPE(+) = 'IGS_AS_ITEM_STATUS'
AND DTL.FGRADE_CAL_TYPE = CI1.CAL_TYPE(+)
AND DTL.FGRADE_SEQ_NUM = CI1.SEQUENCE_NUMBER(+)
AND DTL.DEGHOLD_CAL_TYPE = CI2.CAL_TYPE(+)
AND DTL.DEGHOLD_SEQ_NUM = CI2.SEQUENCE_NUMBER(+)
AND DTL.ENR_TERM_CAL_TYPE = CI3.CAL_TYPE(+)
AND DTL.ENR_CI_SEQUENCE_NUMBER = CI3.SEQUENCE_NUMBER(+)
AND DTL.DELIVERY_METHOD_TYPE = DLV.DELIVERY_METHOD_TYPE(+)
AND DTL.RECIP_COUNTRY = TR.TERRITORY_CODE(+)
AND HZ.PARTY_ID(+) = DTL.PRODUCED_BY
AND TR.LANGUAGE(+) = USERENV ('LANG')
AND L2.LANGUAGE = USERENV ('LANG')
AND L2.VIEW_APPLICATION_ID = 8405
AND L2.SECURITY_GROUP_ID = 0
AND L3.LANGUAGE = USERENV ('LANG')
AND L3.VIEW_APPLICATION_ID = 8405
AND L3.SECURITY_GROUP_ID = 0
AND L4.LANGUAGE = USERENV ('LANG')
AND L4.VIEW_APPLICATION_ID = 8405
AND L4.SECURITY_GROUP_ID = 0