eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGF_SL_CL_SETUP_OVRD_V

Object Details

Object Name:	IGF_SL_CL_SETUP_OVRD_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_CL_SETUP_OVRD_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)		Row ID
CLSET_ID	NUMBER	(15)	Yes	Sequence generated key
CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Type
SEQUENCE_NUMBER	NUMBER	(15)	Yes	Calendar Sequence Number
START_DATE	DATE		Yes	Award Year Start Date
END_DATE	DATE		Yes	Award Year End Date
ALTERNATE_CODE	VARCHAR2	(10)		Alternate Code
PARTY_ID	NUMBER	(15)		Organization Party ID
ORG_UNIT_CD	VARCHAR2	(30)		Organization Unit Code
ORG_UNIT_CD_DESC	VARCHAR2	(360)	Yes	Organization Unit
RELATIONSHIP_CD	VARCHAR2	(30)		Relationship Code
RELATIONSHIP_CD_DESC	VARCHAR2	(80)		Relationship Code description
DEFAULT_FLAG	VARCHAR2	(1)		Default Relationship
LENDER_ID_TXT	VARCHAR2	(30)	Yes	Lender ID
LENDER_BRC_ID_TXT	VARCHAR2	(30)		Lender Branch ID
GUARANTOR_ID_TXT	VARCHAR2	(30)	Yes	Guarantor ID
RECIPIENT_ID_TXT	VARCHAR2	(30)	Yes	Recipient ID
RECIPIENT_TYPE	VARCHAR2	(30)	Yes	Recipient Type
RECIPIENT_BRC_ID_TXT	VARCHAR2	(30)		Recipient Branch ID
ORIGINATION_FEE_NUM	NUMBER	(12)		Origination Fee Percent for FFELP Loans
GUARANTEE_FEE_NUM	NUMBER	(12)		Guarantee Fee Percent for FFELP Loans
ALT_ORIGINATION_FEE_NUM	NUMBER	(12)		Origination Fee Percent for Alternative Loans
ALT_GUARANTEE_FEE_NUM	NUMBER	(12)		Guarantee Fee Percent for Alternative Loans
PROCESSING_TYPE_CODE	VARCHAR2	(30)	Yes	FFELP Processing Type code for FFELP Stafford Loans
PROCESSING_TYPE_DESC	VARCHAR2	(4000)		FFELP Processing Type code description for FFELP Stafford Loans
REQUESTED_SERIAL_LOAN_CODE	VARCHAR2	(30)	Yes	Requested Serial Loan Code
REQUESTED_SERIAL_LOAN_DESC	VARCHAR2	(4000)		Requested Serial Loan
PROMISSORY_NOTE_DELIVERY_CODE	VARCHAR2	(30)	Yes	Promissory Note Delivery Code
PROMISSORY_NOTE_DELIVERY_DESC	VARCHAR2	(4000)		Promissory Note Delivery
BORROWER_INTEREST_FLAG	VARCHAR2	(30)		Borrower Interest Flag
HOLD_CODE	VARCHAR2	(30)	Yes	Hold Release Indicator Code
HOLD_CODE_DESC	VARCHAR2	(4000)		Hold Release Indicator
EFT_AUTHORIZE_FLAG	VARCHAR2	(30)		EFT Authorization Flag
AUTO_LATE_DISBURSEMENTS_FLAG	VARCHAR2	(30)		Auto Fund Late Disbursements Flag
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
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
CL_VERSION	VARCHAR2	(30)		CommonLine Processing Version Code
CL_VERSION_DESC	VARCHAR2	(4000)		CommonLine Processing Version Description

Query Text

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


SELECT ROW_ID
,      CLSET_ID
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      START_DATE
,      END_DATE
,      ALTERNATE_CODE
,      PARTY_ID
,      ORG_UNIT_CD
,      ORG_UNIT_CD_DESC
,      RELATIONSHIP_CD
,      RELATIONSHIP_CD_DESC
,      DEFAULT_FLAG
,      LENDER_ID_TXT
,      LENDER_BRC_ID_TXT
,      GUARANTOR_ID_TXT
,      RECIPIENT_ID_TXT
,      RECIPIENT_TYPE
,      RECIPIENT_BRC_ID_TXT
,      ORIGINATION_FEE_NUM
,      GUARANTEE_FEE_NUM
,      ALT_ORIGINATION_FEE_NUM
,      ALT_GUARANTEE_FEE_NUM
,      PROCESSING_TYPE_CODE
,      PROCESSING_TYPE_DESC
,      REQUESTED_SERIAL_LOAN_CODE
,      REQUESTED_SERIAL_LOAN_DESC
,      PROMISSORY_NOTE_DELIVERY_CODE
,      PROMISSORY_NOTE_DELIVERY_DESC
,      BORROWER_INTEREST_FLAG
,      HOLD_CODE
,      HOLD_CODE_DESC
,      EFT_AUTHORIZE_FLAG
,      AUTO_LATE_DISBURSEMENTS_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PLUS_PROCESSING_TYPE_CODE
,      PLUS_PROCESSING_TYPE_DESC
,      FUND_RETURN_METHOD_CODE
,      FUND_RETURN_METHOD_DESC
,      CL_VERSION
,      CL_VERSION_DESC
FROM APPS.IGF_SL_CL_SETUP_OVRD_V;

Dependencies

[top of page]

APPS.IGF_SL_CL_SETUP_OVRD_V references the following:

APPS: IGF_AP_BATCH_AW_MAP; IGF_AW_GEN - show dependent code; IGF_SL_CL_RECIPIENT; IGF_SL_CL_SETUP; IGS_CA_INST; IGS_OR_INST_ORG_BASE_V

APPS.IGF_SL_CL_SETUP_OVRD_V is not referenced by any database object