VIEW: ASO.ASO_QUOTE_LINE_DETAILS#

Source

View Text - Preformatted

select QUOTE_LINE_DETAIL_ID QUOTE_LINE_DETAIL_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, QUOTE_LINE_ID QUOTE_LINE_ID, CONFIG_HEADER_ID CONFIG_HEADER_ID, CONFIG_REVISION_NUM CONFIG_REVISION_NUM, CONFIG_ITEM_ID CONFIG_ITEM_ID, COMPLETE_CONFIGURATION_FLAG COMPLETE_CONFIGURATION_FLAG, VALID_CONFIGURATION_FLAG VALID_CONFIGURATION_FLAG, COMPONENT_CODE COMPONENT_CODE, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG, SERVICE_DURATION SERVICE_DURATION, SERVICE_PERIOD SERVICE_PERIOD, SERVICE_UNIT_SELLING_PERCENT SERVICE_UNIT_SELLING_PERCENT, SERVICE_UNIT_LIST_PERCENT SERVICE_UNIT_LIST_PERCENT, SERVICE_NUMBER SERVICE_NUMBER, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SERVICE_REF_TYPE_CODE SERVICE_REF_TYPE_CODE, SERVICE_REF_ORDER_NUMBER SERVICE_REF_ORDER_NUMBER, SERVICE_REF_LINE_NUMBER SERVICE_REF_LINE_NUMBER, SERVICE_REF_LINE_ID SERVICE_REF_LINE_ID, SERVICE_REF_SYSTEM_ID SERVICE_REF_SYSTEM_ID, SERVICE_REF_OPTION_NUMB SERVICE_REF_OPTION_NUMB, SERVICE_REF_SHIPMENT_NUMB SERVICE_REF_SHIPMENT_NUMB, RETURN_REF_TYPE RETURN_REF_TYPE, RETURN_REF_HEADER_ID RETURN_REF_HEADER_ID, RETURN_REF_LINE_ID RETURN_REF_LINE_ID, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15, RETURN_REASON_CODE RETURN_REASON_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REF_TYPE_CODE REF_TYPE_CODE, REF_LINE_ID REF_LINE_ID, INSTANCE_ID INSTANCE_ID, BOM_SORT_ORDER BOM_SORT_ORDER, CONFIG_DELTA CONFIG_DELTA, CONFIG_INSTANCE_NAME CONFIG_INSTANCE_NAME, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, ATO_LINE_ID ATO_LINE_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20 from "ASO"."ASO_QUOTE_LINE_DETAILS"

View Text - HTML Formatted

SELECT QUOTE_LINE_DETAIL_ID QUOTE_LINE_DETAIL_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUOTE_LINE_ID QUOTE_LINE_ID
, CONFIG_HEADER_ID CONFIG_HEADER_ID
, CONFIG_REVISION_NUM CONFIG_REVISION_NUM
, CONFIG_ITEM_ID CONFIG_ITEM_ID
, COMPLETE_CONFIGURATION_FLAG COMPLETE_CONFIGURATION_FLAG
, VALID_CONFIGURATION_FLAG VALID_CONFIGURATION_FLAG
, COMPONENT_CODE COMPONENT_CODE
, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, SERVICE_DURATION SERVICE_DURATION
, SERVICE_PERIOD SERVICE_PERIOD
, SERVICE_UNIT_SELLING_PERCENT SERVICE_UNIT_SELLING_PERCENT
, SERVICE_UNIT_LIST_PERCENT SERVICE_UNIT_LIST_PERCENT
, SERVICE_NUMBER SERVICE_NUMBER
, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SERVICE_REF_TYPE_CODE SERVICE_REF_TYPE_CODE
, SERVICE_REF_ORDER_NUMBER SERVICE_REF_ORDER_NUMBER
, SERVICE_REF_LINE_NUMBER SERVICE_REF_LINE_NUMBER
, SERVICE_REF_LINE_ID SERVICE_REF_LINE_ID
, SERVICE_REF_SYSTEM_ID SERVICE_REF_SYSTEM_ID
, SERVICE_REF_OPTION_NUMB SERVICE_REF_OPTION_NUMB
, SERVICE_REF_SHIPMENT_NUMB SERVICE_REF_SHIPMENT_NUMB
, RETURN_REF_TYPE RETURN_REF_TYPE
, RETURN_REF_HEADER_ID RETURN_REF_HEADER_ID
, RETURN_REF_LINE_ID RETURN_REF_LINE_ID
, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9
, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15
, RETURN_REASON_CODE RETURN_REASON_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REF_TYPE_CODE REF_TYPE_CODE
, REF_LINE_ID REF_LINE_ID
, INSTANCE_ID INSTANCE_ID
, BOM_SORT_ORDER BOM_SORT_ORDER
, CONFIG_DELTA CONFIG_DELTA
, CONFIG_INSTANCE_NAME CONFIG_INSTANCE_NAME
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, ATO_LINE_ID ATO_LINE_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
FROM "ASO"."ASO_QUOTE_LINE_DETAILS"