VIEW: APPS.QP_LIST_LINES_V

Source

View Text - Preformatted

SELECT /*+ Index_SS(qppr, QP_PRICING_ATTRIBUTES_N7) */ QPLL.ROWID, QPLL.LIST_LINE_ID, QPLL.CREATION_DATE , QPLL.CREATED_BY , QPLL.LAST_UPDATE_DATE , QPLL.LAST_UPDATED_BY , QPLL.LAST_UPDATE_LOGIN , QPLL.PROGRAM_APPLICATION_ID , QPLL.PROGRAM_ID , QPLL.PROGRAM_UPDATE_DATE , QPLL.REQUEST_ID , QPLL.LIST_HEADER_ID , QPPR.LIST_HEADER_ID PA_LIST_HEADER_ID, QPPR.PRODUCT_ATTRIBUTE_CONTEXT, QPPR.PRODUCT_ATTRIBUTE, QPPR.PRODUCT_ATTR_VALUE, QPPR.PRODUCT_UOM_CODE, QPLL.LIST_PRICE, QPLL.PERCENT_PRICE, QPLL.PRICE_BY_FORMULA_ID, QPLL.START_DATE_ACTIVE , QPLL.END_DATE_ACTIVE , QPLL.CONTEXT , QPLL.ATTRIBUTE1 , QPLL.ATTRIBUTE2 , QPLL.ATTRIBUTE3 , QPLL.ATTRIBUTE4 , QPLL.ATTRIBUTE5 , QPLL.ATTRIBUTE6 , QPLL.ATTRIBUTE7 , QPLL.ATTRIBUTE8 , QPLL.ATTRIBUTE9 , QPLL.ATTRIBUTE10 , QPLL.ATTRIBUTE11 , QPLL.ATTRIBUTE12 , QPLL.ATTRIBUTE13 , QPLL.ATTRIBUTE14 , QPLL.ATTRIBUTE15 , QPLL.PRIMARY_UOM_FLAG, QPLL.REVISION, QPLL.REVISION_DATE, QPLL.REVISION_REASON_CODE, QPLL.COMMENTS, QPLL.LIST_LINE_TYPE_CODE, QPLL.AUTOMATIC_FLAG, QPLL.MODIFIER_LEVEL_CODE, QPLL.LIST_PRICE_UOM_CODE, QPLL.INVENTORY_ITEM_ID, QPLL.ORGANIZATION_ID, QPLL.RELATED_ITEM_ID, QPLL.NUMBER_EFFECTIVE_PERIODS, QPLL.EFFECTIVE_PERIOD_UOM, QPLL.ARITHMETIC_OPERATOR, QPLL.INCOMPATIBILITY_GRP_CODE, QPLL.LIST_LINE_NO, QPLL.PRICING_GROUP_SEQUENCE, QPLL.RELATIONSHIP_TYPE_ID, QPLL.SUBSTITUTION_CONTEXT, QPLL.SUBSTITUTION_ATTRIBUTE, QPLL.SUBSTITUTION_VALUE, QPLL.PRICE_BREAK_TYPE_CODE, QPLL.OPERAND, QPLL.OVERRIDE_FLAG, QPLL.PRINT_ON_INVOICE_FLAG, QPLL.REBATE_TRANSACTION_TYPE_CODE, QPLL.BASE_QTY, QPLL.BASE_UOM_CODE, QPLL.ACCRUAL_QTY, QPLL.ACCRUAL_UOM_CODE, QPLL.ESTIM_ACCRUAL_RATE, QPLL.GENERATE_USING_FORMULA_ID, QPLL.ACCRUAL_FLAG, QPLL.REPRICE_FLAG, QPLL.PRICING_PHASE_ID, QPLL.PRODUCT_PRECEDENCE, QPLL.CUSTOMER_ITEM_ID, QPPR.PRICING_ATTRIBUTE_CONTEXT, QPPR.PRICING_ATTRIBUTE, QPPR.PRICING_ATTR_VALUE_FROM, QPPR.PRICING_ATTR_VALUE_TO, QP_PRICE_LIST_LINE_UTIL.Get_Product_Value('QP_ATTR_DEFNS_PRICING' ,QPPR.Product_Attribute_Context ,QPPR.Product_Attribute ,QPPR.Product_Attr_Value), decode(upper(QPPR.Product_Attr_value),'ALL',Null,QPPR.Product_Attr_Value), QPPR.PRICING_ATTRIBUTE_ID, QPPR.PRODUCT_ATTRIBUTE_DATATYPE, QPPR.PRICING_ATTRIBUTE_DATATYPE, QPPR.COMPARISON_OPERATOR_CODE, QPPR.LIST_LINE_ID, QPPR.creation_date ,QPPR.created_by ,QPPR.last_update_date ,QPPR.last_updated_by ,QPPR.last_update_login ,QPPR.program_application_id ,QPPR.program_id ,QPPR.program_update_date ,QPPR.request_id ,QPPR.context ,QPPR.attribute1 ,QPPR.attribute2 ,QPPR.attribute3 ,QPPR.attribute4 ,QPPR.attribute5 ,QPPR.attribute6 ,QPPR.attribute7 ,QPPR.attribute8 ,QPPR.attribute9 ,QPPR.attribute10 ,QPPR.attribute11 ,QPPR.attribute12 ,QPPR.attribute13 ,QPPR.attribute14 ,QPPR.attribute15 ,qpll.break_uom_code ,qpll.break_uom_context ,qpll.break_uom_attribute ,QPLL.CONTINUOUS_PRICE_BREAK_FLAG FROM QP_LIST_LINES QPLL, QP_PRICING_ATTRIBUTES QPPR WHERE QPPR.LIST_LINE_ID = QPLL.LIST_LINE_ID AND QPLL.LIST_LINE_TYPE_CODE IN ('PLL', 'PBH') AND QPPR.PRICING_PHASE_ID = 1 AND QPPR.QUALIFICATION_IND in (4,6,20,22) AND QPLL.PRICING_PHASE_ID = 1 AND QPLL.QUALIFICATION_IND in (4,6,20,22) AND QPPR.LIST_HEADER_ID=QPLL.LIST_HEADER_ID AND ( (qppr.rowid = ( select rowid from QP_PRICING_ATTRIBUTES where QPPR.list_line_id = list_line_id and pricing_attribute_context ='PRICING ATTRIBUTE' and pricing_attribute = 'PRICING_ATTRIBUTE11' and rownum < 2 ) ) OR (qppr.rowid = (select rowid from QP_PRICING_ATTRIBUTES where qppr.list_line_id = list_line_id and pricing_attribute_context is NULL and pricing_attribute is NULL and excluder_flag='N' ) AND not exists (select null from QP_PRICING_ATTRIBUTES where QPPR.list_line_id = list_line_id and pricing_attribute_context ='PRICING ATTRIBUTE' and pricing_attribute = 'PRICING_ATTRIBUTE11' ) ) )

View Text - HTML Formatted

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