[Home] [Help] [Dependency Information]
Object Name: | OKX_QUOTE_LINE_DETAIL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_QUOTE_LINE_DETAIL_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | NUMBER | Yes | Quote line detail identifier | |
ID2 | CHAR | (1) | (Multi-part) Primary Key | |
QUOTE_LINE_ID | NUMBER | Yes | Quote line identifier | |
COMPONENT_CODE | VARCHAR2 | (1200) | Concatenation of component item ids | |
SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | Cotermination indicator for service order lines | |
SERVICE_DURATION | NUMBER | Duration for which the product is serviced | ||
SERVICE_PERIOD | VARCHAR2 | (3) | Period for which the product is serviced. | |
SERVICE_UNIT_SELLING_PERCE | NUMBER | Percent actually charged to customer (percent based pricing only) | ||
CONFIG_HEADER_ID | NUMBER | Configuration header id | ||
SERVICE_UNIT_LIST_PERCENT | NUMBER | Price list percent of the item (percent based pricing only) | ||
CONFIG_REVISION_NUM | NUMBER | Configuration revision number | ||
CONFIG_ITEM_ID | NUMBER | Unique identifier for a configured item in CZ table. | ||
COMPLETE_CONFIGURATION_FLAG | VARCHAR2 | (1) | Value is set to 'Y' if configuration is complete | |
VALID_CONFIGURATION_FLAG | VARCHAR2 | (1) | Value set to 'Y' if configuration is valid | |
SERVICE_NUMBER | NUMBER | service number | ||
UNIT_PERCENT_BASE_PRICE | NUMBER | Base price used for percent based pricing | ||
STATUS | CHAR | (1) | Status | |
START_DATE_ACTIVE | DATE | Start date active | ||
END_DATE_ACTIVE | DATE | End date active | ||
NAME | VARCHAR2 | (0) | Quote line detail name | |
DESCRIPTION | VARCHAR2 | (0) | Description | |
SERVICE_REF_TYPE_CODE | VARCHAR2 | (30) | type of object to which the service is linked | |
SERVICE_REF_SYSTEM_ID | NUMBER | system id | ||
SERVICE_REF_LINE_ID | NUMBER | line id of the line to which the service is linked if the service reference is ORDER or QUOTE | ||
SERVICE_REF_LINE_NUMBER | NUMBER | line number if the service reference is ORDER | ||
SERVICE_REF_ORDER_NUMBER | NUMBER | order number if the service reference is ORDER |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, QUOTE_LINE_ID
, COMPONENT_CODE
, SERVICE_COTERMINATE_FLAG
, SERVICE_DURATION
, SERVICE_PERIOD
, SERVICE_UNIT_SELLING_PERCE
, CONFIG_HEADER_ID
, SERVICE_UNIT_LIST_PERCENT
, CONFIG_REVISION_NUM
, CONFIG_ITEM_ID
, COMPLETE_CONFIGURATION_FLAG
, VALID_CONFIGURATION_FLAG
, SERVICE_NUMBER
, UNIT_PERCENT_BASE_PRICE
, STATUS
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, NAME
, DESCRIPTION
, SERVICE_REF_TYPE_CODE
, SERVICE_REF_SYSTEM_ID
, SERVICE_REF_LINE_ID
, SERVICE_REF_LINE_NUMBER
, SERVICE_REF_ORDER_NUMBER
FROM APPS.OKX_QUOTE_LINE_DETAIL_V;
|
|
|