VIEW: APPS.IGF_GR_REP_STDNT_V

Source

View Text - Preformatted

SELECT TRIM(DOCUMENT_ID_TXT) DOCUMENT_ID_TXT, TRIM(REP_ENTITY_ID_TXT) REP_ENTITY_ID_TXT, TRIM(ATD_ENTITY_ID_TXT) ATD_ENTITY_ID_TXT, BASE_ID, S_SSN, TO_CHAR( S_DATE_OF_BIRTH,'YYYY-MM-DD') S_DATE_OF_BIRTH, S_LAST_NAME, S_CHG_SSN, DRIVER_LIC_STATE, DRIVER_LIC_NUMBER, TO_CHAR( S_CHG_DATE_OF_BIRTH,'YYYY-MM-DD') S_CHG_DATE_OF_BIRTH, FIRST_NAME, MIDDLE_NAME, S_CHG_LAST_NAME, CITZN_STATUS_CODE, NOTE_MESSAGE, PERMT_ADDR_FOREIGN_FLAG , ADDR_TYPE_CODE , TRIM(PERMT_ADDR_LINE_1) , TRIM(PERMT_ADDR_LINE_2) , TRIM(PERMT_ADDR_LINE_3) , TRIM(PERMT_ADDR_CITY) , TRIM(PERMT_ADDR_STATE_CODE) , TRIM(PERMT_ADDR_POST_CODE) , TRIM(PERMT_ADDR_COUNTY) , TRIM(PERMT_ADDR_COUNTRY) , TRIM(PHONE_NUMBER_1) , TRIM(EMAIL_ADDRESS) FROM IGF_GR_COD_DTLS GROUP BY TRIM(DOCUMENT_ID_TXT), TRIM(REP_ENTITY_ID_TXT), TRIM(ATD_ENTITY_ID_TXT), BASE_ID, S_SSN, TO_CHAR( S_DATE_OF_BIRTH,'YYYY-MM-DD'), S_LAST_NAME, S_CHG_SSN, DRIVER_LIC_STATE, DRIVER_LIC_NUMBER, TO_CHAR( S_CHG_DATE_OF_BIRTH,'YYYY-MM-DD'), FIRST_NAME, MIDDLE_NAME, S_CHG_LAST_NAME, CITZN_STATUS_CODE, NOTE_MESSAGE, PERMT_ADDR_FOREIGN_FLAG , ADDR_TYPE_CODE , TRIM(PERMT_ADDR_LINE_1) , TRIM(PERMT_ADDR_LINE_2) , TRIM(PERMT_ADDR_LINE_3) , TRIM(PERMT_ADDR_CITY) , TRIM(PERMT_ADDR_STATE_CODE) , TRIM(PERMT_ADDR_POST_CODE) , TRIM(PERMT_ADDR_COUNTY) , TRIM(PERMT_ADDR_COUNTRY) , TRIM(PHONE_NUMBER_1) , TRIM(EMAIL_ADDRESS)

View Text - HTML Formatted

SELECT TRIM(DOCUMENT_ID_TXT) DOCUMENT_ID_TXT
, TRIM(REP_ENTITY_ID_TXT) REP_ENTITY_ID_TXT
, TRIM(ATD_ENTITY_ID_TXT) ATD_ENTITY_ID_TXT
, BASE_ID
, S_SSN
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD') S_DATE_OF_BIRTH
, S_LAST_NAME
, S_CHG_SSN
, DRIVER_LIC_STATE
, DRIVER_LIC_NUMBER
, TO_CHAR( S_CHG_DATE_OF_BIRTH
, 'YYYY-MM-DD') S_CHG_DATE_OF_BIRTH
, FIRST_NAME
, MIDDLE_NAME
, S_CHG_LAST_NAME
, CITZN_STATUS_CODE
, NOTE_MESSAGE
, PERMT_ADDR_FOREIGN_FLAG
, ADDR_TYPE_CODE
, TRIM(PERMT_ADDR_LINE_1)
, TRIM(PERMT_ADDR_LINE_2)
, TRIM(PERMT_ADDR_LINE_3)
, TRIM(PERMT_ADDR_CITY)
, TRIM(PERMT_ADDR_STATE_CODE)
, TRIM(PERMT_ADDR_POST_CODE)
, TRIM(PERMT_ADDR_COUNTY)
, TRIM(PERMT_ADDR_COUNTRY)
, TRIM(PHONE_NUMBER_1)
, TRIM(EMAIL_ADDRESS)
FROM IGF_GR_COD_DTLS GROUP BY TRIM(DOCUMENT_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(ATD_ENTITY_ID_TXT)
, BASE_ID
, S_SSN
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD')
, S_LAST_NAME
, S_CHG_SSN
, DRIVER_LIC_STATE
, DRIVER_LIC_NUMBER
, TO_CHAR( S_CHG_DATE_OF_BIRTH
, 'YYYY-MM-DD')
, FIRST_NAME
, MIDDLE_NAME
, S_CHG_LAST_NAME
, CITZN_STATUS_CODE
, NOTE_MESSAGE
, PERMT_ADDR_FOREIGN_FLAG
, ADDR_TYPE_CODE
, TRIM(PERMT_ADDR_LINE_1)
, TRIM(PERMT_ADDR_LINE_2)
, TRIM(PERMT_ADDR_LINE_3)
, TRIM(PERMT_ADDR_CITY)
, TRIM(PERMT_ADDR_STATE_CODE)
, TRIM(PERMT_ADDR_POST_CODE)
, TRIM(PERMT_ADDR_COUNTY)
, TRIM(PERMT_ADDR_COUNTRY)
, TRIM(PHONE_NUMBER_1)
, TRIM(EMAIL_ADDRESS)