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 OZF_OFFERS

Line 159: FROM ozf_offers off

155: WHERE forecast_id = p_forecast_id;
156:
157: CURSOR offerid_csr(p_offer_code IN VARCHAR2) IS
158: SELECT qp_list_header_id --offer_id
159: FROM ozf_offers off
160: WHERE off.offer_code = p_offer_code;
161: */
162:
163: l_sales NUMBER := 0;

Line 555: 'ozf_offers b '||

551: ' b.qualifier_id QUALIFIER_ATTR_VALUE, '||
552: ' null QUALIFIER_ATTR_VALUE_TO, '||
553: ' ''='' COMPARISON_OPERATOR_CODE '||
554: 'from ams_act_products a, '||
555: 'ozf_offers b '||
556: 'where a.arc_act_product_used_by = :l_object_type '||
557: 'and a.act_product_used_by_id = :l_object_id '||
558: 'and a.act_product_used_by_id = b.qp_list_header_id '||
559: 'and a.excluded_flag = ''N'' ' ;

Line 616: ' OZF_OFFERS OFFR, '||

612: ' MKT.QUALIFIER_ATTR_VALUE, '||
613: ' MKT.QUALIFIER_ATTR_VALUE_TO, '||
614: ' MKT.COMPARISON_OPERATOR_CODE '||
615: 'FROM '||
616: ' OZF_OFFERS OFFR, '||
617: ' OZF_OFFER_DISCOUNT_LINES ODL, '||
618: ' OZF_OFFER_DISCOUNT_PRODUCTS ODP, '||
619: ' QP_QUALIFIERS MKT '||
620: 'WHERE ''OFFR'' = :l_object_type '||

Line 642: ' OZF_OFFERS OFFR, '||

638: ' PRDODP.PRODUCT_CONTEXT, '||
639: ' PRDODP.PRODUCT_ATTRIBUTE, '||
640: ' PRDODP.PRODUCT_ATTR_VALUE '||
641: 'FROM '||
642: ' OZF_OFFERS OFFR, '||
643: ' OZF_OFFER_DISCOUNT_LINES ODL, '||
644: ' OZF_OFFER_DISCOUNT_PRODUCTS PRDODP, '||
645: ' OZF_OFFER_DISCOUNT_PRODUCTS EXCODP '||
646: 'WHERE ''OFFR'' = :l_object_type '||

Line 662: FROM ozf_offers

658:
659:
660: CURSOR get_offer_type(l_qp_list_header_id NUMBER) IS
661: SELECT offer_type
662: FROM ozf_offers
663: WHERE qp_list_header_id = l_qp_list_header_id;
664:
665: l_offer_type VARCHAR2(30);
666:

Line 1865: FROM ozf_offers off

1861: WHERE forecast_id = p_forecast_id;
1862:
1863: CURSOR offerid_csr(p_offer_code IN VARCHAR2) IS
1864: SELECT qp_list_header_id --offer_id
1865: FROM ozf_offers off
1866: WHERE off.offer_code = p_offer_code;
1867:
1868:
1869: l_base_sales NUMBER := 0;

Line 1896: FROM ozf_offers

1892:
1893: CURSOR get_offer_type
1894: IS
1895: SELECT offer_type
1896: FROM ozf_offers
1897: WHERE qp_list_header_id = p_obj_id;
1898:
1899: CURSOR get_promotion_type(l_product_attribute_context IN VARCHAR2,
1900: l_product_attribute IN VARCHAR2,

Line 2630: FROM ozf_offers

2626:
2627: CURSOR get_offer_type
2628: IS
2629: SELECT offer_type
2630: FROM ozf_offers
2631: WHERE qp_list_header_id = p_obj_id;
2632:
2633: CURSOR get_promotion_type(l_product_attribute_context IN VARCHAR2,
2634: l_product_attribute IN VARCHAR2,

Line 3532: FROM OZF_ACT_FORECASTS_ALL a, ozf_offers b

3528: a.INCREMENT_QUOTA,
3529: a.FORECAST_UOM_CODE,
3530: a.LAST_SCENARIO_ID,
3531: b.transaction_currency_code
3532: FROM OZF_ACT_FORECASTS_ALL a, ozf_offers b
3533: WHERE a.FORECAST_ID = p_forecast_id
3534: AND a.arc_act_fcast_used_by = p_obj_type
3535: AND a.act_fcast_used_by_id = p_obj_id
3536: AND b.qp_list_header_id = a.act_fcast_used_by_id;

Line 3690: FROM ozf_offers

3686:
3687: CURSOR get_offer_type
3688: IS
3689: SELECT offer_type
3690: FROM ozf_offers
3691: WHERE qp_list_header_id = p_obj_id;
3692:
3693: CURSOR get_promotion_type(l_product_attribute_context IN VARCHAR2,
3694: l_product_attribute IN VARCHAR2,

Line 4192: ozf_offers off

4188: CURSOR offer_dates_csr(p_offer_code IN VARCHAR2) IS
4189: SELECT NVL(qp.start_date_active,trunc(SYSDATE)) start_date_active,
4190: NVL(qp.end_date_active, trunc(SYSDATE)) end_date_active
4191: FROM qp_list_headers_b qp,
4192: ozf_offers off
4193: WHERE off.offer_code = p_offer_code
4194: AND off.qp_list_header_id = qp.list_header_id ;
4195:
4196: l_forecast_id NUMBER;

Line 4656: ozf_offers off

4652: CURSOR offer_dates_csr(p_offer_code IN VARCHAR2) IS
4653: SELECT NVL(qp.start_date_active,trunc(SYSDATE)) start_date_active,
4654: NVL(qp.end_date_active, trunc(SYSDATE)) end_date_active
4655: FROM qp_list_headers_b qp,
4656: ozf_offers off
4657: WHERE off.offer_code = p_offer_code
4658: AND off.qp_list_header_id = qp.list_header_id ;
4659:
4660: CURSOR offer_id_csr(p_offer_code IN VARCHAR2) IS

Line 4662: FROM ozf_offers off

4658: AND off.qp_list_header_id = qp.list_header_id ;
4659:
4660: CURSOR offer_id_csr(p_offer_code IN VARCHAR2) IS
4661: SELECT qp_list_header_id --offer_id
4662: FROM ozf_offers off
4663: WHERE off.offer_code = p_offer_code;
4664: -- AND offer_type = 'OFFR' ;
4665:
4666: CURSOR c_get_activity_metric_id(p_fcast_id IN NUMBER) IS

Line 8455: FROM ozf_offers

8451: WHERE a.forecast_id = p_forecast_id ;
8452:
8453: CURSOR c_type_of_offer IS
8454: SELECT offer_type
8455: FROM ozf_offers
8456: WHERE qp_list_header_id = p_obj_id;
8457:
8458: CURSOR c_offer_type IS
8459: SELECT min(b.offer_type) offer_type,

Line 8462: ozf_offers b

8458: CURSOR c_offer_type IS
8459: SELECT min(b.offer_type) offer_type,
8460: sum(a.line_lumpsum_qty) total_qty
8461: FROM ams_act_products a ,
8462: ozf_offers b
8463: WHERE a.arc_act_product_used_by = p_obj_type
8464: AND a.act_product_used_by_id = p_obj_id
8465: AND b.qp_list_header_id = a.act_product_used_by_id ;
8466:

Line 8474: ozf_offers b

8470: 'AMT', 100 * a.line_lumpsum_qty/b.lumpsum_amount,
8471: '%' , a.line_lumpsum_qty,
8472: 'QTY', 100 * a.line_lumpsum_qty/p_lumpsum_qty ) lumpsum_disc
8473: from ams_act_products a,
8474: ozf_offers b
8475: where a.arc_act_product_used_by = p_obj_type
8476: and a.act_product_used_by_id = p_obj_id
8477: and a.act_product_used_by_id = b.qp_list_header_id
8478: and a.excluded_flag = 'N'

Line 8486: ozf_offers a

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
8490: AND pa.excluder_flag = 'N'

Line 8501: OZF_OFFERS OFFR,

8497: SELECT
8498: ODL.DISCOUNT_TYPE arithmetic_operator,
8499: MAX(DIS.DISCOUNT) operand
8500: FROM
8501: OZF_OFFERS OFFR,
8502: OZF_OFFER_DISCOUNT_LINES ODL,
8503: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
8504: OZF_OFFER_DISCOUNT_LINES DIS
8505: WHERE

Line 8778: ozf_offers b

8774: CURSOR c_offer_type IS
8775: SELECT min(b.offer_type) offer_type,
8776: sum(a.line_lumpsum_qty) total_qty
8777: FROM ams_act_products a ,
8778: ozf_offers b
8779: WHERE a.arc_act_product_used_by = p_obj_type
8780: AND a.act_product_used_by_id = p_obj_id
8781: AND b.qp_list_header_id = a.act_product_used_by_id ;
8782:

Line 8786: FROM ozf_offers

8782:
8783: --R12 ----
8784: CURSOR c_type_of_offer IS
8785: SELECT offer_type
8786: FROM ozf_offers
8787: WHERE qp_list_header_id = p_obj_id;
8788:
8789: CURSOR c_lumpsum_discount(p_lumpsum_qty NUMBER) IS
8790: SELECT DECODE(b.distribution_type,

Line 8795: ozf_offers b

8791: 'AMT', a.line_lumpsum_qty,
8792: '%' , (b.lumpsum_amount*a.line_lumpsum_qty)/100 ,
8793: 'QTY', (a.line_lumpsum_qty * b.lumpsum_amount)/p_lumpsum_qty ) lumpsum_disc
8794: from ams_act_products a,
8795: ozf_offers b
8796: where a.arc_act_product_used_by = p_obj_type
8797: and a.act_product_used_by_id = p_obj_id
8798: and a.act_product_used_by_id = b.qp_list_header_id
8799: and a.excluded_flag = 'N'

Line 8830: ozf_offers a

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
8834: AND pa.excluder_flag = 'N'

Line 8883: OZF_OFFERS OFFR,

8879: ) discount,
8880: ODL.DISCOUNT_TYPE arithmetic_operator,
8881: MAX(DIS.DISCOUNT) operand
8882: FROM
8883: OZF_OFFERS OFFR,
8884: OZF_OFFER_DISCOUNT_LINES ODL,
8885: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
8886: OZF_OFFER_DISCOUNT_LINES DIS
8887: WHERE

Line 9263: ozf_offers o,

9259: 'ORDER', -adj.adjusted_amount
9260: , adj.adjusted_amount) adjusted_amount,
9261: adj.accrual_flag
9262: FROM ozf_forecast_products p,
9263: ozf_offers o,
9264: oe_price_adjustments adj,
9265: oe_order_lines_all line
9266: WHERE p.obj_type = p_obj_type
9267: AND p.obj_id = p_obj_id

Line 9431: FROM ozf_offers a,

9427: CURSOR c1 IS
9428: SELECT a.offer_type,
9429: nvl(a.transaction_currency_code,a.fund_request_curr_code),
9430: b.forecast_spread_type
9431: FROM ozf_offers a,
9432: ozf_act_forecasts_all b
9433: WHERE b.forecast_id = p_used_by_id
9434: AND DECODE(b.arc_act_fcast_used_by,'OFFR',b.act_fcast_used_by_id,-99)
9435: = a.qp_list_header_id(+);

Line 9722: OZF_OFFERS OFFR,

9718: ODL.discount_type discount_type_code,
9719: ODL.volume_type volume_type,
9720: ODL.uom_code uom_code
9721: FROM
9722: OZF_OFFERS OFFR,
9723: OZF_OFFER_DISCOUNT_LINES ODL,
9724: OZF_OFFER_DISCOUNT_PRODUCTS ODP,
9725: OZF_OFFER_DISCOUNT_LINES DIS
9726: WHERE