VIEW: APPS.IGF_SL_COD_LOANKEY_V

Source

View Text - Preformatted

SELECT DOCUMENT_ID_TXT, REP_ENTITY_ID_TXT, ATD_ENTITY_ID_TXT, BASE_ID, SOURCE_ENTITY_ID_TXT, LOAN_KEY_NUM, INTEREST_REBATE_PERCENT_NUM, 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 , PNOTE_PRINT_IND, DISCLOSURE_PRINT_IND , ORIG_FEE_PERCT, GRADE_LEVEL_CODE FROM IGF_SL_LOR_LOC_ALL GROUP BY DOCUMENT_ID_TXT, REP_ENTITY_ID_TXT, ATD_ENTITY_ID_TXT, BASE_ID, SOURCE_ENTITY_ID_TXT, LOAN_KEY_NUM, INTEREST_REBATE_PERCENT_NUM, LOAN_PER_BEGIN_DATE, LOAN_PER_END_DATE, ACAD_YR_BEGIN_DATE, ACAD_YR_END_DATE, PNOTE_PRINT_IND, DISCLOSURE_PRINT_IND, ORIG_FEE_PERCT, GRADE_LEVEL_CODE

View Text - HTML Formatted

SELECT DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, BASE_ID
, SOURCE_ENTITY_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, 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
, PNOTE_PRINT_IND
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, GRADE_LEVEL_CODE
FROM IGF_SL_LOR_LOC_ALL GROUP BY DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, BASE_ID
, SOURCE_ENTITY_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, LOAN_PER_BEGIN_DATE
, LOAN_PER_END_DATE
, ACAD_YR_BEGIN_DATE
, ACAD_YR_END_DATE
, PNOTE_PRINT_IND
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, GRADE_LEVEL_CODE