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: OKC.OKC_FOLDER_CONTENTS

Object Details

Object Name:	OKC_FOLDER_CONTENTS
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_FOLDER_CONTENTS
Subobject Name:
Status:	VALID

This table stores the clauses associated to a folder. This replaces the table OKC_STD_ART_SET_MEMS used in releases prior to 11.5.10.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_FOLDER_CONTENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FOLDER_ID MEMBER_ID
OKC_FOLDER_CONTENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MEMBER_ID

Columns

Name	Datatype	Mandatory	Comments
MEMBER_ID	NUMBER	Yes	The Clause Id. Foreign Key to OKC_ARTICLES_ALL.
FOLDER_ID	NUMBER	Yes	The Folder Id. Foreign Key to OKC_FOLDERS_ALL_B.
OBJECT_VERSION_NUMBER	NUMBER	Yes	Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
CREATED_BY	NUMBER	Yes	Standard Who Columns.
CREATION_DATE	DATE	Yes	Standard Who Columns.
LAST_UPDATE_DATE	DATE	Yes	Standard Who Columns.
LAST_UPDATED_BY	NUMBER	Yes	Standard Who Columns.
LAST_UPDATE_LOGIN	NUMBER		Standard Who Columns.

Query Text

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


SELECT MEMBER_ID
,      FOLDER_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_FOLDER_CONTENTS;

Dependencies

[top of page]

OKC.OKC_FOLDER_CONTENTS does not reference any database object

OKC.OKC_FOLDER_CONTENTS is referenced by following:

APPS: OKC_FOLDER_CONTENTS