VIEW: APPS.IGF_GR_REP_PELL_V

Source

View Text - Preformatted

SELECT TRIM(DOCUMENT_ID_TXT), TRIM(REP_ENTITY_ID_TXT), TRIM(ATD_ENTITY_ID_TXT), BASE_ID, AWARD_ID, FIN_AWARD_YEAR, CPS_TRANS_NUM, AWARD_AMT, NOTE_MESSAGE, COA_AMT, LOW_TUTION_FEE, DECODE(INCARC_FLAG, 'Y', 'true', 'F', 'false') INCARC_FLAG, VER_STATUS_CODE, TO_CHAR( ENROLLMENT_DATE,'YYYY-MM-DD') ENROLLMENT_DATE, SEC_EFC_CODE FROM IGF_GR_COD_DTLS GROUP BY TRIM(DOCUMENT_ID_TXT), TRIM(REP_ENTITY_ID_TXT), TRIM(ATD_ENTITY_ID_TXT), BASE_ID, AWARD_ID, FIN_AWARD_YEAR, CPS_TRANS_NUM, AWARD_AMT, NOTE_MESSAGE, COA_AMT, LOW_TUTION_FEE, DECODE(INCARC_FLAG, 'Y', 'true', 'F', 'false') , VER_STATUS_CODE, TO_CHAR( ENROLLMENT_DATE,'YYYY-MM-DD') , SEC_EFC_CODE

View Text - HTML Formatted

SELECT TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, BASE_ID
, AWARD_ID
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, AWARD_AMT
, NOTE_MESSAGE
, COA_AMT
, LOW_TUTION_FEE
, DECODE(INCARC_FLAG
, 'Y'
, 'TRUE'
, 'F'
, 'FALSE') INCARC_FLAG
, VER_STATUS_CODE
, TO_CHAR( ENROLLMENT_DATE
, 'YYYY-MM-DD') ENROLLMENT_DATE
, SEC_EFC_CODE
FROM IGF_GR_COD_DTLS GROUP BY TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, BASE_ID
, AWARD_ID
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, AWARD_AMT
, NOTE_MESSAGE
, COA_AMT
, LOW_TUTION_FEE
, DECODE(INCARC_FLAG
, 'Y'
, 'TRUE'
, 'F'
, 'FALSE')
, VER_STATUS_CODE
, TO_CHAR( ENROLLMENT_DATE
, 'YYYY-MM-DD')
, SEC_EFC_CODE