VIEW: APPS.IGF_AP_EFC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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