VIEW: QP.QP_INT_LINE_ATTRS_T#

Source

View Text - Preformatted

select LINE_INDEX LINE_INDEX, LINE_DETAIL_INDEX LINE_DETAIL_INDEX, ATTRIBUTE_LEVEL ATTRIBUTE_LEVEL, ATTRIBUTE_TYPE ATTRIBUTE_TYPE, LIST_HEADER_ID LIST_HEADER_ID, LIST_LINE_ID LIST_LINE_ID, CONTEXT CONTEXT, ATTRIBUTE ATTRIBUTE, VALUE_FROM VALUE_FROM, SETUP_VALUE_FROM SETUP_VALUE_FROM, VALUE_TO VALUE_TO, SETUP_VALUE_TO SETUP_VALUE_TO, GROUPING_NUMBER GROUPING_NUMBER, NO_QUALIFIERS_IN_GRP NO_QUALIFIERS_IN_GRP, COMPARISON_OPERATOR_TYPE_CODE COMPARISON_OPERATOR_TYPE_CODE, VALIDATED_FLAG VALIDATED_FLAG, APPLIED_FLAG APPLIED_FLAG, PRICING_STATUS_CODE PRICING_STATUS_CODE, PRICING_STATUS_TEXT PRICING_STATUS_TEXT, QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE, PRICING_ATTR_FLAG PRICING_ATTR_FLAG, QUALIFIER_TYPE QUALIFIER_TYPE, DATATYPE DATATYPE, PRODUCT_UOM_CODE PRODUCT_UOM_CODE, PROCESSED_CODE PROCESSED_CODE, EXCLUDER_FLAG EXCLUDER_FLAG, GROUP_QUANTITY GROUP_QUANTITY, GROUP_AMOUNT GROUP_AMOUNT, DISTINCT_QUALIFIER_FLAG DISTINCT_QUALIFIER_FLAG, PRICING_PHASE_ID PRICING_PHASE_ID, INCOMPATABILITY_GRP_CODE INCOMPATABILITY_GRP_CODE, LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG, REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DERIVED_QUALIFIER_FLAG DERIVED_QUALIFIER_FLAG from "QP"."QP_INT_LINE_ATTRS_T"

View Text - HTML Formatted

SELECT LINE_INDEX LINE_INDEX
, LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, ATTRIBUTE_LEVEL ATTRIBUTE_LEVEL
, ATTRIBUTE_TYPE ATTRIBUTE_TYPE
, LIST_HEADER_ID LIST_HEADER_ID
, LIST_LINE_ID LIST_LINE_ID
, CONTEXT CONTEXT
, ATTRIBUTE ATTRIBUTE
, VALUE_FROM VALUE_FROM
, SETUP_VALUE_FROM SETUP_VALUE_FROM
, VALUE_TO VALUE_TO
, SETUP_VALUE_TO SETUP_VALUE_TO
, GROUPING_NUMBER GROUPING_NUMBER
, NO_QUALIFIERS_IN_GRP NO_QUALIFIERS_IN_GRP
, COMPARISON_OPERATOR_TYPE_CODE COMPARISON_OPERATOR_TYPE_CODE
, VALIDATED_FLAG VALIDATED_FLAG
, APPLIED_FLAG APPLIED_FLAG
, PRICING_STATUS_CODE PRICING_STATUS_CODE
, PRICING_STATUS_TEXT PRICING_STATUS_TEXT
, QUALIFIER_PRECEDENCE QUALIFIER_PRECEDENCE
, PRICING_ATTR_FLAG PRICING_ATTR_FLAG
, QUALIFIER_TYPE QUALIFIER_TYPE
, DATATYPE DATATYPE
, PRODUCT_UOM_CODE PRODUCT_UOM_CODE
, PROCESSED_CODE PROCESSED_CODE
, EXCLUDER_FLAG EXCLUDER_FLAG
, GROUP_QUANTITY GROUP_QUANTITY
, GROUP_AMOUNT GROUP_AMOUNT
, DISTINCT_QUALIFIER_FLAG DISTINCT_QUALIFIER_FLAG
, PRICING_PHASE_ID PRICING_PHASE_ID
, INCOMPATABILITY_GRP_CODE INCOMPATABILITY_GRP_CODE
, LINE_DETAIL_TYPE_CODE LINE_DETAIL_TYPE_CODE
, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG
, REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DERIVED_QUALIFIER_FLAG DERIVED_QUALIFIER_FLAG
FROM "QP"."QP_INT_LINE_ATTRS_T"