VIEW: APPS.IGF_SL_REP_STDNT_V

Source

View Text - Preformatted

SELECT BASE_ID, S_SSN, TRIM(S_LAST_NAME) S_LAST_NAME, TRIM(S_FIRST_NAME) S_FIRST_NAME, SUBSTR(TRIM(S_MIDDLE_NAME),1,1) S_MIDDLE_INITIAL, TRIM(S_PERMT_ADDR1) S_PERMT_ADDR1, TRIM(S_PERMT_ADDR2) S_PERMT_ADDR2, TRIM(S_PERMT_CITY) S_PERMT_CITY, TRIM(S_PERMT_STATE) S_PERMT_STATE, TRIM(S_PERMT_ZIP) S_PERMT_ZIP, TRIM(S_PERMT_PHONE) S_PERMT_PHONE, TRIM(S_EMAIL_ADDR) S_EMAIL_ADDR, TO_CHAR( S_DATE_OF_BIRTH,'YYYY-MM-DD') S_DATE_OF_BIRTH, TO_CHAR( S_CHG_BIRTH_DATE,'YYYY-MM-DD') S_CHG_BIRTH_DATE, S_CHG_SSN, TRIM(S_PERMT_COUNTY) S_PERMT_COUNTY, TRIM(S_PERMT_COUNTRY) S_PERMT_COUNTRY, TRIM (S_CHG_LAST_NAME) S_CHG_LAST_NAME, TRIM(S_LICENSE_NUM) S_LICENSE_NUM, TRIM(S_LICENSE_STATE) S_LICENSE_STATE, TRIM(S_DEPNCY_STATUS) S_DEPNCY_STATUS, TRIM(S_CITIZENSHIP_STATUS) S_CITIZENSHIP_STATUS, TRIM(S_FOREIGN_POSTAL_CODE) S_FOREIGN_POSTAL_CODE, TRIM(ATD_ENTITY_ID_TXT) ATD_ENTITY_ID_TXT, TRIM(REP_ENTITY_ID_TXT) REP_ENTITY_ID_TXT, TRIM(DOCUMENT_ID_TXT) DOCUMENT_ID_TXT FROM IGF_SL_LOR_LOC_ALL GROUP BY BASE_ID, S_SSN, TRIM(S_LAST_NAME) , TRIM(S_FIRST_NAME) , SUBSTR(TRIM(S_MIDDLE_NAME),1,1) , TRIM(S_PERMT_ADDR1) , TRIM(S_PERMT_ADDR2) , TRIM(S_PERMT_CITY) , TRIM(S_PERMT_STATE) , TRIM(S_PERMT_ZIP) , TRIM(S_PERMT_PHONE) , TRIM(S_EMAIL_ADDR) , TO_CHAR( S_DATE_OF_BIRTH,'YYYY-MM-DD') , TO_CHAR( S_CHG_BIRTH_DATE,'YYYY-MM-DD') , S_CHG_SSN, TRIM(S_PERMT_COUNTY) , TRIM(S_PERMT_COUNTRY) , TRIM (S_CHG_LAST_NAME) , TRIM(S_LICENSE_NUM) , TRIM(S_LICENSE_STATE) , TRIM(S_DEPNCY_STATUS) , TRIM(S_CITIZENSHIP_STATUS) , TRIM(S_FOREIGN_POSTAL_CODE) , TRIM(ATD_ENTITY_ID_TXT) , TRIM(REP_ENTITY_ID_TXT) , TRIM(DOCUMENT_ID_TXT)

View Text - HTML Formatted

SELECT BASE_ID
, S_SSN
, TRIM(S_LAST_NAME) S_LAST_NAME
, TRIM(S_FIRST_NAME) S_FIRST_NAME
, SUBSTR(TRIM(S_MIDDLE_NAME)
, 1
, 1) S_MIDDLE_INITIAL
, TRIM(S_PERMT_ADDR1) S_PERMT_ADDR1
, TRIM(S_PERMT_ADDR2) S_PERMT_ADDR2
, TRIM(S_PERMT_CITY) S_PERMT_CITY
, TRIM(S_PERMT_STATE) S_PERMT_STATE
, TRIM(S_PERMT_ZIP) S_PERMT_ZIP
, TRIM(S_PERMT_PHONE) S_PERMT_PHONE
, TRIM(S_EMAIL_ADDR) S_EMAIL_ADDR
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD') S_DATE_OF_BIRTH
, TO_CHAR( S_CHG_BIRTH_DATE
, 'YYYY-MM-DD') S_CHG_BIRTH_DATE
, S_CHG_SSN
, TRIM(S_PERMT_COUNTY) S_PERMT_COUNTY
, TRIM(S_PERMT_COUNTRY) S_PERMT_COUNTRY
, TRIM (S_CHG_LAST_NAME) S_CHG_LAST_NAME
, TRIM(S_LICENSE_NUM) S_LICENSE_NUM
, TRIM(S_LICENSE_STATE) S_LICENSE_STATE
, TRIM(S_DEPNCY_STATUS) S_DEPNCY_STATUS
, TRIM(S_CITIZENSHIP_STATUS) S_CITIZENSHIP_STATUS
, TRIM(S_FOREIGN_POSTAL_CODE) S_FOREIGN_POSTAL_CODE
, TRIM(ATD_ENTITY_ID_TXT) ATD_ENTITY_ID_TXT
, TRIM(REP_ENTITY_ID_TXT) REP_ENTITY_ID_TXT
, TRIM(DOCUMENT_ID_TXT) DOCUMENT_ID_TXT
FROM IGF_SL_LOR_LOC_ALL GROUP BY BASE_ID
, S_SSN
, TRIM(S_LAST_NAME)
, TRIM(S_FIRST_NAME)
, SUBSTR(TRIM(S_MIDDLE_NAME)
, 1
, 1)
, TRIM(S_PERMT_ADDR1)
, TRIM(S_PERMT_ADDR2)
, TRIM(S_PERMT_CITY)
, TRIM(S_PERMT_STATE)
, TRIM(S_PERMT_ZIP)
, TRIM(S_PERMT_PHONE)
, TRIM(S_EMAIL_ADDR)
, TO_CHAR( S_DATE_OF_BIRTH
, 'YYYY-MM-DD')
, TO_CHAR( S_CHG_BIRTH_DATE
, 'YYYY-MM-DD')
, S_CHG_SSN
, TRIM(S_PERMT_COUNTY)
, TRIM(S_PERMT_COUNTRY)
, TRIM (S_CHG_LAST_NAME)
, TRIM(S_LICENSE_NUM)
, TRIM(S_LICENSE_STATE)
, TRIM(S_DEPNCY_STATUS)
, TRIM(S_CITIZENSHIP_STATUS)
, TRIM(S_FOREIGN_POSTAL_CODE)
, TRIM(ATD_ENTITY_ID_TXT)
, TRIM(REP_ENTITY_ID_TXT)
, TRIM(DOCUMENT_ID_TXT)