View: QP_LIST_ATTRIBUTES_V

Product:	QP - Advanced Pricing
Description:	View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns
Implementation/DBA Data:	APPS.QP_LIST_ATTRIBUTES_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.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.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
, QPPA.PRICING_ATTRIBUTE_ID
, QPPA.EXCLUDER_FLAG
, QPPA.ACCUMULATE_FLAG
, QPPA.PRODUCT_ATTRIBUTE_CONTEXT
, QPPA.PRODUCT_ATTRIBUTE
, QPPA.PRODUCT_ATTR_VALUE
, QPPA.PRODUCT_UOM_CODE
, QPPA.PRICING_ATTRIBUTE_CONTEXT
, QPPA.PRICING_ATTRIBUTE
, QPPA.PRICING_ATTR_VALUE_FROM
, QPPA.PRICING_ATTR_VALUE_TO
, QPPA.ATTRIBUTE_GROUPING_NO
, QPPA.PRODUCT_ATTRIBUTE_DATATYPE
, QPPA.PRICING_ATTRIBUTE_DATATYPE
, QPL.COMMENTS
FROM QP_LIST_HEADERS_VL QPH
, QP_LIST_LINES QPL
, QP_PRICING_ATTRIBUTES QPPA
WHERE QPPA.LIST_LINE_ID(+) = QPL.LIST_LINE_ID
AND QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID

Columns