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_ARTICLE_ADOPTIONS

Object Details

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

This table stores the adoption details of a global clause version in any given local operating unit. This table has rows for local operating units only. This stores rows for clause adoptions as AVAILABLE, LOCALIZED and ADOPTED.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_ARTICLE_ADOPTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GLOBAL_ARTICLE_VERSION_ID LOCAL_ORG_ID LOCAL_ARTICLE_VERSION_ID
OKC_ARTICLE_ADOPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCAL_ORG_ID ADOPTION_TYPE
OKC_ARTICLE_ADOPTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCAL_ARTICLE_VERSION_ID LOCAL_ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GLOBAL_ARTICLE_VERSION_ID	NUMBER		Yes	Foreign Key to OKC_ARTICLE_VERSIONS. This references the Global Clause Version which was used for adoption at a Local Operating Unit.
LOCAL_ARTICLE_VERSION_ID	NUMBER			Foreign Key to OKC_ARTICLE_VERSIONS. If a clause has been localized in the local operating unit, this information is stored. It is null for clause adopted 'as-is'
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.
ADOPTION_TYPE	VARCHAR2	(30)	Yes	Adoption Type of the Clause. Localized, Adopted . Foreign Key to FND_LOOKUPS of lookup type OKC_ARTICLE_ADOPTIONS.
LOCAL_ORG_ID	NUMBER		Yes	Refers to the operating unit in which the global clause was adopted as is or localized.
ADOPTION_STATUS	VARCHAR2	(30)		Status of the Adoption of the Clause in the local org e.g. Not Approved, Pending, Approved. Foreign Key to FND_LOOKUPS of Lookup Type OKC_ARTICLE_STATUS.
CREATED_BY	NUMBER		Yes	Standard Who column.
CREATION_DATE	DATE		Yes	Standard Who column.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column.
LAST_UPDATE_LOGIN	NUMBER			Standard Who column.

Query Text

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


SELECT GLOBAL_ARTICLE_VERSION_ID
,      LOCAL_ARTICLE_VERSION_ID
,      OBJECT_VERSION_NUMBER
,      ADOPTION_TYPE
,      LOCAL_ORG_ID
,      ADOPTION_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_ARTICLE_ADOPTIONS;

Dependencies

[top of page]

OKC.OKC_ARTICLE_ADOPTIONS does not reference any database object

OKC.OKC_ARTICLE_ADOPTIONS is referenced by following:

APPS: OKC_ARTICLE_ADOPTIONS