eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OKX_QUOTE_LINE_DETAIL_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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

Query Text

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;

Dependencies

[top of page]

APPS.OKX_QUOTE_LINE_DETAIL_V references the following:

APPS: ASO_QUOTE_LINE_DETAILS

APPS.OKX_QUOTE_LINE_DETAIL_V is referenced by following:

APPS: OKC_OC_INT_CONFIG_PVT - show dependent code; OKC_OC_INT_KTQ_PVT - show dependent code