VIEW: APPS.IGS_SS_INQ_PERSON

Source

View Text - Preformatted

SELECT tab.ROWID ROW_ID,tab.ORG_ID ORG_ID,tab.INQ_PERSON_ID INQ_PERSON_ID,tab.GIVEN_NAME GIVEN_NAME,tab.MIDDLE_NAME MIDDLE_NAME,tab.SURNAME SURNAME,tab.PREFERRED_GIVEN_NAME PREFERRED_GIVEN_NAME,tab.TITLE TITLE,tab.SUFFIX SUFFIX,tab.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT,tab.BIRTH_DT BIRTH_DT,tab.SEX SEX,tab.ETHNIC_ORIGIN ETHNIC_ORIGIN,tab.CITIZENSHIP1_ID CITIZENSHIP1_ID,tab.CITIZENSHIP2_ID CITIZENSHIP2_ID,tab.REQUEST_ID REQUEST_ID,tab.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID,tab.PROGRAM_ID PROGRAM_ID,tab.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE,tab.STATUS STATUS,tab.LAST_UPDATE_DATE LAST_UPDATE_DATE,tab.LAST_UPDATED_BY LAST_UPDATED_BY,tab.CREATION_DATE CREATION_DATE,tab.CREATED_BY CREATED_BY,tab.IMP_SOURCE_TYPE_ID IMP_SOURCE_TYPE_ID,tab.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_SS_INQ_PERSON_ALL tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.ORG_ID ORG_ID
, TAB.INQ_PERSON_ID INQ_PERSON_ID
, TAB.GIVEN_NAME GIVEN_NAME
, TAB.MIDDLE_NAME MIDDLE_NAME
, TAB.SURNAME SURNAME
, TAB.PREFERRED_GIVEN_NAME PREFERRED_GIVEN_NAME
, TAB.TITLE TITLE
, TAB.SUFFIX SUFFIX
, TAB.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, TAB.BIRTH_DT BIRTH_DT
, TAB.SEX SEX
, TAB.ETHNIC_ORIGIN ETHNIC_ORIGIN
, TAB.CITIZENSHIP1_ID CITIZENSHIP1_ID
, TAB.CITIZENSHIP2_ID CITIZENSHIP2_ID
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.STATUS STATUS
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.CREATION_DATE CREATION_DATE
, TAB.CREATED_BY CREATED_BY
, TAB.IMP_SOURCE_TYPE_ID IMP_SOURCE_TYPE_ID
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_SS_INQ_PERSON_ALL TAB