FND Design Data [Home] [Help]

View: IGF_SL_CL_SETUP

Product: IGF - Financial Aid (Obsolete)
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT CLSET.ROWID
, CLSET.CLSET_ID
, CLSET.CI_CAL_TYPE
, CLSET.CI_SEQUENCE_NUMBER
, CLSET.BORW_INTEREST_IND
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, CLSET.EST_ORIG_FEE_PERCT
, CLSET.EST_GUARNT_FEE_PERCT
, CLSET.EST_ALT_ORIG_FEE_PERCT
, CLSET.EST_ALT_GUARNT_FEE_PERCT
, CLSET.HOLD_REL_IND
, CLSET.REQ_SERIAL_LOAN_CODE
, NULL
, CLSET.PRC_TYPE_CODE
, CLSET.PNOTE_DELIVERY_CODE
, NULL
, CLSET.EFT_AUTHORIZATION
, CLSET.AUTO_LATE_DISB_IND
, CLSET.CL_VERSION
, CLSET.CREATED_BY
, CLSET.CREATION_DATE
, CLSET.LAST_UPDATED_BY
, CLSET.LAST_UPDATE_DATE
, CLSET.LAST_UPDATE_LOGIN
, CLSET.ORG_ID
, CLSET.RELATIONSHIP_CD
, CLSET.DEFAULT_FLAG
, CLSET.PARTY_ID
, CLSET.PLUS_PROCESSING_TYPE_CODE
, CLSET.FUND_RETURN_METHOD_CODE
FROM IGF_SL_CL_SETUP_ALL CLSET
WHERE NVL (CLSET.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)

Columns

Name
ROW_ID
CLSET_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
BORW_INTEREST_IND
SCH_NON_ED_BRC_ID
LENDER_ID
DUNS_LENDER_ID
LEND_NON_ED_BRC_ID
GUARANTOR_ID
DUNS_GUARNT_ID
RECIPIENT_ID
RECIPIENT_TYPE
DUNS_RECIP_ID
RECIP_NON_ED_BRC_ID
EST_ORIG_FEE_PERCT
EST_GUARNT_FEE_PERCT
EST_ALT_ORIG_FEE_PERCT
EST_ALT_GUARNT_FEE_PERCT
HOLD_REL_IND
REQ_SERIAL_LOAN_CODE
LOAN_AWARD_METHOD
PRC_TYPE_CODE
PNOTE_DELIVERY_CODE
MEDIA_TYPE
EFT_AUTHORIZATION
AUTO_LATE_DISB_IND
CL_VERSION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ORG_ID
RELATIONSHIP_CD
DEFAULT_FLAG
PARTY_ID
PLUS_PROCESSING_TYPE_CODE
FUND_RETURN_METHOD_CODE