Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_APPL_SETUP |
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)