VIEW: APPS.IGF_AP_APPL_SETUP

Source

View Text - Preformatted

SELECT DISTINCT ias.rowid row_id, ias.question_id, ias.question, ias.enabled, ias.org_id, ias.ci_cal_type, ias.ci_sequence_number, ias.created_by, ias.creation_date, ias.last_updated_by, ias.last_update_date, ias.last_update_login, ias.application_code, ias.application_name, ias.active_flag, ias.answer_type_code, ias.destination_txt, ias.ld_cal_type, ias.ld_sequence_number, ias.all_terms_flag, ias.override_exist_ant_data_flag, ias.required_flag, ias.minimum_value_num, ias.maximum_value_num, ias.minimum_date, ias.maximium_date, ias.lookup_code, ias.hint_txt From igf_ap_appl_setup_all ias WHERE NVL (ias.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 DISTINCT IAS.ROWID ROW_ID
, IAS.QUESTION_ID
, IAS.QUESTION
, IAS.ENABLED
, IAS.ORG_ID
, IAS.CI_CAL_TYPE
, IAS.CI_SEQUENCE_NUMBER
, IAS.CREATED_BY
, IAS.CREATION_DATE
, IAS.LAST_UPDATED_BY
, IAS.LAST_UPDATE_DATE
, IAS.LAST_UPDATE_LOGIN
, IAS.APPLICATION_CODE
, IAS.APPLICATION_NAME
, IAS.ACTIVE_FLAG
, IAS.ANSWER_TYPE_CODE
, IAS.DESTINATION_TXT
, IAS.LD_CAL_TYPE
, IAS.LD_SEQUENCE_NUMBER
, IAS.ALL_TERMS_FLAG
, IAS.OVERRIDE_EXIST_ANT_DATA_FLAG
, IAS.REQUIRED_FLAG
, IAS.MINIMUM_VALUE_NUM
, IAS.MAXIMUM_VALUE_NUM
, IAS.MINIMUM_DATE
, IAS.MAXIMIUM_DATE
, IAS.LOOKUP_CODE
, IAS.HINT_TXT
FROM IGF_AP_APPL_SETUP_ALL IAS
WHERE NVL (IAS.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)