[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Shows the applicant's application requirement |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AR.ROWID ROW_ID
, AR.APP_REQ_ID
, AR.PERSON_ID
, AR.ADMISSION_APPL_NUMBER
, NULL
, NULL
, AR.APPLICANT_FEE_TYPE
, CC1.NAME FEE_TYPE
, CC1.DESCRIPTION FEE_DESCRIPTION
, AR.APPLICANT_FEE_STATUS
, CC2.NAME FEE_STATUS
, CC2.DESCRIPTION DESCRIPTION
, AR.FEE_DATE
, AR.FEE_PAYMENT_METHOD
, CC3.NAME PAYMENT_METHOD
, CC3.DESCRIPTION PAYMENT_DESCRIPTION
, AR.FEE_AMOUNT
, AR.CREATED_BY
, AR.CREATION_DATE
, AR.LAST_UPDATED_BY
, AR.LAST_UPDATE_DATE
, AR.LAST_UPDATE_LOGIN
, AR.REFERENCE_NUM
, AR.CREDIT_CARD_CODE
, AR.CREDIT_CARD_HOLDER_NAME
, AR.CREDIT_CARD_NUMBER
, AR.CREDIT_CARD_EXPIRATION_DATE
, AR.CREDIT_CARD_STATUS_CODE
, AR.CREDIT_CARD_PAYEE_CD
, AR.CREDIT_CARD_TANGIBLE_CD
, AR.REV_GL_CCID
, AR.CASH_GL_CCID
, AR.REV_ACCOUNT_CD
, AR.CASH_ACCOUNT_CD
, AR.GL_DATE
, AR.GL_POSTED_DATE
, AR.POSTING_CONTROL_ID
FROM IGS_AD_APP_REQ AR
, IGS_AD_CODE_CLASSES CC1
, IGS_AD_CODE_CLASSES CC2
, IGS_AD_CODE_CLASSES CC3
WHERE AR.APPLICANT_FEE_TYPE = CC1.CODE_ID AND AR.APPLICANT_FEE_STATUS = CC2.CODE_ID AND AR.FEE_PAYMENT_METHOD = CC3.CODE_ID(+)