VIEW: APPS.QP_ARCH_LIST_LINES_V

Source

View Text - Preformatted

SELECT QPALL.ROWID, QPALL.LIST_LINE_ID, QPALL.CREATION_DATE, QPALL.CREATED_BY, QPALL.LAST_UPDATE_DATE, QPALL.LAST_UPDATED_BY, QPALL.LAST_UPDATE_LOGIN, QPALL.PROGRAM_APPLICATION_ID, QPALL.PROGRAM_ID, QPALL.PROGRAM_UPDATE_DATE, QPALL.REQUEST_ID, QPALL.LIST_HEADER_ID, QPAPR.LIST_HEADER_ID, QPAPR.PRODUCT_ATTRIBUTE_CONTEXT, QPAPR.PRODUCT_ATTRIBUTE, QPAPR.PRODUCT_ATTR_VALUE, QPAPR.PRODUCT_UOM_CODE, QPALL.LIST_PRICE, QPALL.PERCENT_PRICE, QPALL.PRICE_BY_FORMULA_ID, QPALL.START_DATE_ACTIVE, QPALL.END_DATE_ACTIVE, QPALL.CONTEXT, QPALL.ATTRIBUTE1, QPALL.ATTRIBUTE2, QPALL.ATTRIBUTE3, QPALL.ATTRIBUTE4, QPALL.ATTRIBUTE5, QPALL.ATTRIBUTE6, QPALL.ATTRIBUTE7, QPALL.ATTRIBUTE8, QPALL.ATTRIBUTE9, QPALL.ATTRIBUTE10, QPALL.ATTRIBUTE11, QPALL.ATTRIBUTE12, QPALL.ATTRIBUTE13, QPALL.ATTRIBUTE14, QPALL.ATTRIBUTE15, QPALL.PRIMARY_UOM_FLAG, QPALL.REVISION, QPALL.REVISION_DATE, QPALL.REVISION_REASON_CODE, QPALL.COMMENTS, QPALL.LIST_LINE_TYPE_CODE, QPALL.AUTOMATIC_FLAG, QPALL.MODIFIER_LEVEL_CODE, QPALL.LIST_PRICE_UOM_CODE, QPALL.INVENTORY_ITEM_ID, QPALL.ORGANIZATION_ID, QPALL.RELATED_ITEM_ID, QPALL.NUMBER_EFFECTIVE_PERIODS, QPALL.EFFECTIVE_PERIOD_UOM, QPALL.ARITHMETIC_OPERATOR, QPALL.INCOMPATIBILITY_GRP_CODE, QPALL.LIST_LINE_NO, QPALL.PRICING_GROUP_SEQUENCE, QPALL.RELATIONSHIP_TYPE_ID, QPALL.SUBSTITUTION_CONTEXT, QPALL.SUBSTITUTION_ATTRIBUTE, QPALL.SUBSTITUTION_VALUE, QPALL.PRICE_BREAK_TYPE_CODE, QPALL.OPERAND, QPALL.OVERRIDE_FLAG, QPALL.PRINT_ON_INVOICE_FLAG, QPALL.REBATE_TRANSACTION_TYPE_CODE, QPALL.BASE_QTY, QPALL.BASE_UOM_CODE, QPALL.ACCRUAL_QTY, QPALL.ACCRUAL_UOM_CODE, QPALL.ESTIM_ACCRUAL_RATE, QPALL.GENERATE_USING_FORMULA_ID, QPALL.ACCRUAL_FLAG, QPALL.REPRICE_FLAG, QPALL.PRICING_PHASE_ID, QPALL.PRODUCT_PRECEDENCE, QPALL.CUSTOMER_ITEM_ID, QPAPR.PRICING_ATTRIBUTE_CONTEXT, QPAPR.PRICING_ATTRIBUTE, QPAPR.PRICING_ATTR_VALUE_FROM, QPAPR.PRICING_ATTR_VALUE_TO, QP_PRICE_LIST_LINE_UTIL.Get_Product_Value('QP_ATTR_DEFNS_PRICING', QPAPR.Product_Attribute_Context, QPAPR.Product_Attribute, QPAPR.Product_Attr_Value), decode(upper(QPAPR.Product_Attr_value),'ALL',Null,QPAPR.Product_Attr_Value), QPAPR.PRICING_ATTRIBUTE_ID, QPAPR.PRODUCT_ATTRIBUTE_DATATYPE, QPAPR.PRICING_ATTRIBUTE_DATATYPE, QPAPR.COMPARISON_OPERATOR_CODE, QPAPR.LIST_LINE_ID, QPAPR.creation_date, QPAPR.created_by, QPAPR.last_update_date, QPAPR.last_updated_by, QPAPR.last_update_login, QPAPR.program_application_id, QPAPR.program_id, QPAPR.program_update_date, QPAPR.request_id, QPAPR.context, QPAPR.attribute1, QPAPR.attribute2, QPAPR.attribute3, QPAPR.attribute4, QPAPR.attribute5, QPAPR.attribute6, QPAPR.attribute7, QPAPR.attribute8, QPAPR.attribute9, QPAPR.attribute10, QPAPR.attribute11, QPAPR.attribute12, QPAPR.attribute13, QPAPR.attribute14, QPAPR.attribute15, QPALL.BREAK_UOM_CODE, QPALL.BREAK_UOM_CONTEXT, QPALL.BREAK_UOM_ATTRIBUTE, QPALL.ARCH_PURG_REQUEST_ID, QPALL.CONTINUOUS_PRICE_BREAK_FLAG FROM QP_ARCH_LIST_LINES QPALL, QP_ARCH_PRICING_ATTRIBUTES QPAPR WHERE QPAPR.LIST_LINE_ID = QPALL.LIST_LINE_ID AND QPAPR.ARCH_PURG_REQUEST_ID = QPALL.ARCH_PURG_REQUEST_ID AND QPALL.LIST_LINE_TYPE_CODE IN ('PLL', 'PBH') AND QPAPR.PRICING_PHASE_ID = 1 AND QPAPR.QUALIFICATION_IND in (4,6,20,22) AND QPALL.PRICING_PHASE_ID = 1 AND QPALL.QUALIFICATION_IND in (4,6,20,22) AND qpapr.pricing_attribute_context is null

View Text - HTML Formatted

SELECT QPALL.ROWID
, QPALL.LIST_LINE_ID
, QPALL.CREATION_DATE
, QPALL.CREATED_BY
, QPALL.LAST_UPDATE_DATE
, QPALL.LAST_UPDATED_BY
, QPALL.LAST_UPDATE_LOGIN
, QPALL.PROGRAM_APPLICATION_ID
, QPALL.PROGRAM_ID
, QPALL.PROGRAM_UPDATE_DATE
, QPALL.REQUEST_ID
, QPALL.LIST_HEADER_ID
, QPAPR.LIST_HEADER_ID
, QPAPR.PRODUCT_ATTRIBUTE_CONTEXT
, QPAPR.PRODUCT_ATTRIBUTE
, QPAPR.PRODUCT_ATTR_VALUE
, QPAPR.PRODUCT_UOM_CODE
, QPALL.LIST_PRICE
, QPALL.PERCENT_PRICE
, QPALL.PRICE_BY_FORMULA_ID
, QPALL.START_DATE_ACTIVE
, QPALL.END_DATE_ACTIVE
, QPALL.CONTEXT
, QPALL.ATTRIBUTE1
, QPALL.ATTRIBUTE2
, QPALL.ATTRIBUTE3
, QPALL.ATTRIBUTE4
, QPALL.ATTRIBUTE5
, QPALL.ATTRIBUTE6
, QPALL.ATTRIBUTE7
, QPALL.ATTRIBUTE8
, QPALL.ATTRIBUTE9
, QPALL.ATTRIBUTE10
, QPALL.ATTRIBUTE11
, QPALL.ATTRIBUTE12
, QPALL.ATTRIBUTE13
, QPALL.ATTRIBUTE14
, QPALL.ATTRIBUTE15
, QPALL.PRIMARY_UOM_FLAG
, QPALL.REVISION
, QPALL.REVISION_DATE
, QPALL.REVISION_REASON_CODE
, QPALL.COMMENTS
, QPALL.LIST_LINE_TYPE_CODE
, QPALL.AUTOMATIC_FLAG
, QPALL.MODIFIER_LEVEL_CODE
, QPALL.LIST_PRICE_UOM_CODE
, QPALL.INVENTORY_ITEM_ID
, QPALL.ORGANIZATION_ID
, QPALL.RELATED_ITEM_ID
, QPALL.NUMBER_EFFECTIVE_PERIODS
, QPALL.EFFECTIVE_PERIOD_UOM
, QPALL.ARITHMETIC_OPERATOR
, QPALL.INCOMPATIBILITY_GRP_CODE
, QPALL.LIST_LINE_NO
, QPALL.PRICING_GROUP_SEQUENCE
, QPALL.RELATIONSHIP_TYPE_ID
, QPALL.SUBSTITUTION_CONTEXT
, QPALL.SUBSTITUTION_ATTRIBUTE
, QPALL.SUBSTITUTION_VALUE
, QPALL.PRICE_BREAK_TYPE_CODE
, QPALL.OPERAND
, QPALL.OVERRIDE_FLAG
, QPALL.PRINT_ON_INVOICE_FLAG
, QPALL.REBATE_TRANSACTION_TYPE_CODE
, QPALL.BASE_QTY
, QPALL.BASE_UOM_CODE
, QPALL.ACCRUAL_QTY
, QPALL.ACCRUAL_UOM_CODE
, QPALL.ESTIM_ACCRUAL_RATE
, QPALL.GENERATE_USING_FORMULA_ID
, QPALL.ACCRUAL_FLAG
, QPALL.REPRICE_FLAG
, QPALL.PRICING_PHASE_ID
, QPALL.PRODUCT_PRECEDENCE
, QPALL.CUSTOMER_ITEM_ID
, QPAPR.PRICING_ATTRIBUTE_CONTEXT
, QPAPR.PRICING_ATTRIBUTE
, QPAPR.PRICING_ATTR_VALUE_FROM
, QPAPR.PRICING_ATTR_VALUE_TO
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QPAPR.PRODUCT_ATTRIBUTE_CONTEXT
, QPAPR.PRODUCT_ATTRIBUTE
, QPAPR.PRODUCT_ATTR_VALUE)
, DECODE(UPPER(QPAPR.PRODUCT_ATTR_VALUE)
, 'ALL'
, NULL
, QPAPR.PRODUCT_ATTR_VALUE)
, QPAPR.PRICING_ATTRIBUTE_ID
, QPAPR.PRODUCT_ATTRIBUTE_DATATYPE
, QPAPR.PRICING_ATTRIBUTE_DATATYPE
, QPAPR.COMPARISON_OPERATOR_CODE
, QPAPR.LIST_LINE_ID
, QPAPR.CREATION_DATE
, QPAPR.CREATED_BY
, QPAPR.LAST_UPDATE_DATE
, QPAPR.LAST_UPDATED_BY
, QPAPR.LAST_UPDATE_LOGIN
, QPAPR.PROGRAM_APPLICATION_ID
, QPAPR.PROGRAM_ID
, QPAPR.PROGRAM_UPDATE_DATE
, QPAPR.REQUEST_ID
, QPAPR.CONTEXT
, QPAPR.ATTRIBUTE1
, QPAPR.ATTRIBUTE2
, QPAPR.ATTRIBUTE3
, QPAPR.ATTRIBUTE4
, QPAPR.ATTRIBUTE5
, QPAPR.ATTRIBUTE6
, QPAPR.ATTRIBUTE7
, QPAPR.ATTRIBUTE8
, QPAPR.ATTRIBUTE9
, QPAPR.ATTRIBUTE10
, QPAPR.ATTRIBUTE11
, QPAPR.ATTRIBUTE12
, QPAPR.ATTRIBUTE13
, QPAPR.ATTRIBUTE14
, QPAPR.ATTRIBUTE15
, QPALL.BREAK_UOM_CODE
, QPALL.BREAK_UOM_CONTEXT
, QPALL.BREAK_UOM_ATTRIBUTE
, QPALL.ARCH_PURG_REQUEST_ID
, QPALL.CONTINUOUS_PRICE_BREAK_FLAG
FROM QP_ARCH_LIST_LINES QPALL
, QP_ARCH_PRICING_ATTRIBUTES QPAPR
WHERE QPAPR.LIST_LINE_ID = QPALL.LIST_LINE_ID
AND QPAPR.ARCH_PURG_REQUEST_ID = QPALL.ARCH_PURG_REQUEST_ID
AND QPALL.LIST_LINE_TYPE_CODE IN ('PLL'
, 'PBH')
AND QPAPR.PRICING_PHASE_ID = 1
AND QPAPR.QUALIFICATION_IND IN (4
, 6
, 20
, 22)
AND QPALL.PRICING_PHASE_ID = 1
AND QPALL.QUALIFICATION_IND IN (4
, 6
, 20
, 22)
AND QPAPR.PRICING_ATTRIBUTE_CONTEXT IS NULL