VIEW: APPS.QP_INT_LINE_ATTRS

Source

View Text - Preformatted

SELECT QPT.LINE_INDEX,QPT.LINE_DETAIL_INDEX,QPT.ATTRIBUTE_LEVEL,QPT.ATTRIBUTE_TYPE,QPT.LIST_HEADER_ID,QPT.LIST_LINE_ID,QPT.CONTEXT,QPT.ATTRIBUTE,QPT.VALUE_FROM,QPT.SETUP_VALUE_FROM,QPT.VALUE_TO,QPT.SETUP_VALUE_TO,QPT.GROUPING_NUMBER,QPT.NO_QUALIFIERS_IN_GRP,QPT.COMPARISON_OPERATOR_TYPE_CODE,QPT.VALIDATED_FLAG,QPT.APPLIED_FLAG,QPT.PRICING_STATUS_CODE,QPT.PRICING_STATUS_TEXT,QPT.QUALIFIER_PRECEDENCE,QPT.PRICING_ATTR_FLAG,QPT.QUALIFIER_TYPE,QPT.DATATYPE,QPT.PRODUCT_UOM_CODE,QPT.PROCESSED_CODE,QPT.EXCLUDER_FLAG,QPT.GROUP_QUANTITY,QPT.GROUP_AMOUNT,QPT.DISTINCT_QUALIFIER_FLAG,QPT.PRICING_PHASE_ID,QPT.INCOMPATABILITY_GRP_CODE,QPT.LINE_DETAIL_TYPE_CODE,QPT.MODIFIER_LEVEL_CODE,QPT.PRIMARY_UOM_FLAG,QPT.REQUEST_ID,QPT.DERIVED_QUALIFIER_FLAG FROM QP_INT_LINE_ATTRS_T QPT WHERE REQUEST_ID = nvl(SYS_CONTEXT('QP_CONTEXT','REQUEST_ID'),-9999)

View Text - HTML Formatted

SELECT QPT.LINE_INDEX
, QPT.LINE_DETAIL_INDEX
, QPT.ATTRIBUTE_LEVEL
, QPT.ATTRIBUTE_TYPE
, QPT.LIST_HEADER_ID
, QPT.LIST_LINE_ID
, QPT.CONTEXT
, QPT.ATTRIBUTE
, QPT.VALUE_FROM
, QPT.SETUP_VALUE_FROM
, QPT.VALUE_TO
, QPT.SETUP_VALUE_TO
, QPT.GROUPING_NUMBER
, QPT.NO_QUALIFIERS_IN_GRP
, QPT.COMPARISON_OPERATOR_TYPE_CODE
, QPT.VALIDATED_FLAG
, QPT.APPLIED_FLAG
, QPT.PRICING_STATUS_CODE
, QPT.PRICING_STATUS_TEXT
, QPT.QUALIFIER_PRECEDENCE
, QPT.PRICING_ATTR_FLAG
, QPT.QUALIFIER_TYPE
, QPT.DATATYPE
, QPT.PRODUCT_UOM_CODE
, QPT.PROCESSED_CODE
, QPT.EXCLUDER_FLAG
, QPT.GROUP_QUANTITY
, QPT.GROUP_AMOUNT
, QPT.DISTINCT_QUALIFIER_FLAG
, QPT.PRICING_PHASE_ID
, QPT.INCOMPATABILITY_GRP_CODE
, QPT.LINE_DETAIL_TYPE_CODE
, QPT.MODIFIER_LEVEL_CODE
, QPT.PRIMARY_UOM_FLAG
, QPT.REQUEST_ID
, QPT.DERIVED_QUALIFIER_FLAG
FROM QP_INT_LINE_ATTRS_T QPT
WHERE REQUEST_ID = NVL(SYS_CONTEXT('QP_CONTEXT'
, 'REQUEST_ID')
, -9999)