eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FORECAST_UTIL_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 457: 'from qp_pricing_attributes prd, '||

453: ' mkt.QUALIFIER_ATTRIBUTE, '||
454: ' mkt.QUALIFIER_ATTR_VALUE, '||
455: ' mkt.QUALIFIER_ATTR_VALUE_TO, '||
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 '||

Line 486: 'from qp_pricing_attributes prd, '||

482: ' exp.PRODUCT_ATTR_VALUE, '||
483: ' prd.PRODUCT_ATTRIBUTE_CONTEXT, '||
484: ' prd.PRODUCT_ATTRIBUTE, '||
485: ' prd.PRODUCT_ATTR_VALUE ' ||
486: 'from qp_pricing_attributes prd, '||
487: ' qp_pricing_attributes exp,'||
488: ' ozf_act_offers off '||
489: 'where off.arc_act_offer_used_by = :l_object_type '||
490: 'and off.act_offer_used_by_id = :l_object_id '||

Line 487: ' qp_pricing_attributes exp,'||

483: ' prd.PRODUCT_ATTRIBUTE_CONTEXT, '||
484: ' prd.PRODUCT_ATTRIBUTE, '||
485: ' prd.PRODUCT_ATTR_VALUE ' ||
486: 'from qp_pricing_attributes prd, '||
487: ' qp_pricing_attributes exp,'||
488: ' ozf_act_offers off '||
489: 'where off.arc_act_offer_used_by = :l_object_type '||
490: 'and off.act_offer_used_by_id = :l_object_id '||
491: 'and off.qp_list_header_id = prd.list_header_id '||

Line 507: 'from qp_pricing_attributes prd, '||

503: ' mkt.QUALIFIER_ATTRIBUTE, '||
504: ' mkt.QUALIFIER_ATTR_VALUE, '||
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 '||

Line 532: 'from qp_pricing_attributes prd, '||

528: ' exp.PRODUCT_ATTR_VALUE, '||
529: ' prd.PRODUCT_ATTRIBUTE_CONTEXT, '||
530: ' prd.PRODUCT_ATTRIBUTE, '||
531: ' prd.PRODUCT_ATTR_VALUE ' ||
532: 'from qp_pricing_attributes prd, '||
533: ' qp_pricing_attributes exp '||
534: 'where ''OFFR'' = :l_object_type '||
535: 'and prd.list_header_id = :l_object_id '||
536: 'and prd.excluder_flag = ''Y'' '||

Line 533: ' qp_pricing_attributes exp '||

529: ' prd.PRODUCT_ATTRIBUTE_CONTEXT, '||
530: ' prd.PRODUCT_ATTRIBUTE, '||
531: ' prd.PRODUCT_ATTR_VALUE ' ||
532: 'from qp_pricing_attributes prd, '||
533: ' qp_pricing_attributes exp '||
534: 'where ''OFFR'' = :l_object_type '||
535: 'and prd.list_header_id = :l_object_id '||
536: 'and prd.excluder_flag = ''Y'' '||
537: 'and prd.list_line_id = exp.list_line_id '||

Line 1911: qp_pricing_attributes qp

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'
1915: AND qp.product_attribute_context = l_product_attribute_context

Line 2645: qp_pricing_attributes qp

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'
2649: AND qp.product_attribute_context = l_product_attribute_context

Line 3705: qp_pricing_attributes qp

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'
3709: AND qp.product_attribute_context = l_product_attribute_context

Line 8484: FROM qp_pricing_attributes pa,

8480:
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

Line 8828: FROM qp_pricing_attributes pa,

8824: DECODE(qpl.arithmetic_operator,'%','%',' ')
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

Line 8855: FROM qp_pricing_attributes pa,

8851: ' ' ||
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

Line 10023: from qp_pricing_attributes prod,

10019: prod.product_attr_value,
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'