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: ICX.ICX_CAT_BROWSE_TREES

Object Details

Object Name:	ICX_CAT_BROWSE_TREES
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_CAT_BROWSE_TREES
Subobject Name:
Status:	VALID

Each row in this table holds the parent and child category that defines the category relationship PARENT_CATEGORY_ID holds the category id of parent and CHILD_CATEGORY_ID holds the category id of child.
Root category (RT_CATEGORY_ID as '0') can only be a parent. Only Browsing categories can be the parent categories. Item Categories can only be child categories.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
PARENT_CATEGORY_ID	NUMBER		The Rt Category Id of the parent browsing category. (Reference ICX_CAT_CATEGORIES_TL.RT_CATEGORY_ID)
CHILD_CATEGORY_ID	NUMBER		The Rt Category Id of the child browsing/item category. (Reference ICX_CAT_CATEGORIES_TL.RT_CATEGORY_ID)
LAST_UPDATE_LOGIN	NUMBER		Standard Who column: identifies sign-on audit information of the user who last updated this record. (References FND_LOGINS.login_id.)
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column: the user who last updated this record. (References FND_USERS.user_id.)
LAST_UPDATE_DATE	DATE	Yes	Standard Who column: date when this record was last updated
CREATED_BY	NUMBER	Yes	Standard Who column: the user who created this record. (References FND_USERS.user_id.)
CREATION_DATE	DATE	Yes	Standard Who column: date when this record was created
REQUEST_ID	NUMBER		Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program
PROGRAM_APPLICATION_ID	NUMBER		Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program
PROGRAM_ID	NUMBER		Standard Concurrent Request Column: Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER		Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID

Query Text

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


SELECT PARENT_CATEGORY_ID
,      CHILD_CATEGORY_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
FROM ICX.ICX_CAT_BROWSE_TREES;

Dependencies

[top of page]

ICX.ICX_CAT_BROWSE_TREES does not reference any database object

ICX.ICX_CAT_BROWSE_TREES is referenced by following:

APPS: ICX_CAT_BROWSE_TREES