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

VIEW: APPS.IGF_SL_LOANS

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LOAN_ID NUMBER (15) Yes
AWARD_ID NUMBER (15) Yes
SEQ_NUM NUMBER (15)
LOAN_NUMBER VARCHAR2 (30)
LOAN_PER_BEGIN_DATE DATE
Yes
LOAN_PER_END_DATE DATE
Yes
LOAN_STATUS VARCHAR2 (30) Yes
LOAN_STATUS_DATE DATE

LOAN_CHG_STATUS VARCHAR2 (30)
LOAN_CHG_STATUS_DATE DATE

ACTIVE VARCHAR2 (1) Yes
ACTIVE_DATE DATE
Yes
BORW_DETRM_CODE VARCHAR2 (30)
For borrower's determination for payee for the excess credit amount.Valid values are Pay to Borrower,Pay to Student and Place on Account.
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)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER (15)
LEGACY_RECORD_FLAG VARCHAR2 (1)
Indicates whether the record was imported through a legacy process or not
EXTERNAL_LOAN_ID_TXT VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      LOAN_ID
,      AWARD_ID
,      SEQ_NUM
,      LOAN_NUMBER
,      LOAN_PER_BEGIN_DATE
,      LOAN_PER_END_DATE
,      LOAN_STATUS
,      LOAN_STATUS_DATE
,      LOAN_CHG_STATUS
,      LOAN_CHG_STATUS_DATE
,      ACTIVE
,      ACTIVE_DATE
,      BORW_DETRM_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      LEGACY_RECORD_FLAG
,      EXTERNAL_LOAN_ID_TXT
FROM APPS.IGF_SL_LOANS;

Dependencies

[top of page]

APPS.IGF_SL_LOANS references the following:

SchemaAPPS
SynonymIGF_SL_LOANS_ALL
APPS.IGF_SL_LOANS is referenced by following:

SchemaAPPS
Package BodyIGF_AW_GEN - show dependent code
Package BodyIGF_AW_GEN_003 - show dependent code
Package BodyIGF_AW_PACKAGING - show dependent code
Package BodyIGF_DB_DISB - show dependent code
ViewIGF_DB_DL_DISB_DTL_V
Package BodyIGF_DB_DL_DISB_ORIG - show dependent code
Package BodyIGF_DB_DL_ORIG_ACK - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
PL/SQL PackageIGF_SL_AWARD - show dependent code
Package BodyIGF_SL_AWARD - show dependent code
Package BodyIGF_SL_CLCHSN_DTLS_PKG - show dependent code
Package BodyIGF_SL_CL_CHG_FILE - show dependent code
Package BodyIGF_SL_CL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_CL_ORIG - show dependent code
Package BodyIGF_SL_CL_ORIG_ACK - show dependent code
Package BodyIGF_SL_CL_VALIDATION - show dependent code
Package BodyIGF_SL_DL_CHG_ACK - show dependent code
Package BodyIGF_SL_DL_CHG_ORIG - show dependent code
Package BodyIGF_SL_DL_GEN_XML - show dependent code
Package BodyIGF_SL_DL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_DL_ORIG - show dependent code
Package BodyIGF_SL_DL_ORIG_ACK - show dependent code
Package BodyIGF_SL_DL_PNOTE_ACK - show dependent code
Package BodyIGF_SL_DL_PRINT_PNOTE - show dependent code
PL/SQL PackageIGF_SL_DL_RECORD - show dependent code
Package BodyIGF_SL_DL_RECORD - show dependent code
Package BodyIGF_SL_DL_VALIDATION - show dependent code
Package BodyIGF_SL_GEN - show dependent code
PL/SQL PackageIGF_SL_GEN - show dependent code
Package BodyIGF_SL_LAR_CREATION - show dependent code
ViewIGF_SL_LOANS_SUM_V
ViewIGF_SL_LOANS_V
ViewIGF_SL_LOR_DTLS_V
Package BodyIGF_SL_LOR_PKG - show dependent code
ViewIGF_SL_LOR_V
ViewIGF_SL_PLUS_LOAN_DETAILS_V
ViewIGF_SL_PNOTE_STAT_H_V
ViewIGF_SL_PRK_LOAN_V
Package BodyIGF_SL_REJ_WF - show dependent code
Package BodyIGF_SL_REL_DISB - show dependent code
Package BodyIGF_SL_UPLOAD_XML - show dependent code
Package BodyIGS_FI_GEN_REFUNDS - show dependent code