[Home] [Help] [Dependency Information]
Object Name: | OKC_STD_ART_INCMPTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_STD_ART_INCMPTS_V |
Subobject Name: | |
Status: | VALID |
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
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. |
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;
|
|
|