VIEW: APPS.OKX_QUOTE_LINE_DETAIL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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