[Home] [Help] [Dependency Information]
Object Name: | OKS_K_ORDER_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
COD_TYPE | VARCHAR2 | (3) | Yes | |
LINK_ORDER_HEADER_ID | NUMBER | |||
ORDER_LINE_ID1 | VARCHAR2 | (40) | Yes | |
ORDER_LINE_ID2 | VARCHAR2 | (40) | Yes | |
APPLY_ALL_YN | VARCHAR2 | (3) | Yes | |
RENEWAL_TYPE | VARCHAR2 | (3) | ||
LINE_RENEWAL_TYPE | VARCHAR2 | (3) | Yes | |
END_DATE | DATE | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
PO_REQUIRED_YN | VARCHAR2 | (3) | ||
RENEWAL_PRICING_TYPE | VARCHAR2 | (3) | ||
MARKUP_PERCENT | NUMBER | |||
PRICE_LIST_ID1 | VARCHAR2 | (40) | ||
PRICE_LIST_ID2 | VARCHAR2 | (40) | ||
LINK_ORD_LINE_ID1 | VARCHAR2 | (40) | ||
LINK_ORD_LINE_ID2 | VARCHAR2 | (40) | ||
LINK_CHR_ID | NUMBER | |||
LINK_CLE_ID | NUMBER | |||
CHR_ID | NUMBER | |||
CLE_ID | NUMBER | |||
COD_ID | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
CONTACT_ID | NUMBER | |||
SITE_ID | NUMBER | |||
EMAIL_ID | NUMBER | |||
PHONE_ID | NUMBER | |||
FAX_ID | NUMBER | |||
BILLING_PROFILE_ID | NUMBER | |||
RENEWAL_APPROVAL_FLAG | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, COD_TYPE
, LINK_ORDER_HEADER_ID
, ORDER_LINE_ID1
, ORDER_LINE_ID2
, APPLY_ALL_YN
, RENEWAL_TYPE
, LINE_RENEWAL_TYPE
, END_DATE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PO_REQUIRED_YN
, RENEWAL_PRICING_TYPE
, MARKUP_PERCENT
, PRICE_LIST_ID1
, PRICE_LIST_ID2
, LINK_ORD_LINE_ID1
, LINK_ORD_LINE_ID2
, LINK_CHR_ID
, LINK_CLE_ID
, CHR_ID
, CLE_ID
, COD_ID
, SECURITY_GROUP_ID
, CONTACT_ID
, SITE_ID
, EMAIL_ID
, PHONE_ID
, FAX_ID
, BILLING_PROFILE_ID
, RENEWAL_APPROVAL_FLAG
FROM OKS.OKS_K_ORDER_DETAILS#;
|
|
|