VIEW: APPS.IGF_AW_TARGET_GRP

Source

View Text - Preformatted

SELECT TGRP.ROWID, TGRP.GROUP_CD, TGRP.DESCRIPTION, TGRP.ACTIVE, TGRP.MAX_GRANT_AMT, TGRP.MAX_GRANT_PERCT, TGRP.MAX_GRANT_PERCT_FACT, TGRP.MAX_LOAN_AMT, TGRP.MAX_LOAN_PERCT, TGRP.MAX_LOAN_PERCT_FACT, TGRP.MAX_WORK_AMT, TGRP.MAX_WORK_PERCT, TGRP.MAX_WORK_PERCT_FACT, TGRP.MAX_SHELP_AMT, TGRP.MAX_SHELP_PERCT, TGRP.MAX_SHELP_PERCT_FACT, TGRP.MAX_GAP_AMT, TGRP.MAX_GAP_PERCT, TGRP.MAX_GAP_PERCT_FACT, TGRP.USE_FIXED_COSTS, TGRP.MAX_AID_PKG, NULL, NULL, NULL, TGRP.CREATED_BY, TGRP.CREATION_DATE, TGRP.LAST_UPDATED_BY, TGRP.LAST_UPDATE_DATE, TGRP.LAST_UPDATE_LOGIN, TGRP.ORG_ID, TGRP.TGRP_ID, TGRP.CAL_TYPE, TGRP.SEQUENCE_NUMBER, TGRP.MAX_GIFT_AMT, TGRP.MAX_GIFT_PERCT, TGRP.MAX_GIFT_PERCT_FACT, TGRP.MAX_SCHLRSHP_PERCT, TGRP.MAX_SCHLRSHP_PERCT_FACT, TGRP.MAX_SCHLRSHP_AMT, TGRP.ADPLANS_ID FROM IGF_AW_TARGET_GRP_ALL TGRP WHERE NVL (TGRP.ORG_ID ,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT TGRP.ROWID
, TGRP.GROUP_CD
, TGRP.DESCRIPTION
, TGRP.ACTIVE
, TGRP.MAX_GRANT_AMT
, TGRP.MAX_GRANT_PERCT
, TGRP.MAX_GRANT_PERCT_FACT
, TGRP.MAX_LOAN_AMT
, TGRP.MAX_LOAN_PERCT
, TGRP.MAX_LOAN_PERCT_FACT
, TGRP.MAX_WORK_AMT
, TGRP.MAX_WORK_PERCT
, TGRP.MAX_WORK_PERCT_FACT
, TGRP.MAX_SHELP_AMT
, TGRP.MAX_SHELP_PERCT
, TGRP.MAX_SHELP_PERCT_FACT
, TGRP.MAX_GAP_AMT
, TGRP.MAX_GAP_PERCT
, TGRP.MAX_GAP_PERCT_FACT
, TGRP.USE_FIXED_COSTS
, TGRP.MAX_AID_PKG
, NULL
, NULL
, NULL
, TGRP.CREATED_BY
, TGRP.CREATION_DATE
, TGRP.LAST_UPDATED_BY
, TGRP.LAST_UPDATE_DATE
, TGRP.LAST_UPDATE_LOGIN
, TGRP.ORG_ID
, TGRP.TGRP_ID
, TGRP.CAL_TYPE
, TGRP.SEQUENCE_NUMBER
, TGRP.MAX_GIFT_AMT
, TGRP.MAX_GIFT_PERCT
, TGRP.MAX_GIFT_PERCT_FACT
, TGRP.MAX_SCHLRSHP_PERCT
, TGRP.MAX_SCHLRSHP_PERCT_FACT
, TGRP.MAX_SCHLRSHP_AMT
, TGRP.ADPLANS_ID
FROM IGF_AW_TARGET_GRP_ALL TGRP
WHERE NVL (TGRP.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)