Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT SSA.ROWID
, SSA.ADMISSION_APPLICATION_TYPE
, SSA.DESCRIPTION
, SSA.ADMISSION_CAT
, SSA.S_ADMISSION_PROCESS_TYPE
, SSA.ADMISSION_CAT ||'/'||ILV.MEANING
, SSA.CONFIGURABILITY_FUNC_NAME
, FFV.USER_FUNCTION_NAME
, SSA.APPLICATION_FEE_AMOUNT
, SSA.GL_REV_ACCT_CCID
, SSA.GL_CASH_ACCT_CCID
, SSA.CASH_ACCOUNT_CODE
, SSA.REV_ACCOUNT_CODE
, SSA.CLOSED_IND
, SSA.CREATED_BY
, SSA.CREATION_DATE
, SSA.LAST_UPDATED_BY
, SSA.LAST_UPDATE_DATE
, SSA.LAST_UPDATE_LOGIN
, SSA.SYSTEM_DEFAULT
, SSA.ENROLL_DEPOSIT_AMOUNT
, SSA.ENROLL_DEPOSIT_LEVEL
, L2.MEANING
, SSA.USE_IN_APPL_SELF_SRVC
, SSA.CRT_REV_INSTR
, SSA.SUBMIT_INSTR
, SSA.SUBMIT_ERR_INSTR
FROM IGS_AD_SS_APPL_TYP SSA
, IGS_AD_CAT AC
, IGS_AD_PRCS_CAT APC
, FND_FORM_FUNCTIONS_VL FFV
, IGS_LOOKUP_VALUES ILV
, IGS_LOOKUP_VALUES L2
WHERE SSA.ADMISSION_CAT = AC.ADMISSION_CAT
AND APC.ADMISSION_CAT = AC.ADMISSION_CAT
AND APC.S_ADMISSION_PROCESS_TYPE = SSA.S_ADMISSION_PROCESS_TYPE
AND ILV.LOOKUP_TYPE = 'ADMISSION_PROCESS_TYPE'
AND ILV.LOOKUP_CODE = SSA.S_ADMISSION_PROCESS_TYPE
AND SSA.CONFIGURABILITY_FUNC_NAME = FFV.FUNCTION_NAME (+)
AND SSA.ENROLL_DEPOSIT_LEVEL = L2.LOOKUP_CODE (+)
AND L2.LOOKUP_TYPE (+) = 'DEPOSIT_LEVELS'