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_COA_GROUP

Object Details

Object Name:	IGF_AW_COA_GROUP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_AW_COA_GROUP
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)
COA_CODE	VARCHAR2	(30)	Yes
CI_CAL_TYPE	VARCHAR2	(10)	Yes
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes
RULE_ORDER	VARCHAR2	(0)
S_RULE_CALL_CD	VARCHAR2	(0)
RUL_SEQUENCE_NUMBER	VARCHAR2	(0)
PELL_COA	VARCHAR2	(0)		Pell Grant associated with COA
PELL_ALT_EXP	VARCHAR2	(0)		Alternate expenses in case of a Low Tuition fee Cost of Attendance
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)
ORG_ID	NUMBER	(15)
COA_GRP_DESC	VARCHAR2	(80)

Query Text

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


SELECT ROW_ID
,      COA_CODE
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      RULE_ORDER
,      S_RULE_CALL_CD
,      RUL_SEQUENCE_NUMBER
,      PELL_COA
,      PELL_ALT_EXP
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      COA_GRP_DESC
FROM APPS.IGF_AW_COA_GROUP;

Dependencies

[top of page]

APPS.IGF_AW_COA_GROUP references the following:

APPS: IGF_AW_COA_GROUP_ALL

APPS.IGF_AW_COA_GROUP is referenced by following:

APPS: IGF_AW_COA_GROUP_PKG - show dependent code; IGF_AW_COA_GROUP_V