View: IGS_AS_DOC_DETAILS_V

View Text

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

Columns