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

VIEW: APPS.OKC_STD_ART_INCMPTS_V

Object Details
Object Name: OKC_STD_ART_INCMPTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_STD_ART_INCMPTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Intersection entity (relationship) to record incompatible pairs of STD ARTICLE
ie. it is illogical for instantiations of both (as ARTICLE) to occur related to the same object


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
SAE_ID NUMBER
Yes Foreign key to OKC_STD_ARTICLES_B.
SAE_ID_FOR NUMBER
Yes Surrogate key used for primary unique identifiers.
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 column.
CREATION_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER
Yes Standard Who column.
LAST_UPDATE_DATE DATE
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 ROW_ID
,      SAE_ID
,      SAE_ID_FOR
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_STD_ART_INCMPTS_V;

Dependencies

[top of page]

APPS.OKC_STD_ART_INCMPTS_V references the following:

SchemaAPPS
SynonymOKC_ARTICLE_RELATNS
APPS.OKC_STD_ART_INCMPTS_V is referenced by following:

SchemaAPPS
Package BodyOKC_QA_DATA_INTEGRITY - show dependent code
Package BodyOKC_SAI_PVT - show dependent code
PL/SQL PackageOKC_SAI_PVT - show dependent code