VIEW: APPS.IGR_IS_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 IGR_IS_PER_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 IGR_IS_PER_ALL TAB