[Home] [Help] [Dependency Information]
Object Name: | OKC_ARTICLE_TRANS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_ARTICLE_TRANS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Intersection entity (relationship) associating an ARTICLE with whatever it is translated to
eg. either RULE or LINE
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | The address of the row in the database | |
ID | NUMBER | Yes | Primary key column. | |
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. |
CAT_ID | NUMBER | Yes | Foreign key to OKC_K_ARTICLES_B. | |
CLE_ID | NUMBER | Foreign key to OKC_K_LINES_B. | ||
RUL_ID | NUMBER | Foreign key to OKC_RULES_B. | ||
DNZ_CHR_ID | NUMBER | Yes | Contract ID. Denormalized for performance. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, CAT_ID
, CLE_ID
, RUL_ID
, DNZ_CHR_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_ARTICLE_TRANS_V;
|
|
|