DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.IGF_SL_CL_SETUP_V

Object Details
Object Name: IGF_SL_CL_SETUP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_SL_CL_SETUP_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CLSET_ID NUMBER (15) Yes
CI_CAL_TYPE VARCHAR2 (10) Yes Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER NUMBER (6) Yes Indicates a unique identifier for the award year calender instance
CI_START_DT DATE
Yes Indicates the award year start date
CI_END_DT DATE
Yes Indicates the award year end date
CI_ALTERNATE_CODE VARCHAR2 (10)
Indicates the alternate short reference code for identifying a award year calendar instance
BORW_INTEREST_IND VARCHAR2 (30)
OPE_ID VARCHAR2 (0)
FA126_3102439_CS_DP2.doc - Obsolete
FAO_NAME VARCHAR2 (0)
FA126_3102439_CS_DP2.doc - Obsolete
FAO_DUNS_ID VARCHAR2 (0)
FA126_3102439_CS_DP2.doc - Obsolete
SCH_NON_ED_BRC_ID VARCHAR2 (0)
FA126_3102439_CS_DP2.doc - Obsolete
LENDER_ID VARCHAR2 (30) Yes
DUNS_LENDER_ID VARCHAR2 (0)
Obsolete
LEND_NON_ED_BRC_ID VARCHAR2 (30)
GUARANTOR_ID VARCHAR2 (30) Yes
DUNS_GUARNT_ID VARCHAR2 (0)
Obsolete
RECIPIENT_ID VARCHAR2 (30) Yes
RECIPIENT_TYPE VARCHAR2 (30) Yes
DUNS_RECIP_ID VARCHAR2 (0)
Obsolete
RECIP_NON_ED_BRC_ID VARCHAR2 (30)
EST_ORIG_FEE_PERCT NUMBER (12)
EST_GUARNT_FEE_PERCT NUMBER (12)
EST_ALT_ORIG_FEE_PERCT NUMBER (12)
EST_ALT_GUARNT_FEE_PERCT NUMBER (12)
HOLD_REL_IND VARCHAR2 (30) Yes
REQ_SERIAL_LOAN_CODE VARCHAR2 (30) Yes
REQ_SERIAL_LOAN_DESC VARCHAR2 (4000)
LOAN_AWARD_METHOD VARCHAR2 (0)
Obsolete
LOAN_AWARD_METHOD_DESC VARCHAR2 (0)
Obsolete
PRC_TYPE_CODE VARCHAR2 (30) Yes FFELP Processing Type code for FFELP Stafford Loans
PRC_TYPE_DESC VARCHAR2 (4000)
FFELP Processing Type code description for FFELP Stafford Loans
PNOTE_DELIVERY_CODE VARCHAR2 (30) Yes
PNOTE_DELIVERY_DESC VARCHAR2 (4000)
MEDIA_TYPE VARCHAR2 (0)
Obsolete
MEDIA_TYPE_DESC VARCHAR2 (0)
Obsolete
EFT_AUTHORIZATION VARCHAR2 (30)
AUTO_LATE_DISB_IND VARCHAR2 (30)
CL_VERSION VARCHAR2 (30)
CommonLine Processing Version Code
CL_VERSION_DESC VARCHAR2 (4000)
CommonLine Processing Version Description
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
RELATIONSHIP_CD VARCHAR2 (30)
Relationship code
RELATIONSHIP_CD_DESC VARCHAR2 (80)
Relationship code description
DEFAULT_FLAG VARCHAR2 (1)
Default relationship
HOLD_CODE_DESC VARCHAR2 (4000)
Hold code description
PLUS_PROCESSING_TYPE_CODE VARCHAR2 (30)
FFELP Processing Type code for FFELP PLUS and Alternative Loans
PLUS_PROCESSING_TYPE_DESC VARCHAR2 (4000)
FFELP Processing Type code description for FFELP PLUS and Alternative Loans
FUND_RETURN_METHOD_CODE VARCHAR2 (30)
Default Fund Return Method code for a Lender Relationship
FUND_RETURN_METHOD_DESC VARCHAR2 (4000)
Default Fund Return Method code description for a Lender Relationship
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CLSET_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_START_DT
,      CI_END_DT
,      CI_ALTERNATE_CODE
,      BORW_INTEREST_IND
,      OPE_ID
,      FAO_NAME
,      FAO_DUNS_ID
,      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
,      REQ_SERIAL_LOAN_DESC
,      LOAN_AWARD_METHOD
,      LOAN_AWARD_METHOD_DESC
,      PRC_TYPE_CODE
,      PRC_TYPE_DESC
,      PNOTE_DELIVERY_CODE
,      PNOTE_DELIVERY_DESC
,      MEDIA_TYPE
,      MEDIA_TYPE_DESC
,      EFT_AUTHORIZATION
,      AUTO_LATE_DISB_IND
,      CL_VERSION
,      CL_VERSION_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RELATIONSHIP_CD
,      RELATIONSHIP_CD_DESC
,      DEFAULT_FLAG
,      HOLD_CODE_DESC
,      PLUS_PROCESSING_TYPE_CODE
,      PLUS_PROCESSING_TYPE_DESC
,      FUND_RETURN_METHOD_CODE
,      FUND_RETURN_METHOD_DESC
FROM APPS.IGF_SL_CL_SETUP_V;

Dependencies

[top of page]

APPS.IGF_SL_CL_SETUP_V references the following:

SchemaAPPS
PL/SQL PackageIGF_AW_GEN - show dependent code
SynonymIGF_SL_CL_RECIPIENT
ViewIGF_SL_CL_SETUP
ViewIGS_CA_INST
APPS.IGF_SL_CL_SETUP_V is referenced by following:

SchemaAPPS
Package BodyIGF_SL_LAR_CREATION - show dependent code