eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: QP.QP_DEBUG_REQ_LINE_ATTRS#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, LINE_INDEX LINE_INDEX, LINE_DETAIL_INDEX LINE_DETAIL_INDEX, LINE_ATTRIBUTE_ID LINE_ATTRIBUTE_ID, 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 from "QP"."QP_DEBUG_REQ_LINE_ATTRS"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, LINE_INDEX LINE_INDEX
, LINE_DETAIL_INDEX LINE_DETAIL_INDEX
, LINE_ATTRIBUTE_ID LINE_ATTRIBUTE_ID
, 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
FROM "QP"."QP_DEBUG_REQ_LINE_ATTRS"