[Home] [Help]
456: ' mkt.COMPARISON_OPERATOR_CODE '||
457: 'from qp_pricing_attributes prd, '||
458: ' qp_qualifiers mkt, '||
459: ' ozf_act_offers off, '||
460: ' qp_list_lines ln '||
461: 'where off.arc_act_offer_used_by = :l_object_type '||
462: 'and off.act_offer_used_by_id = :l_object_id '||
463: 'and off.qp_list_header_id = prd.list_header_id '||
464: 'and prd.excluder_flag = ''N'' '||
505: ' mkt.QUALIFIER_ATTR_VALUE_TO, '||
506: ' mkt.COMPARISON_OPERATOR_CODE '||
507: 'from qp_pricing_attributes prd, '||
508: ' qp_qualifiers mkt, '||
509: ' qp_list_lines ln '||
510: 'where ''OFFR'' = :l_object_type '||
511: 'and prd.list_header_id = :l_object_id '||
512: 'and prd.excluder_flag = ''N'' '||
513: 'and prd.list_line_id = ln.list_line_id '||
1906: ,'%', 3
1907: , 2 )
1908: , 2)
1909: , 1) promotion_type
1910: FROM qp_list_lines qpl,
1911: qp_pricing_attributes qp
1912: WHERE qpl.list_header_id = p_obj_id
1913: AND qpl.list_line_id = qp.list_line_id
1914: AND qp.excluder_flag = 'N'
2640: ,'%', 3
2641: , 2 )
2642: , 2)
2643: , 1) promotion_type
2644: FROM qp_list_lines qpl,
2645: qp_pricing_attributes qp
2646: WHERE qpl.list_header_id = p_obj_id
2647: AND qpl.list_line_id = qp.list_line_id
2648: AND qp.excluder_flag = 'N'
3700: ,'%', 3
3701: , 2 )
3702: , 2)
3703: , 1) promotion_type
3704: FROM qp_list_lines qpl,
3705: qp_pricing_attributes qp
3706: WHERE qpl.list_header_id = p_obj_id
3707: AND qpl.list_line_id = qp.list_line_id
3708: AND qp.excluder_flag = 'N'
8481: CURSOR c_offer_discounts IS
8482: SELECT qpl.operand,
8483: qpl.arithmetic_operator
8484: FROM qp_pricing_attributes pa,
8485: qp_list_lines qpl,
8486: ozf_offers a
8487: WHERE a.qp_list_header_id = p_obj_id
8488: AND qpl.list_header_id = a.qp_list_header_id
8489: AND qpl.list_line_id = pa.list_line_id
8825: ) discount,
8826: qpl.operand,
8827: qpl.arithmetic_operator
8828: FROM qp_pricing_attributes pa,
8829: qp_list_lines qpl,
8830: ozf_offers a
8831: WHERE a.qp_list_header_id = p_obj_id
8832: AND qpl.list_header_id = a.qp_list_header_id
8833: AND qpl.list_line_id = pa.list_line_id
8852: DECODE(qpl.arithmetic_operator,'%','%',' ') discount,
8853: qpl.operand,
8854: qpl.arithmetic_operator
8855: FROM qp_pricing_attributes pa,
8856: qp_list_lines qpl,
8857: ozf_act_offers a
8858: WHERE a.arc_act_offer_used_by = p_obj_type
8859: AND a.act_offer_used_by_id = p_obj_id
8860: AND qpl.list_header_id = a.qp_list_header_id
10020: disc.list_line_type_code,
10021: fcst.price_list_id,
10022: disc.list_header_id
10023: from qp_pricing_attributes prod,
10024: qp_list_lines disc,
10025: ozf_act_forecasts_all fcst
10026: where fcst.forecast_id = p_used_by_id
10027: and fcst.arc_act_fcast_used_by = 'OFFR'
10028: and disc.list_header_id = fcst.act_fcast_used_by_id