DBA Data[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_STD_ART_INCMPTS

Object Details
Object Name: OKC_STD_ART_INCMPTS
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_STD_ART_INCMPTS
Subobject Name:
Status: VALID


STANDARD ARTICLE INCOMPATIBILITIES registers incompatiblities between standard articles. For example, a company may have several limitation of liability clauses to be used in different situations. It would not be correct to include more than one of them in the same contract, so these standard articles would be marked as incompatible.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKC_STD_ART_INCMPTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSAE_ID
ColumnSAE_ID_FOR
OKC_STD_ART_INCMPTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSAE_ID_FOR
Columns
Name Datatype Length Mandatory Comments
SAE_ID NUMBER
Yes Id of the standard article
SAE_ID_FOR NUMBER
Yes Id of the standard article which is incompatible to article ID listed in SAE_ID in this table
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
CREATED_BY NUMBER (15) Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT SAE_ID
,      SAE_ID_FOR
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM OKC.OKC_STD_ART_INCMPTS;

Dependencies

[top of page]

OKC.OKC_STD_ART_INCMPTS does not reference any database object

OKC.OKC_STD_ART_INCMPTS is referenced by following:

SchemaAPPS
SynonymOKC_STD_ART_INCMPTS