[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Describes Self Service Admission Application Type Details |
| Implementation/DBA Data: | Not implemented in this database |
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