[Home] [Help] [Dependency Information]
Object Name: | OKE_K_DELIVERABLES_TL |
---|---|
Object Type: | TABLE |
Owner: | OKE |
FND Design Data: | OKE.OKE_K_DELIVERABLES_TL |
Subobject Name: | |
Status: | VALID |
Translatable columns from OKE_K_DELIVERABLES_B, as per MLS standards.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKE_K_DELIVERABLES_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DELIVERABLE_ID
LANGUAGE |
OKE_K_DELIVERABLES_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
K_HEADER_ID
K_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DELIVERABLE_ID | NUMBER | Yes | Contract deliverable unique identifier | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code of current data |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
K_HEADER_ID | NUMBER | Contract document unique identifier | ||
K_LINE_ID | NUMBER | Contract document line item unique identifier | ||
SOURCE_LANG | VARCHAR2 | (4) | Yes | Source language code of current data |
SFWT_FLAG | VARCHAR2 | (3) | Yes | Multi-lingual indicator (not currently used) |
DESCRIPTION | VARCHAR2 | (240) | Description of deliverable | |
COMMENTS | VARCHAR2 | (2000) | User-entered comments |
Cut, paste (and edit) the following text to query this object:
SELECT DELIVERABLE_ID
, LANGUAGE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, K_HEADER_ID
, K_LINE_ID
, SOURCE_LANG
, SFWT_FLAG
, DESCRIPTION
, COMMENTS
FROM OKE.OKE_K_DELIVERABLES_TL;
OKE.OKE_K_DELIVERABLES_TL does not reference any database object
OKE.OKE_K_DELIVERABLES_TL is referenced by following:
|
|
|