eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGS_PE_PERSON_ID_TYP_V

Source

View Text - Preformatted


SELECT PIT.ROWID ROW_ID, pit.PERSON_ID_TYPE PERSON_ID_TYPE, pit.DESCRIPTION DESCRIPTION, pit.S_PERSON_ID_TYPE S_PERSON_ID_TYPE, PIT. PREFERRED_IND PREFERRED_IND , PIT. UNIQUE_IND UNIQUE_IND, pit.INSTITUTION_CD INSTITUTION_CD, OU.PARTY_NAME NAME, OU.INSTITUTION_STATUS INSTITUTION_STATUS, INS_STS.S_INSTITUTION_STATUS S_INSTITUTION_STATUS, lkups.LOOKUP_TYPE LOOKUP_TYPE, lkups.MEANING MEANING, PIT.FORMAT_MASK FORMAT_MASK, pit.CREATED_BY CREATED_BY, pit.CREATION_DATE CREATION_DATE, pit.LAST_UPDATED_BY LAST_UPDATED_BY, pit.LAST_UPDATE_DATE LAST_UPDATE_DATE, pit.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, pit.region_ind, PIT.CLOSED_IND FROM IGS_PE_PERSON_ID_TYP PIT , IGS_OR_INST_ORG_BASE_V OU , IGS_OR_INST_STAT INS_STS , IGS_LOOKUP_VALUES lkups WHERE PIT.INSTITUTION_CD =OU.PARTY_NUMBER(+) AND INS_STS.S_INSTITUTION_STATUS (+) = 'ACTIVE' AND INS_STS.INSTITUTION_STATUS (+) =OU.INSTITUTION_STATUS AND lkups.LOOKUP_CODE = PIT.S_PERSON_ID_TYPE AND lkups.LOOKUP_TYPE = 'PERSON_ID_TYPE'

View Text - HTML Formatted

SELECT PIT.ROWID ROW_ID
, PIT.PERSON_ID_TYPE PERSON_ID_TYPE
, PIT.DESCRIPTION DESCRIPTION
, PIT.S_PERSON_ID_TYPE S_PERSON_ID_TYPE
, PIT. PREFERRED_IND PREFERRED_IND
, PIT. UNIQUE_IND UNIQUE_IND
, PIT.INSTITUTION_CD INSTITUTION_CD
, OU.PARTY_NAME NAME
, OU.INSTITUTION_STATUS INSTITUTION_STATUS
, INS_STS.S_INSTITUTION_STATUS S_INSTITUTION_STATUS
, LKUPS.LOOKUP_TYPE LOOKUP_TYPE
, LKUPS.MEANING MEANING
, PIT.FORMAT_MASK FORMAT_MASK
, PIT.CREATED_BY CREATED_BY
, PIT.CREATION_DATE CREATION_DATE
, PIT.LAST_UPDATED_BY LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PIT.REGION_IND
, PIT.CLOSED_IND
FROM IGS_PE_PERSON_ID_TYP PIT
, IGS_OR_INST_ORG_BASE_V OU
, IGS_OR_INST_STAT INS_STS
, IGS_LOOKUP_VALUES LKUPS
WHERE PIT.INSTITUTION_CD =OU.PARTY_NUMBER(+)
AND INS_STS.S_INSTITUTION_STATUS (+) = 'ACTIVE'
AND INS_STS.INSTITUTION_STATUS (+) =OU.INSTITUTION_STATUS
AND LKUPS.LOOKUP_CODE = PIT.S_PERSON_ID_TYPE
AND LKUPS.LOOKUP_TYPE = 'PERSON_ID_TYPE'