VIEW: APPS.IGSFV_AD_ADM_APPL_TYP

Source

View Text - Preformatted

SELECT apt.ADMISSION_APPLICATION_TYPE, apt.DESCRIPTION, apt.ADMISSION_CAT, ac.DESCRIPTION, '_LA:apt.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING', apt.CONFIGURABILITY_FUNC_NAME, ff.USER_FUNCTION_NAME, ff.DESCRIPTION, apt.APPLICATION_FEE_AMOUNT, apt.GL_REV_ACCT_CCID, kfv1.CONCATENATED_SEGMENTS, apt.GL_CASH_ACCT_CCID, kfv2.CONCATENATED_SEGMENTS, apt.REV_ACCOUNT_CODE, apt.CASH_ACCOUNT_CODE, '_LA:apt.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', apt.created_by, apt.creation_date, apt.last_updated_by, apt.last_update_date, apt.ENROLL_DEPOSIT_AMOUNT, '_LA:apt.ENROLL_DEPOSIT_LEVEL:IGS_LOOKUP_VALUES:DEPOSIT_LEVELS:MEANING', apt.SYSTEM_DEFAULT, apt. CRT_REV_INSTR, apt. SUBMIT_INSTR, apt. SUBMIT_ERR_INSTR FROM igs_ad_ss_appl_typ apt, IGS_AD_CAT_ALL ac, FND_FORM_FUNCTIONS_VL ff, GL_CODE_COMBINATIONS_KFV kfv1, GL_CODE_COMBINATIONS_KFV kfv2 WHERE apt.ADMISSION_CAT = ac.ADMISSION_CAT AND apt.CONFIGURABILITY_FUNC_NAME = ff.FUNCTION_NAME(+) AND apt.GL_REV_ACCT_CCID = kfv1.CODE_COMBINATION_ID(+) AND apt.GL_REV_ACCT_CCID = kfv2.CODE_COMBINATION_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT APT.ADMISSION_APPLICATION_TYPE
, APT.DESCRIPTION
, APT.ADMISSION_CAT
, AC.DESCRIPTION
, '_LA:APT.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, APT.CONFIGURABILITY_FUNC_NAME
, FF.USER_FUNCTION_NAME
, FF.DESCRIPTION
, APT.APPLICATION_FEE_AMOUNT
, APT.GL_REV_ACCT_CCID
, KFV1.CONCATENATED_SEGMENTS
, APT.GL_CASH_ACCT_CCID
, KFV2.CONCATENATED_SEGMENTS
, APT.REV_ACCOUNT_CODE
, APT.CASH_ACCOUNT_CODE
, '_LA:APT.CLOSED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APT.CREATED_BY
, APT.CREATION_DATE
, APT.LAST_UPDATED_BY
, APT.LAST_UPDATE_DATE
, APT.ENROLL_DEPOSIT_AMOUNT
, '_LA:APT.ENROLL_DEPOSIT_LEVEL:IGS_LOOKUP_VALUES:DEPOSIT_LEVELS:MEANING'
, APT.SYSTEM_DEFAULT
, APT. CRT_REV_INSTR
, APT. SUBMIT_INSTR
, APT. SUBMIT_ERR_INSTR
FROM IGS_AD_SS_APPL_TYP APT
, IGS_AD_CAT_ALL AC
, FND_FORM_FUNCTIONS_VL FF
, GL_CODE_COMBINATIONS_KFV KFV1
, GL_CODE_COMBINATIONS_KFV KFV2
WHERE APT.ADMISSION_CAT = AC.ADMISSION_CAT
AND APT.CONFIGURABILITY_FUNC_NAME = FF.FUNCTION_NAME(+)
AND APT.GL_REV_ACCT_CCID = KFV1.CODE_COMBINATION_ID(+)
AND APT.GL_REV_ACCT_CCID = KFV2.CODE_COMBINATION_ID(+) WITH READ ONLY