FND Design Data [Home] [Help]

View: IGF_AP_EFC_V

Product: IGF - Financial Aid
Description:
Implementation/DBA Data: ViewAPPS.IGF_AP_EFC_V
View Text

SELECT BAM.ROWID
, BAM.CI_CAL_TYPE
, BAM.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, BAM.EFC_FRML
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_EFC_FRML'
, BAM.EFC_FRML)
, BAM.NUM_DAYS_DIVISOR
, BAM.ROUNDOFF_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_EFC_ROUND_FACT'
, BAM.ROUNDOFF_FACT)
, BAM.CREATED_BY
, BAM.CREATION_DATE
, BAM.LAST_UPDATED_BY
, BAM.LAST_UPDATE_DATE
, BAM.LAST_UPDATE_LOGIN
FROM IGF_AP_BATCH_AW_MAP BAM
, IGS_CA_INST CI
WHERE BAM.CI_CAL_TYPE = CI.CAL_TYPE
AND BAM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

Columns

Name
ROW_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
CI_ALTERNATE_CODE
CI_START_DT
CI_END_DT
EFC_FRML
EFC_FRML_DESC
NUM_DAYS_DIVISOR
ROUNDOFF_FACT
ROUNDOFF_FACT_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN