VIEW: APPS.IGF_SL_COD_REP_V

Source

View Text - Preformatted

SELECT REP_ENTITY_ID_TXT, ATD_ENTITY_ID_TXT, AWARD_ID, BASE_ID, SOURCE_ENTITY_ID_TXT, DOCUMENT_ID_TXT, LOAN_KEY_NUM, INTEREST_REBATE_PERCENT_NUM, FIN_AWARD_YEAR, CPS_TRANS_NUM, NOTE_MESSAGE, FULL_RESP_CODE, ORIGINATION_ID, LOAN_NUMBER LOAN_NUMBER_TXT, SUBSTR(LOAN_NUMBER,LENGTH(LOAN_NUMBER)-2,LENGTH(LOAN_NUMBER)) FIN_AWD_NUM, LOAN_TYPE, LOAN_AMT_ACCEPTED, TO_CHAR(LOAN_PER_BEGIN_DATE,'YYYY-MM-DD') LOAN_PER_BEGIN_DATE, TO_CHAR(LOAN_PER_END_DATE,'YYYY-MM-DD') LOAN_PER_END_DATE , TO_CHAR(ACAD_YR_BEGIN_DATE,'YYYY-MM-DD') ACAD_YR_BEGIN_DATE, TO_CHAR(ACAD_YR_END_DATE,'YYYY-MM-DD') ACAD_YR_END_DATE , TO_CHAR(ORIG_BATCH_DATE,'YYYY-MM-DD') ORIG_BATCH_DATE, PNOTE_PRINT_IND, S_DEPNCY_STATUS, S_DEFAULT_STATUS, UNSUB_ELIG_FOR_HEAL, DISCLOSURE_PRINT_IND , UNSUB_ELIG_FOR_DEPNT, ORIG_FEE_PERCT, LOAN_STATUS , LOAN_CHG_STATUS, GRADE_LEVEL_CODE, P_SSN , P_LAST_NAME, P_FIRST_NAME, SUBSTR(TRIM(P_MIDDLE_NAME),1,1) P_MIDDLE_INITIAL, TO_CHAR(B_CHG_BIRTH_DATE,'YYYY-MM-DD') B_CHG_BIRTH_DATE, B_CHG_SSN, B_CHG_LAST_NAME, P_PERMT_ADDR1, P_PERMT_ADDR2, P_PERMT_CITY, P_PERMT_STATE, P_PERMT_ZIP , P_PERMT_PHONE, P_EMAIL_ADDR , TO_CHAR(P_DATE_OF_BIRTH,'YYYY-MM-DD') P_DATE_OF_BIRTH, P_LICENSE_NUM , P_LICENSE_STATE, P_CITIZENSHIP_STATUS, P_ALIEN_REG_NUM , P_DEFAULT_STATUS, B_PERMT_COUNTRY, B_PERMT_COUNTY, P_FOREIGN_POSTAL_CODE, P_STATE_OF_LEGAL_RES FROM IGF_SL_LOR_LOC_ALL

View Text - HTML Formatted

SELECT REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, AWARD_ID
, BASE_ID
, SOURCE_ENTITY_ID_TXT
, DOCUMENT_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, NOTE_MESSAGE
, FULL_RESP_CODE
, ORIGINATION_ID
, LOAN_NUMBER LOAN_NUMBER_TXT
, SUBSTR(LOAN_NUMBER
, LENGTH(LOAN_NUMBER)-2
, LENGTH(LOAN_NUMBER)) FIN_AWD_NUM
, LOAN_TYPE
, LOAN_AMT_ACCEPTED
, TO_CHAR(LOAN_PER_BEGIN_DATE
, 'YYYY-MM-DD') LOAN_PER_BEGIN_DATE
, TO_CHAR(LOAN_PER_END_DATE
, 'YYYY-MM-DD') LOAN_PER_END_DATE
, TO_CHAR(ACAD_YR_BEGIN_DATE
, 'YYYY-MM-DD') ACAD_YR_BEGIN_DATE
, TO_CHAR(ACAD_YR_END_DATE
, 'YYYY-MM-DD') ACAD_YR_END_DATE
, TO_CHAR(ORIG_BATCH_DATE
, 'YYYY-MM-DD') ORIG_BATCH_DATE
, PNOTE_PRINT_IND
, S_DEPNCY_STATUS
, S_DEFAULT_STATUS
, UNSUB_ELIG_FOR_HEAL
, DISCLOSURE_PRINT_IND
, UNSUB_ELIG_FOR_DEPNT
, ORIG_FEE_PERCT
, LOAN_STATUS
, LOAN_CHG_STATUS
, GRADE_LEVEL_CODE
, P_SSN
, P_LAST_NAME
, P_FIRST_NAME
, SUBSTR(TRIM(P_MIDDLE_NAME)
, 1
, 1) P_MIDDLE_INITIAL
, TO_CHAR(B_CHG_BIRTH_DATE
, 'YYYY-MM-DD') B_CHG_BIRTH_DATE
, B_CHG_SSN
, B_CHG_LAST_NAME
, P_PERMT_ADDR1
, P_PERMT_ADDR2
, P_PERMT_CITY
, P_PERMT_STATE
, P_PERMT_ZIP
, P_PERMT_PHONE
, P_EMAIL_ADDR
, TO_CHAR(P_DATE_OF_BIRTH
, 'YYYY-MM-DD') P_DATE_OF_BIRTH
, P_LICENSE_NUM
, P_LICENSE_STATE
, P_CITIZENSHIP_STATUS
, P_ALIEN_REG_NUM
, P_DEFAULT_STATUS
, B_PERMT_COUNTRY
, B_PERMT_COUNTY
, P_FOREIGN_POSTAL_CODE
, P_STATE_OF_LEGAL_RES
FROM IGF_SL_LOR_LOC_ALL