[Home] [Help]
View: IGF_AW_COA_GROUP_V
Product: | IGF - Financial Aid |
Description: | Stores group codes for cost of attendance |
Implementation/DBA Data: |
APPS.IGF_AW_COA_GROUP_V
|
View Text
SELECT COAG.ROW_ID
, COAG.COA_CODE
, NULL
, COAG.CI_CAL_TYPE
, COAG.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, COAG.CREATED_BY
, COAG.CREATION_DATE
, COAG.LAST_UPDATE_DATE
, COAG.LAST_UPDATED_BY
, COAG.LAST_UPDATE_LOGIN
, COAG.COA_GRP_DESC
FROM IGF_AW_COA_GROUP COAG
, IGS_CA_INST CI
WHERE COAG.CI_CAL_TYPE = CI.CAL_TYPE
AND COAG.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
Columns
Name |
ROW_ID |
COA_CODE |
DESCRIPTION |
CI_CAL_TYPE |
CI_SEQUENCE_NUMBER |
CI_ALTERNATE_CODE |
CI_START_DT |
CI_END_DT |
RULE_ORDER |
S_RULE_CALL_CD |
RUL_SEQUENCE_NUMBER |
RUD_SEQUENCE_NUMBER |
S_RETURN_TYPE |
RULE_DESCRIPTION |
RULE_TEXT |
RUG_SEQUENCE_NUMBER |
PELL_COA |
PELL_ALT_EXP |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
COA_GRP_DESC |