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]

TABLE: IGC.IGC_CBC_BA_RANGES

Object Details

Object Name:	IGC_CBC_BA_RANGES
Object Type:	TABLE
Owner:	IGC
FND Design Data:	IGC.IGC_CBC_BA_RANGES
Subobject Name:
Status:	VALID

IGC_CBC_BA_RANGES stores the fund check level codes that are specific to Contract Commitment at the budget assignment ranges level. For each row in the GL_BUDGET_ASSIGNMENT_RANGES table, there may be one and only one row in this table. The fund check level in Contract Commitment may differ from the fund check level in General Ledger; therefore, the one to one relationship is required.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGC_CBC_BA_RANGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CBC_RANGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CBC_RANGE_ID	NUMBER	(15)	Yes	Account range assignment defining column
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Accounting books defining column
SBC_FUNDS_CHECK_LEVEL_CODE	VARCHAR2	(1)	Yes	Funds checking severity level of standard budget
CBC_OVERRIDE	VARCHAR2	(1)	Yes	The funds check severity level of standard budget override at commitment budget level
BUDGET_ENTITY_ID	NUMBER	(15)	Yes	Budget organization defining column
STATUS	VARCHAR2	(1)	Yes	Current status of assignment range
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT CBC_RANGE_ID
,      SET_OF_BOOKS_ID
,      SBC_FUNDS_CHECK_LEVEL_CODE
,      CBC_OVERRIDE
,      BUDGET_ENTITY_ID
,      STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGC.IGC_CBC_BA_RANGES;

Dependencies

[top of page]

IGC.IGC_CBC_BA_RANGES does not reference any database object

IGC.IGC_CBC_BA_RANGES is referenced by following:

IGC: IGC_CBC_BA_RANGES#