VIEW: APPS.IGF_AP_FA_SETUP

Source

View Text - Preformatted

SELECT fas.rowid ROW_ID, fas.fao_id FAO_ID, fas.fao_name FAO_NAME, fas.party_id PARTY_ID, fas.ope_id OPE_ID, fas.pell_id PELL_ID, fas.duns_id DUNS_ID, fas.css_id CSS_ID, fas.state_agency_id STATE_AGENCY_ID, fas.campus_id CAMPUS_ID, fas.crs_id CRS_ID, fas.low_default LOW_DEFAULT, fas.qa_school QA_SCHOOL, fas.experimental EXPERIMENTAL, fas.grade_calc_opt GRADE_CALC_OPT, fas.created_by CREATED_BY, fas.creation_date CREATION_DATE, fas.last_updated_by LAST_UPDATED_BY, fas.last_update_date LAST_UPDATE_DATE, fas.last_update_login LAST_UPDATE_LOGIN, fas.ORG_ID ORG_ID, fas.fas_id FAS_ID, FAS.FSEOG_MATCH_MTHD FSEOG_MATCH_MTHD , FAS.FSEOG_FED_PCT FSEOG_FED_PCT, FAS.FSEOG_WAIVER FSEOG_WAIVER, FAS.DEST_NUM DEST_NUM FROM igf_ap_fa_setup_all fas WHERE NVL (FAS.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 FAS.ROWID ROW_ID
, FAS.FAO_ID FAO_ID
, FAS.FAO_NAME FAO_NAME
, FAS.PARTY_ID PARTY_ID
, FAS.OPE_ID OPE_ID
, FAS.PELL_ID PELL_ID
, FAS.DUNS_ID DUNS_ID
, FAS.CSS_ID CSS_ID
, FAS.STATE_AGENCY_ID STATE_AGENCY_ID
, FAS.CAMPUS_ID CAMPUS_ID
, FAS.CRS_ID CRS_ID
, FAS.LOW_DEFAULT LOW_DEFAULT
, FAS.QA_SCHOOL QA_SCHOOL
, FAS.EXPERIMENTAL EXPERIMENTAL
, FAS.GRADE_CALC_OPT GRADE_CALC_OPT
, FAS.CREATED_BY CREATED_BY
, FAS.CREATION_DATE CREATION_DATE
, FAS.LAST_UPDATED_BY LAST_UPDATED_BY
, FAS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FAS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FAS.ORG_ID ORG_ID
, FAS.FAS_ID FAS_ID
, FAS.FSEOG_MATCH_MTHD FSEOG_MATCH_MTHD
, FAS.FSEOG_FED_PCT FSEOG_FED_PCT
, FAS.FSEOG_WAIVER FSEOG_WAIVER
, FAS.DEST_NUM DEST_NUM
FROM IGF_AP_FA_SETUP_ALL FAS
WHERE NVL (FAS.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)