VIEW: APPS.IGF_AW_TARGET_GRP_V

Source

View Text - Preformatted

SELECT TGRP.ROW_ID, TGRP.GROUP_CD, TGRP.DESCRIPTION, TGRP.ACTIVE, TGRP.MAX_GRANT_AMT, TGRP.MAX_GRANT_PERCT, TGRP.MAX_GRANT_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_GRANT_PERCT_FACT), TGRP.MAX_LOAN_AMT, TGRP.MAX_LOAN_PERCT, TGRP.MAX_LOAN_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_LOAN_PERCT_FACT), TGRP.MAX_WORK_AMT, TGRP.MAX_WORK_PERCT, TGRP.MAX_WORK_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_WORK_PERCT_FACT), TGRP.MAX_SHELP_AMT, TGRP.MAX_SHELP_PERCT, TGRP.MAX_SHELP_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_SHELP_PERCT_FACT), TGRP.MAX_GAP_AMT, TGRP.MAX_GAP_PERCT, TGRP.MAX_GAP_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_GAP_PERCT_FACT), TGRP.USE_FIXED_COSTS, TGRP.MAX_AID_PKG, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, TGRP.CREATED_BY, TGRP.CREATION_DATE, TGRP.LAST_UPDATED_BY, TGRP.LAST_UPDATE_DATE, TGRP.LAST_UPDATE_LOGIN, TGRP.TGRP_ID, TGRP.CAL_TYPE, TGRP.SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, TGRP.MAX_GIFT_AMT, TGRP.MAX_GIFT_PERCT, TGRP.MAX_GIFT_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_GIFT_PERCT_FACT), TGRP.MAX_SCHLRSHP_AMT, TGRP.MAX_SCHLRSHP_PERCT, TGRP.MAX_SCHLRSHP_PERCT_FACT, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR',TGRP.MAX_SCHLRSHP_PERCT_FACT), TGRP.ADPLANS_ID, ADPLANS.AWD_DIST_PLAN_CD, ADPLANS.AWD_DIST_PLAN_CD_DESC, ADPLANS.DIST_PLAN_METHOD_CODE FROM IGF_AW_TARGET_GRP TGRP, IGS_CA_INST CI, IGF_AW_AWD_DIST_PLANS ADPLANS WHERE CI.CAL_TYPE = TGRP.CAL_TYPE AND CI.SEQUENCE_NUMBER = TGRP.SEQUENCE_NUMBER AND TGRP.ADPLANS_ID = ADPLANS.ADPLANS_ID(+)

View Text - HTML Formatted

SELECT TGRP.ROW_ID
, TGRP.GROUP_CD
, TGRP.DESCRIPTION
, TGRP.ACTIVE
, TGRP.MAX_GRANT_AMT
, TGRP.MAX_GRANT_PERCT
, TGRP.MAX_GRANT_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_GRANT_PERCT_FACT)
, TGRP.MAX_LOAN_AMT
, TGRP.MAX_LOAN_PERCT
, TGRP.MAX_LOAN_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_LOAN_PERCT_FACT)
, TGRP.MAX_WORK_AMT
, TGRP.MAX_WORK_PERCT
, TGRP.MAX_WORK_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_WORK_PERCT_FACT)
, TGRP.MAX_SHELP_AMT
, TGRP.MAX_SHELP_PERCT
, TGRP.MAX_SHELP_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_SHELP_PERCT_FACT)
, TGRP.MAX_GAP_AMT
, TGRP.MAX_GAP_PERCT
, TGRP.MAX_GAP_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_GAP_PERCT_FACT)
, TGRP.USE_FIXED_COSTS
, TGRP.MAX_AID_PKG
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TGRP.CREATED_BY
, TGRP.CREATION_DATE
, TGRP.LAST_UPDATED_BY
, TGRP.LAST_UPDATE_DATE
, TGRP.LAST_UPDATE_LOGIN
, TGRP.TGRP_ID
, TGRP.CAL_TYPE
, TGRP.SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, TGRP.MAX_GIFT_AMT
, TGRP.MAX_GIFT_PERCT
, TGRP.MAX_GIFT_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_GIFT_PERCT_FACT)
, TGRP.MAX_SCHLRSHP_AMT
, TGRP.MAX_SCHLRSHP_PERCT
, TGRP.MAX_SCHLRSHP_PERCT_FACT
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_PERCT_VAR'
, TGRP.MAX_SCHLRSHP_PERCT_FACT)
, TGRP.ADPLANS_ID
, ADPLANS.AWD_DIST_PLAN_CD
, ADPLANS.AWD_DIST_PLAN_CD_DESC
, ADPLANS.DIST_PLAN_METHOD_CODE
FROM IGF_AW_TARGET_GRP TGRP
, IGS_CA_INST CI
, IGF_AW_AWD_DIST_PLANS ADPLANS
WHERE CI.CAL_TYPE = TGRP.CAL_TYPE
AND CI.SEQUENCE_NUMBER = TGRP.SEQUENCE_NUMBER
AND TGRP.ADPLANS_ID = ADPLANS.ADPLANS_ID(+)