Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT APR.APP_REQ_ID
, APR.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APR.ADMISSION_APPL_NUMBER
, APR.NOMINATED_COURSE_CD
, APR.SEQUENCE_NUMBER
, APR.APPLICANT_FEE_TYPE
, CC1.NAME
, CC1.DESCRIPTION
, APR.APPLICANT_FEE_STATUS
, CC2.NAME
, CC2.DESCRIPTION
, APR.FEE_DATE
, APR.FEE_AMOUNT
, APR.REFERENCE_NUM
, APR.REV_GL_CCID
, KFV1.CONCATENATED_SEGMENTS
, APR.CASH_GL_CCID
, KFV2.CONCATENATED_SEGMENTS
, APR.REV_ACCOUNT_CD
, APR.CASH_ACCOUNT_CD
, APR.GL_DATE
, APR.GL_POSTED_DATE
, APR.POSTING_CONTROL_ID
, APR.CREATED_BY
, APR.CREATION_DATE
, APR.LAST_UPDATED_BY
, APR.LAST_UPDATE_DATE
FROM IGS_AD_APP_REQ APR
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, GL_CODE_COMBINATIONS_KFV KFV1
, GL_CODE_COMBINATIONS_KFV KFV2
WHERE APR.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND APR.APPLICANT_FEE_TYPE = CC1.CODE_ID
AND APR.APPLICANT_FEE_STATUS = CC2.CODE_ID
AND APR.REV_GL_CCID = KFV1.CODE_COMBINATION_ID(+)
AND APR.CASH_GL_CCID = KFV2.CODE_COMBINATION_ID(+) WITH READ ONLY