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_AW_FUND_CAT_V

Object Details

Object Name:	IGF_AW_FUND_CAT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_AW_FUND_CAT_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)		Database rowid for igf_aw_fund_cat table
FUND_CODE	VARCHAR2	(30)	Yes	Unique code for each fund
DESCRIPTION	VARCHAR2	(80)		Long name for fund code
FUND_TYPE	VARCHAR2	(30)	Yes	Unique code which identifies the Type under which the Fund falls
FUND_TYPE_DESC	VARCHAR2	(80)	Yes	Long name for fund type code
SYS_FUND_TYPE	VARCHAR2	(30)	Yes	Unique code for each system fund type
SYS_FUND_TYPE_DESC	VARCHAR2	(80)	Yes	Long name for system fund type
FUND_SOURCE	VARCHAR2	(30)	Yes	Unique code for each fund source
FUND_SOURCE_DESC	VARCHAR2	(80)	Yes	Long name for fund source code
FED_FUND_CODE	VARCHAR2	(30)	Yes	Unique code for each federal fund
FED_FUND_CODE_DESC	VARCHAR2	(80)	Yes	Long name for federal fund code
ACTIVE	VARCHAR2	(30)	Yes	Indicator that specifies if the fund code is active or not. Setting the checkbox to inactive prevents use of the fund code in new or modified records
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			Standard who column
FCAT_ID	NUMBER	(15)	Yes
ALT_LOAN_CODE	VARCHAR2	(30)		Alternative Loan Code for the corresponding Alternative Loan Fund
ALT_REL_CODE	VARCHAR2	(30)		Lender Relationship Code for the corresponding Alternative Loan Code
ALT_LOAN_CODE_DESC	VARCHAR2	(4000)		Alternative Loan Code for the corresponding Alternative Loan fund

Query Text

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


SELECT ROW_ID
,      FUND_CODE
,      DESCRIPTION
,      FUND_TYPE
,      FUND_TYPE_DESC
,      SYS_FUND_TYPE
,      SYS_FUND_TYPE_DESC
,      FUND_SOURCE
,      FUND_SOURCE_DESC
,      FED_FUND_CODE
,      FED_FUND_CODE_DESC
,      ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FCAT_ID
,      ALT_LOAN_CODE
,      ALT_REL_CODE
,      ALT_LOAN_CODE_DESC
FROM APPS.IGF_AW_FUND_CAT_V;

Dependencies

[top of page]

APPS.IGF_AW_FUND_CAT_V references the following:

APPS: IGF_AW_FUND_CAT; IGF_AW_FUND_TYPE; IGF_AW_GEN - show dependent code; IGF_LOOKUPS_VIEW

APPS.IGF_AW_FUND_CAT_V is referenced by following:

APPS: IGF_AW_SS_GEN_PKG - show dependent code