VIEW: QP.QP_PRICING_ATTRIBUTES#

Source

View Text - Preformatted

select PRICING_ATTRIBUTE_ID PRICING_ATTRIBUTE_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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, LIST_LINE_ID LIST_LINE_ID, EXCLUDER_FLAG EXCLUDER_FLAG, ACCUMULATE_FLAG ACCUMULATE_FLAG, PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE_CONTEXT, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE, PRODUCT_UOM_CODE PRODUCT_UOM_CODE, PRICING_ATTRIBUTE_CONTEXT PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE PRICING_ATTRIBUTE, PRICING_ATTR_VALUE_FROM PRICING_ATTR_VALUE_FROM, PRICING_ATTR_VALUE_TO PRICING_ATTR_VALUE_TO, ATTRIBUTE_GROUPING_NO ATTRIBUTE_GROUPING_NO, PRODUCT_ATTRIBUTE_DATATYPE PRODUCT_ATTRIBUTE_DATATYPE, PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE, COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE, CONTEXT CONTEXT, 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, LIST_HEADER_ID LIST_HEADER_ID, PRICING_PHASE_ID PRICING_PHASE_ID, QUALIFICATION_IND QUALIFICATION_IND, PRICING_ATTR_VALUE_FROM_NUMBER PRICING_ATTR_VALUE_FROM_NUMBER, PRICING_ATTR_VALUE_TO_NUMBER PRICING_ATTR_VALUE_TO_NUMBER, DISTINCT_ROW_COUNT DISTINCT_ROW_COUNT, SEARCH_IND SEARCH_IND, PATTERN_VALUE_FROM_POSITIVE PATTERN_VALUE_FROM_POSITIVE, PATTERN_VALUE_TO_POSITIVE PATTERN_VALUE_TO_POSITIVE, PATTERN_VALUE_FROM_NEGATIVE PATTERN_VALUE_FROM_NEGATIVE, PATTERN_VALUE_TO_NEGATIVE PATTERN_VALUE_TO_NEGATIVE, PRODUCT_SEGMENT_ID PRODUCT_SEGMENT_ID, PRICING_SEGMENT_ID PRICING_SEGMENT_ID, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, ORIG_SYS_PRICING_ATTR_REF ORIG_SYS_PRICING_ATTR_REF, ORIG_SYS_HEADER_REF ORIG_SYS_HEADER_REF from "QP"."QP_PRICING_ATTRIBUTES"

View Text - HTML Formatted

SELECT PRICING_ATTRIBUTE_ID PRICING_ATTRIBUTE_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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, LIST_LINE_ID LIST_LINE_ID
, EXCLUDER_FLAG EXCLUDER_FLAG
, ACCUMULATE_FLAG ACCUMULATE_FLAG
, PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE PRODUCT_UOM_CODE
, PRICING_ATTRIBUTE_CONTEXT PRICING_ATTRIBUTE_CONTEXT
, PRICING_ATTRIBUTE PRICING_ATTRIBUTE
, PRICING_ATTR_VALUE_FROM PRICING_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO PRICING_ATTR_VALUE_TO
, ATTRIBUTE_GROUPING_NO ATTRIBUTE_GROUPING_NO
, PRODUCT_ATTRIBUTE_DATATYPE PRODUCT_ATTRIBUTE_DATATYPE
, PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE
, COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE
, CONTEXT CONTEXT
, 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
, LIST_HEADER_ID LIST_HEADER_ID
, PRICING_PHASE_ID PRICING_PHASE_ID
, QUALIFICATION_IND QUALIFICATION_IND
, PRICING_ATTR_VALUE_FROM_NUMBER PRICING_ATTR_VALUE_FROM_NUMBER
, PRICING_ATTR_VALUE_TO_NUMBER PRICING_ATTR_VALUE_TO_NUMBER
, DISTINCT_ROW_COUNT DISTINCT_ROW_COUNT
, SEARCH_IND SEARCH_IND
, PATTERN_VALUE_FROM_POSITIVE PATTERN_VALUE_FROM_POSITIVE
, PATTERN_VALUE_TO_POSITIVE PATTERN_VALUE_TO_POSITIVE
, PATTERN_VALUE_FROM_NEGATIVE PATTERN_VALUE_FROM_NEGATIVE
, PATTERN_VALUE_TO_NEGATIVE PATTERN_VALUE_TO_NEGATIVE
, PRODUCT_SEGMENT_ID PRODUCT_SEGMENT_ID
, PRICING_SEGMENT_ID PRICING_SEGMENT_ID
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, ORIG_SYS_PRICING_ATTR_REF ORIG_SYS_PRICING_ATTR_REF
, ORIG_SYS_HEADER_REF ORIG_SYS_HEADER_REF
FROM "QP"."QP_PRICING_ATTRIBUTES"