VIEW: APPS.QPFV_MODIFIER_LINES

Source

View Text - Preformatted

SELECT ll.LIST_HEADER_ID ,ll.PRICE_BY_FORMULA_ID ,ll.OPERAND ,ll.OVERRIDE_FLAG ,ll.LIST_LINE_NO ,ll.START_DATE_ACTIVE ,ll.END_DATE_ACTIVE ,ll.PRODUCT_PRECEDENCE ,ll.PRIMARY_UOM_FLAG ,ll.PRICING_PHASE_ID ,ll.EXPIRATION_PERIOD_START_DATE ,ll.NUMBER_EXPIRATION_PERIODS ,ll.EXPIRATION_DATE ,ll.ACCRUAL_FLAG ,ll.ESTIM_ACCRUAL_RATE ,ll.ACCRUAL_CONVERSION_RATE ,ll.BENEFIT_QTY ,ll.BENEFIT_UOM_CODE ,mtl1.UNIT_OF_MEASURE ,ll.PRICING_GROUP_SEQUENCE ,'_LA:ll.PRICING_GROUP_SEQUENCE:QP_LOOKUPS:PRICING_GROUP_SEQUENCE:MEANING' ,ll.ARITHMETIC_OPERATOR ,'_LA:ll.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING' ,ll.EXPIRATION_PERIOD_UOM ,mtl2.UNIT_OF_MEASURE ,ll.REBATE_TRANSACTION_TYPE_CODE ,'_LA:ll.REBATE_TRANSACTION_TYPE_CODE:QP_LOOKUPS:REBATE_TRANSACTION_TYPE_CODE:MEANING' ,ll.CHARGE_TYPE_CODE ,'_LA:ll.CHARGE_TYPE_CODE:QP_LOOKUPS:FREIGHT_CHARGES_TYPE:MEANING' ,ll.CHARGE_SUBTYPE_CODE ,ll.INCOMPATIBILITY_GRP_CODE ,'_LA:ll.INCOMPATIBILITY_GRP_CODE:QP_LOOKUPS:INCOMPATIBILITY_GROUPS:MEANING' ,ll.LIST_LINE_TYPE_CODE ,'_LA:ll.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING' ,ll.PRICE_BREAK_TYPE_CODE ,'_LA:ll.PRICE_BREAK_TYPE_CODE:QP_LOOKUPS:PRICE_BREAK_TYPE_CODE:MEANING' ,ll.MODIFIER_LEVEL_CODE ,'_LA:ll.MODIFIER_LEVEL_CODE:QP_LOOKUPS:MODIFIER_LEVEL_CODE:MEANING' ,ll.LIST_LINE_ID ,ll.CREATION_DATE ,ll.CREATED_BY ,ll.LAST_UPDATE_DATE ,ll.LAST_UPDATED_BY , '_DF:QP:QP_LIST_LINES:ll' ,ll.NET_AMOUNT_FLAG ,ll.ACCUM_CONTEXT ,QP_QP_Form_Pricing_Attr.Get_Attribute('QP_ATTR_DEFNS_PRICING',ll.ACCUM_CONTEXT,ll.ACCUM_ATTRIBUTE) ,ll.ACCUM_ATTR_RUN_SRC_FLAG ,ll.ORIG_SYS_HEADER_REF ,ll.ORIG_SYS_LINE_REF from qp_list_lines ll , mtl_units_of_measure mtl1, mtl_units_of_measure mtl2 WHERE ll.list_line_type_code in ('DIS','SUR','FREIGHT_CHARGE','PBH','OID','PRG') and not exists ( select 'x' from qp_rltd_modifiers rltd where ll.list_line_id = rltd.to_rltd_modifier_id ) and ll.benefit_uom_code = mtl1.uom_code (+) and ll.expiration_period_uom = mtl2.uom_code (+) WITH READ ONLY

View Text - HTML Formatted

SELECT LL.LIST_HEADER_ID
, LL.PRICE_BY_FORMULA_ID
, LL.OPERAND
, LL.OVERRIDE_FLAG
, LL.LIST_LINE_NO
, LL.START_DATE_ACTIVE
, LL.END_DATE_ACTIVE
, LL.PRODUCT_PRECEDENCE
, LL.PRIMARY_UOM_FLAG
, LL.PRICING_PHASE_ID
, LL.EXPIRATION_PERIOD_START_DATE
, LL.NUMBER_EXPIRATION_PERIODS
, LL.EXPIRATION_DATE
, LL.ACCRUAL_FLAG
, LL.ESTIM_ACCRUAL_RATE
, LL.ACCRUAL_CONVERSION_RATE
, LL.BENEFIT_QTY
, LL.BENEFIT_UOM_CODE
, MTL1.UNIT_OF_MEASURE
, LL.PRICING_GROUP_SEQUENCE
, '_LA:LL.PRICING_GROUP_SEQUENCE:QP_LOOKUPS:PRICING_GROUP_SEQUENCE:MEANING'
, LL.ARITHMETIC_OPERATOR
, '_LA:LL.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING'
, LL.EXPIRATION_PERIOD_UOM
, MTL2.UNIT_OF_MEASURE
, LL.REBATE_TRANSACTION_TYPE_CODE
, '_LA:LL.REBATE_TRANSACTION_TYPE_CODE:QP_LOOKUPS:REBATE_TRANSACTION_TYPE_CODE:MEANING'
, LL.CHARGE_TYPE_CODE
, '_LA:LL.CHARGE_TYPE_CODE:QP_LOOKUPS:FREIGHT_CHARGES_TYPE:MEANING'
, LL.CHARGE_SUBTYPE_CODE
, LL.INCOMPATIBILITY_GRP_CODE
, '_LA:LL.INCOMPATIBILITY_GRP_CODE:QP_LOOKUPS:INCOMPATIBILITY_GROUPS:MEANING'
, LL.LIST_LINE_TYPE_CODE
, '_LA:LL.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, LL.PRICE_BREAK_TYPE_CODE
, '_LA:LL.PRICE_BREAK_TYPE_CODE:QP_LOOKUPS:PRICE_BREAK_TYPE_CODE:MEANING'
, LL.MODIFIER_LEVEL_CODE
, '_LA:LL.MODIFIER_LEVEL_CODE:QP_LOOKUPS:MODIFIER_LEVEL_CODE:MEANING'
, LL.LIST_LINE_ID
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_LINES:LL'
, LL.NET_AMOUNT_FLAG
, LL.ACCUM_CONTEXT
, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_PRICING'
, LL.ACCUM_CONTEXT
, LL.ACCUM_ATTRIBUTE)
, LL.ACCUM_ATTR_RUN_SRC_FLAG
, LL.ORIG_SYS_HEADER_REF
, LL.ORIG_SYS_LINE_REF
FROM QP_LIST_LINES LL
, MTL_UNITS_OF_MEASURE MTL1
, MTL_UNITS_OF_MEASURE MTL2
WHERE LL.LIST_LINE_TYPE_CODE IN ('DIS'
, 'SUR'
, 'FREIGHT_CHARGE'
, 'PBH'
, 'OID'
, 'PRG')
AND NOT EXISTS ( SELECT 'X'
FROM QP_RLTD_MODIFIERS RLTD
WHERE LL.LIST_LINE_ID = RLTD.TO_RLTD_MODIFIER_ID )
AND LL.BENEFIT_UOM_CODE = MTL1.UOM_CODE (+)
AND LL.EXPIRATION_PERIOD_UOM = MTL2.UOM_CODE (+) WITH READ ONLY