View: OKX_QUOTE_LINE_DETAIL_V

Product:	OKX - Contracts Integration
Description:	Information specific to certain types of quote lines
Implementation/DBA Data:	APPS.OKX_QUOTE_LINE_DETAIL_V

View Text

SELECT LDT.QUOTE_LINE_DETAIL_ID ID1
, '#' ID2
, LDT.QUOTE_LINE_ID QUOTE_LINE_ID
, LDT.COMPONENT_CODE COMPONENT_CODE
, LDT.SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, LDT.SERVICE_DURATION SERVICE_DURATION
, LDT.SERVICE_PERIOD SERVICE_PERIOD
, LDT.SERVICE_UNIT_SELLING_PERCENT SERVICE_UNIT_SELLING_PERCE
, LDT.CONFIG_HEADER_ID
, LDT.SERVICE_UNIT_LIST_PERCENT SERVICE_UNIT_LIST_PERCENT
, LDT.CONFIG_REVISION_NUM
, LDT.CONFIG_ITEM_ID
, LDT.COMPLETE_CONFIGURATION_FLAG
, LDT.VALID_CONFIGURATION_FLAG
, LDT.SERVICE_NUMBER SERVICE_NUMBER
, LDT.UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, 'A' STATUS
, SYSDATE START_DATE_ACTIVE
, TO_DATE(NULL) END_DATE_ACTIVE
, NULL NAME
, NULL DESCRIPTION
, LDT.SERVICE_REF_TYPE_CODE SERVICE_REF_TYPE_CODE
, LDT.SERVICE_REF_SYSTEM_ID SERVICE_REF_SYSTEM_ID
, LDT.SERVICE_REF_LINE_ID SERVICE_REF_LINE_ID
, LDT.SERVICE_REF_LINE_NUMBER SERVICE_REF_LINE_NUMBER
, LDT.SERVICE_REF_ORDER_NUMBER SERVICE_REF_ORDER_NUMBER
FROM ASO_QUOTE_LINE_DETAILS LDT

Columns