View: QP_LISTS_V

Product:	QP - Advanced Pricing
Description:	View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl
Implementation/DBA Data:	APPS.QP_LISTS_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
FROM QP_LIST_HEADERS_VL QPH
, QP_LIST_LINES QPL
WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID

Columns