VIEW: APPS.IGS_AD_SS_APPL_TYP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'