[Home] [Help] [Dependency Information]
Object Name: | OKC_K_REL_OBJS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKC.OKC_K_REL_OBJS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
An intersection entity which links Contract Objects (header or line) to other objects in the schema, particularly OE and ASO order related objects
ie.
QUOTE HEADER
QUOTE LINE
QUOTE LINE DETAIL
ORDER HEADER
ORDER LINE
a lookup to relationship type indicates the meaning of the relationship
EXAMPLE
A warranty contract can be generated upon shipment of an order line and it's associated recording in the installed base for a warranted product
the relationship type would be named appropriately
An extended warranty contract or line could be created for an order line buying such a product
An order and lines may be created upon agreement and signing of a contract which specifies the terms for orders and requires shipment to be initiated
MISCELLANEOUS
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
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. |
CLE_ID | NUMBER | Foreign key to OKC_K_LINES_B. | ||
CHR_ID | NUMBER | Foreign key to OKC_K_HEADERS_B. | ||
RTY_CODE | VARCHAR2 | (30) | Yes | QuickCode code. |
OBJECT1_ID1 | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. | |
OBJECT1_ID2 | VARCHAR2 | (200) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. | |
JTOT_OBJECT1_CODE | VARCHAR2 | (30) | Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
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
, CLE_ID
, CHR_ID
, RTY_CODE
, OBJECT1_ID1
, OBJECT1_ID2
, JTOT_OBJECT1_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_K_REL_OBJS_V;
|
|
|