View: QP_LINE_LVL_QUAL_V

Product:	QP - Advanced Pricing
Description:	View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual
Implementation/DBA Data:	APPS.QP_LINE_LVL_QUAL_V

View Text

SELECT QPH.ROW_ID ROW_ID
, QPH.CURRENCY_CODE
, QPH.SHIP_METHOD_CODE
, QPH.FREIGHT_TERMS_CODE
, QPH.LIST_HEADER_ID
, QPH.CREATION_DATE
, QPH.START_DATE_ACTIVE QPH_START_DATE_ACTIVE
, QPH.END_DATE_ACTIVE QPH_END_DATE_ACTIVE
, QPH.LIST_TYPE_CODE
, QPH.TERMS_ID
, QPH.ROUNDING_FACTOR
, QPH.DISCOUNT_LINES_FLAG
, QPH.NAME
, QPH.DESCRIPTION
, QPH.VERSION_NO
, QPH.COMMENTS
, QPH.GSA_INDICATOR
, QPH.PRORATE_FLAG
, QPH.SOURCE_SYSTEM_CODE
, QPH.ACTIVE_FLAG
, QPH.PARENT_LIST_HEADER_ID
, QPH.START_DATE_ACTIVE_FIRST
, QPH.END_DATE_ACTIVE_FIRST
, QPH.ACTIVE_DATE_FIRST_TYPE
, QPH.START_DATE_ACTIVE_SECOND
, QPH.END_DATE_ACTIVE_SECOND
, QPH.ACTIVE_DATE_SECOND_TYPE
, QPH.ASK_FOR_FLAG
, QPL.LIST_LINE_ID
, QPL.LIST_LINE_TYPE_CODE
, QPL.AUTOMATIC_FLAG
, QPL.MODIFIER_LEVEL_CODE
, QPL.LIST_PRICE
, QPL.PRIMARY_UOM_FLAG
, QPL.INVENTORY_ITEM_ID
, QPL.ORGANIZATION_ID
, QPL.RELATED_ITEM_ID
, QPL.RELATIONSHIP_TYPE_ID
, QPL.SUBSTITUTION_CONTEXT
, QPL.SUBSTITUTION_ATTRIBUTE
, QPL.SUBSTITUTION_VALUE
, QPL.REVISION
, QPL.REVISION_DATE
, QPL.REVISION_REASON_CODE
, QPL.PRICE_BREAK_TYPE_CODE
, QPL.PERCENT_PRICE
, QPL.PRICE_BY_FORMULA_ID
, QPL.NUMBER_EFFECTIVE_PERIODS
, QPL.EFFECTIVE_PERIOD_UOM
, QPL.ARITHMETIC_OPERATOR
, QPL.OPERAND
, QPL.OVERRIDE_FLAG
, QPL.PRINT_ON_INVOICE_FLAG
, QPL.REBATE_TRANSACTION_TYPE_CODE
, QPL.BASE_QTY
, QPL.BASE_UOM_CODE
, QPL.ACCRUAL_QTY
, QPL.ACCRUAL_UOM_CODE
, QPL.ESTIM_ACCRUAL_RATE
, QPL.GENERATE_USING_FORMULA_ID
, QPL.START_DATE_ACTIVE QPL_START_DATE_ACTIVE
, QPL.END_DATE_ACTIVE QPL_END_DATE_ACTIVE
, QPL.REPRICE_FLAG
, QPL.ACCRUAL_FLAG
, QPL.PRICING_GROUP_SEQUENCE
, QPL.INCOMPATIBILITY_GRP_CODE
, QPL.LIST_LINE_NO
, QPL.PRICING_PHASE_ID
, QPL.PRODUCT_PRECEDENCE
, QPL.LIST_PRICE_UOM_CODE
, QPL.EXPIRATION_PERIOD_START_DATE
, QPL.NUMBER_EXPIRATION_PERIODS
, QPL.EXPIRATION_PERIOD_UOM
, QPL.EXPIRATION_DATE
, QPQ.QUALIFIER_ID
, QPQ.EXCLUDER_FLAG
, QPQ.COMPARISON_OPERATOR_CODE
, QPQ.QUALIFIER_CONTEXT
, QPQ.QUALIFIER_ATTRIBUTE
, QPQ.QUALIFIER_RULE_ID
, QPQ.QUALIFIER_GROUPING_NO
, QPQ.QUALIFIER_ATTR_VALUE
, QPQ.CREATED_FROM_RULE_ID
, QPQ.START_DATE_ACTIVE QPQ_START_DATE_ACTIVE
, QPQ.END_DATE_ACTIVE QPQ_END_DATE_ACTIVE
, QPQ.QUALIFIER_DATATYPE
, QPQ.QUALIFIER_PRECEDENCE
, QPQ.QUALIFIER_ATTR_VALUE_TO
FROM QP_LIST_HEADERS_VL QPH
, QP_LIST_LINES QPL
, QP_QUALIFIERS QPQ
WHERE QPL.LIST_LINE_ID = QPQ.LIST_LINE_ID
AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID
AND QPQ.LIST_HEADER_ID = QPL.LIST_HEADER_ID

Columns