VIEW: APPS.IGSBV_AS_DOCUMENT_DETAILS

Source

View Text - Preformatted

SELECT ITEM_NUMBER, ORDER_NUMBER, '_LA:DOCUMENT_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOCUMENT_TYPE:MEANING', '_LA:DOCUMENT_SUB_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOCUMENT_SUB_TYPE:MEANING', '_LA:ITEM_STATUS:IGS_LOOKUP_VALUES:IGS_AS_ITEM_STATUS:MEANING', DATE_PRODUCED, INCL_CURR_COURSE, NUM_OF_COPIES, COMMENTS, RECIP_PERS_NAME, RECIP_INST_NAME, RECIP_ADDR_LINE_1, RECIP_ADDR_LINE_2, RECIP_ADDR_LINE_3, RECIP_ADDR_LINE_4, RECIP_CITY, RECIP_POSTAL_CODE, RECIP_STATE, RECIP_PROVINCE, RECIP_COUNTY, RECIP_COUNTRY, RECIP_FAX_AREA_CODE, RECIP_FAX_COUNTRY_CODE, RECIP_FAX_NUMBER, PROGRAMS_ON_FILE, MISSING_ACAD_RECORD_DATA_IND, MISSING_ACADEMIC_RECORD_DATA, SEND_TRANSCRIPT_IMMEDIATELY, HOLD_RELEASE_OF_FINAL_GRADES, HOLD_DEGREE_EXPECTED, HOLD_FOR_GRADE_CHG, SPECIAL_INSTR, EXPRESS_MAIL_TYPE, EXPRESS_MAIL_TRACK_NUM, GE_CERTIFICATION, EXTERNAL_COMMENTS, INTERNAL_COMMENTS, DUP_REQUESTED, DUP_REQ_DATE, DUP_SENT_DATE, INCL_ATTEMPTED_HOURS, INCL_CLASS_RANK, INCL_PROGRESSSION_STATUS, INCL_CLASS_STANDING, INCL_CUM_HOURS_EARNED, INCL_GPA, INCL_DATE_OF_GRADUATION, INCL_DEGREE_DATES, INCL_DEGREE_EARNED, INCL_DATE_OF_ENTRY, INCL_DROP_WITHDRAWAL_DATES, INCL_HRS_EARNED_FOR_CURR_TERM, INCL_MAJORS, INCL_LAST_DATE_OF_ENROLLMENT, INCL_PROFESSIONAL_LICENSURE, INCL_COLLEGE_AFFILIATION, INCL_INSTRUCTION_DATES, INCL_USEC_DATES, INCL_PROGRAM_ATTEMPT, INCL_ATTENDENCE_TYPE, INCL_LAST_TERM_ENROLLED, INCL_SSN, INCL_DATE_OF_BIRTH, INCL_DISCIPLIN_STANDING, INCL_NO_FUTURE_TERM, INCL_ACURAT_TILL_COPMP_DT, INCL_CANT_REL_WITHOUT_SIGN, INCL_DEPARTMENT, INCL_FIELD_OF_STDY, INCL_ATTEND_MODE, INCL_YOP_ACAD_PRD, INCL_INTRMSN_ST_END, INCL_HNRS_LVL, INCL_AWARDS, INCL_AWARD_AIM, INCL_ACAD_SESSIONS, INCL_ST_END_ACAD_SES, INCL_HESA_NUM, INCL_LOCATION, INCL_PROGRAM_TYPE, INCL_PROGRAM_NAME, INCL_PROG_ATMPT_STAT, INCL_PROG_ATMPT_END, INCL_PROG_ATMPT_STRT, INCL_REQ_CMPLETE, INCL_EXPECTED_COMPL_DT, INCL_CONFERRAL_DT, INCL_THESIS_TITLE, INCL_PROGRAM_CODE, INCL_PROGRAM_VER, INCL_STUD_NO, INCL_SURNAME, INCL_FORE_NAME, INCL_PREV_NAMES, INCL_INITIALS, DOC_FEE_PER_COPY, DELIVERY_FEE, RECIP_EMAIL, OVERRIDDEN_DOC_DELIVERY_FEE, OVERRIDDEN_DOCUMENT_FEE, FEE_OVERRIDDEN_BY, FEE_OVERRIDDEN_DATE, DELIVERY_METHOD_TYPE, DOC_PURPOSE_CODE, FGRADE_CAL_TYPE, FGRADE_SEQ_NUM, DEGHOLD_CAL_TYPE, DEGHOLD_SEQ_NUM, ENR_TERM_CAL_TYPE, ENR_CI_SEQUENCE_NUMBER, PLAN_ID, PRODUCED_BY, PERSON_ID, RECIP_INST_CD, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS_AS_DOC_DETAILS WITH READ ONLY

View Text - HTML Formatted

SELECT ITEM_NUMBER
, ORDER_NUMBER
, '_LA:DOCUMENT_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOCUMENT_TYPE:MEANING'
, '_LA:DOCUMENT_SUB_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOCUMENT_SUB_TYPE:MEANING'
, '_LA:ITEM_STATUS:IGS_LOOKUP_VALUES:IGS_AS_ITEM_STATUS:MEANING'
, DATE_PRODUCED
, INCL_CURR_COURSE
, NUM_OF_COPIES
, COMMENTS
, RECIP_PERS_NAME
, RECIP_INST_NAME
, RECIP_ADDR_LINE_1
, RECIP_ADDR_LINE_2
, RECIP_ADDR_LINE_3
, RECIP_ADDR_LINE_4
, RECIP_CITY
, RECIP_POSTAL_CODE
, RECIP_STATE
, RECIP_PROVINCE
, RECIP_COUNTY
, RECIP_COUNTRY
, RECIP_FAX_AREA_CODE
, RECIP_FAX_COUNTRY_CODE
, RECIP_FAX_NUMBER
, PROGRAMS_ON_FILE
, MISSING_ACAD_RECORD_DATA_IND
, MISSING_ACADEMIC_RECORD_DATA
, SEND_TRANSCRIPT_IMMEDIATELY
, HOLD_RELEASE_OF_FINAL_GRADES
, HOLD_DEGREE_EXPECTED
, HOLD_FOR_GRADE_CHG
, SPECIAL_INSTR
, EXPRESS_MAIL_TYPE
, EXPRESS_MAIL_TRACK_NUM
, GE_CERTIFICATION
, EXTERNAL_COMMENTS
, INTERNAL_COMMENTS
, DUP_REQUESTED
, DUP_REQ_DATE
, DUP_SENT_DATE
, INCL_ATTEMPTED_HOURS
, INCL_CLASS_RANK
, INCL_PROGRESSSION_STATUS
, INCL_CLASS_STANDING
, INCL_CUM_HOURS_EARNED
, INCL_GPA
, INCL_DATE_OF_GRADUATION
, INCL_DEGREE_DATES
, INCL_DEGREE_EARNED
, INCL_DATE_OF_ENTRY
, INCL_DROP_WITHDRAWAL_DATES
, INCL_HRS_EARNED_FOR_CURR_TERM
, INCL_MAJORS
, INCL_LAST_DATE_OF_ENROLLMENT
, INCL_PROFESSIONAL_LICENSURE
, INCL_COLLEGE_AFFILIATION
, INCL_INSTRUCTION_DATES
, INCL_USEC_DATES
, INCL_PROGRAM_ATTEMPT
, INCL_ATTENDENCE_TYPE
, INCL_LAST_TERM_ENROLLED
, INCL_SSN
, INCL_DATE_OF_BIRTH
, INCL_DISCIPLIN_STANDING
, INCL_NO_FUTURE_TERM
, INCL_ACURAT_TILL_COPMP_DT
, INCL_CANT_REL_WITHOUT_SIGN
, INCL_DEPARTMENT
, INCL_FIELD_OF_STDY
, INCL_ATTEND_MODE
, INCL_YOP_ACAD_PRD
, INCL_INTRMSN_ST_END
, INCL_HNRS_LVL
, INCL_AWARDS
, INCL_AWARD_AIM
, INCL_ACAD_SESSIONS
, INCL_ST_END_ACAD_SES
, INCL_HESA_NUM
, INCL_LOCATION
, INCL_PROGRAM_TYPE
, INCL_PROGRAM_NAME
, INCL_PROG_ATMPT_STAT
, INCL_PROG_ATMPT_END
, INCL_PROG_ATMPT_STRT
, INCL_REQ_CMPLETE
, INCL_EXPECTED_COMPL_DT
, INCL_CONFERRAL_DT
, INCL_THESIS_TITLE
, INCL_PROGRAM_CODE
, INCL_PROGRAM_VER
, INCL_STUD_NO
, INCL_SURNAME
, INCL_FORE_NAME
, INCL_PREV_NAMES
, INCL_INITIALS
, DOC_FEE_PER_COPY
, DELIVERY_FEE
, RECIP_EMAIL
, OVERRIDDEN_DOC_DELIVERY_FEE
, OVERRIDDEN_DOCUMENT_FEE
, FEE_OVERRIDDEN_BY
, FEE_OVERRIDDEN_DATE
, DELIVERY_METHOD_TYPE
, DOC_PURPOSE_CODE
, FGRADE_CAL_TYPE
, FGRADE_SEQ_NUM
, DEGHOLD_CAL_TYPE
, DEGHOLD_SEQ_NUM
, ENR_TERM_CAL_TYPE
, ENR_CI_SEQUENCE_NUMBER
, PLAN_ID
, PRODUCED_BY
, PERSON_ID
, RECIP_INST_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_AS_DOC_DETAILS WITH READ ONLY