VIEW: APPS.IGF_AP_RECORD_MATCH

Source

View Text - Preformatted

SELECT rowid row_id , arm_id , ssn , given_name , surname , birth_dt , address , city , zip , min_score_auto_fa , min_score_rvw_fa , admn_term , created_by , creation_date , last_updated_by , last_update_date , last_update_login , match_code , match_desc , gender_num , email_num , enabled_flag , given_name_mt_txt , surname_mt_txt , birth_dt_mt_txt , address_mt_txt , city_mt_txt , zip_mt_txt , GENDER_MT_TXT , EMAIL_MT_TXT FROM igf_ap_record_match_all WHERE NVL (org_id, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT ROWID ROW_ID
, ARM_ID
, SSN
, GIVEN_NAME
, SURNAME
, BIRTH_DT
, ADDRESS
, CITY
, ZIP
, MIN_SCORE_AUTO_FA
, MIN_SCORE_RVW_FA
, ADMN_TERM
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MATCH_CODE
, MATCH_DESC
, GENDER_NUM
, EMAIL_NUM
, ENABLED_FLAG
, GIVEN_NAME_MT_TXT
, SURNAME_MT_TXT
, BIRTH_DT_MT_TXT
, ADDRESS_MT_TXT
, CITY_MT_TXT
, ZIP_MT_TXT
, GENDER_MT_TXT
, EMAIL_MT_TXT
FROM IGF_AP_RECORD_MATCH_ALL
WHERE NVL (ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)