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_OFFR_ELIG_PROD_DENORM_PVT dependencies on OZF_OFFERS

Line 556: FROM ozf_offers

552: IS
553:
554: CURSOR c_offer_id IS
555: SELECT offer_id
556: FROM ozf_offers
557: WHERE qp_list_header_id = p_list_header_id;
558:
559: CURSOR c_no_groups(l_offer_id NUMBER) IS
560: SELECT COUNT(*)

Line 757: FROM ozf_offers

753: AND excluder_flag = 'Y';
754:
755: CURSOR c_offer_id IS
756: SELECT offer_id
757: FROM ozf_offers
758: WHERE qp_list_header_id = p_list_header_id;
759:
760: l_api_version CONSTANT NUMBER := 1.0;
761: l_api_name CONSTANT VARCHAR2(30) := 'refresh_netaccrual_products';

Line 1003: FROM ozf_offers

999: AND excluder_flag = 'Y';
1000:
1001: CURSOR c_offer_id(l_list_header_id NUMBER) IS
1002: SELECT offer_id
1003: FROM ozf_offers
1004: WHERE qp_list_header_id = l_list_header_id;
1005:
1006:
1007: l_api_version CONSTANT NUMBER := 1.0;

Line 1199: FROM ozf_offers

1195: )
1196: IS
1197: CURSOR c_qualifier_exists IS
1198: SELECT 'Y'
1199: FROM ozf_offers
1200: WHERE qualifier_type IS NOT NULL
1201: AND qualifier_id IS NOT NULL
1202: AND qp_list_header_id = p_list_header_id;
1203:

Line 1214: FROM ozf_offers

1210: 'CUSTOMER', 'QUALIFIER_ATTRIBUTE2',
1211: 'CUSTOMER_BILL_TO', 'QUALIFIER_ATTRIBUTE14',
1212: 'SHIP_TO', 'QUALIFIER_ATTRIBUTE11') qualifier_attribute,
1213: qualifier_id qualifier_attr_value
1214: FROM ozf_offers
1215: WHERE qp_list_header_id = p_list_header_id;
1216:
1217: l_api_name CONSTANT VARCHAR2(30) := 'refresh_lumpsum_parties';
1218: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 1621: FROM ozf_offers

1617: AND b.query_for = 'ELIG';
1618:
1619: CURSOR c_offer_type IS
1620: SELECT offer_type
1621: FROM ozf_offers
1622: WHERE qp_list_header_id = p_list_header_id;
1623:
1624:
1625: CURSOR c_elig_exists IS

Line 2098: FROM ozf_offers

2094:
2095:
2096: CURSOR c_offer_type IS
2097: SELECT offer_type
2098: FROM ozf_offers
2099: WHERE qp_list_header_id = p_list_header_id;
2100:
2101: CURSOR c_na_offer_type IS
2102: SELECT offer_type

Line 2103: FROM ozf_offers

2099: WHERE qp_list_header_id = p_list_header_id;
2100:
2101: CURSOR c_na_offer_type IS
2102: SELECT offer_type
2103: FROM ozf_offers
2104: WHERE offer_id = p_list_header_id;
2105:
2106: CURSOR c_no_products IS
2107: SELECT COUNT(DISTINCT list_line_id)

Line 2388: FROM ozf_offers o,

2384: o.confidential_flag,
2385: o.custom_setup_id,
2386: af.forecast_uom_code,
2387: o.fund_request_curr_code curr_code
2388: FROM ozf_offers o,
2389: qp_list_headers l,
2390: ozf_act_offers ao,
2391: ams_campaigns_vl ct,
2392: ozf_act_forecasts_all af

Line 2404: FROM ozf_offers

2400: and af.freeze_flag(+) = 'Y';
2401:
2402: CURSOR c_offer_changed(l_list_header_id NUMBER, l_date DATE) IS
2403: SELECT 'Y'
2404: FROM ozf_offers
2405: WHERE qp_list_header_id = l_list_header_id
2406: AND (last_update_date > l_date OR qualifier_deleted = 'Y');
2407:
2408: CURSOR c_qualifier_changed(l_list_header_id NUMBER, l_date DATE) IS

Line 2562: ozf_offers ao

2558: ozf_act_metric_facts_all fm,
2559: ozf_forecast_dimentions fp,
2560: qp_pricing_attributes qa,
2561: qp_list_lines ql,
2562: ozf_offers ao
2563: WHERE fp.obj_id = l_offer_id
2564: and fp.obj_type = 'OFFR'
2565: and fc.act_fcast_used_by_id = fp.obj_id
2566: and fc.last_scenario_id = (select max(last_scenario_id)

Line 2595: FROM qp_modifier_summary_v a, ozf_offers b

2591:
2592:
2593: CURSOR c_list_lines(ll_list_header_id NUMBER) IS
2594: SELECT DISTINCT list_line_id lline_id
2595: FROM qp_modifier_summary_v a, ozf_offers b
2596: WHERE a.list_header_id = ll_list_header_id
2597: AND b.qp_list_header_id = a.list_header_id
2598: AND b.offer_type <> 'VOLUME_OFFER'
2599: AND (a.end_date_active IS NULL

Line 2603: FROM ozf_offer_discount_products a, ozf_offers b

2599: AND (a.end_date_active IS NULL
2600: OR a.end_date_active >= SYSDATE)
2601: UNION
2602: SELECT off_discount_product_id lline_id
2603: FROM ozf_offer_discount_products a, ozf_offers b
2604: WHERE b.qp_list_header_id = ll_list_header_id
2605: AND a.offer_id = b.offer_id
2606: and b.offer_type = 'NET_ACCRUAL'
2607: AND a.excluder_flag = 'N'

Line 2618: FROM ozf_offer_discount_lines a, ozf_offers b

2614: AND arc_act_product_used_by = 'OFFR'
2615: AND excluded_flag = 'N'
2616: UNION
2617: SELECT distinct offer_discount_line_id lline_id
2618: FROM ozf_offer_discount_lines a, ozf_offers b
2619: WHERE b.qp_list_header_id = ll_list_header_id
2620: AND a.offer_id = b.offer_id
2621: AND b.offer_type = 'VOLUME_OFFER'
2622: and a.tier_type = 'PBH'

Line 2646: FROM ozf_offer_qualifiers a, ozf_offers b

2642: AND a.qualifier_attribute = b.attribute
2643: AND b.query_for = 'ELIG'
2644: UNION
2645: SELECT a.qualifier_id qnum
2646: FROM ozf_offer_qualifiers a, ozf_offers b
2647: WHERE b.qp_list_header_id = ll_list_header_id
2648: AND a.offer_id = b.offer_id
2649: AND a.active_flag = 'Y'
2650: UNION

Line 2652: FROM ozf_offers

2648: AND a.offer_id = b.offer_id
2649: AND a.active_flag = 'Y'
2650: UNION
2651: SELECT qualifier_id qnum
2652: FROM ozf_offers
2653: WHERE qp_list_header_id = ll_list_header_id
2654: AND offer_type in ('SCAN_DATA', 'LUMPSUM')
2655: UNION
2656: select -99 qnum

Line 2671: FROM ozf_offer_qualifiers a, ozf_offers b

2667: AND a.qualifier_attribute = b.attribute
2668: AND b.query_for = 'ELIG'
2669: UNION
2670: SELECT count(a.qualifier_id)
2671: FROM ozf_offer_qualifiers a, ozf_offers b
2672: WHERE b.qp_list_header_id = ll_list_header_id
2673: AND a.offer_id = b.offer_id
2674: AND a.active_flag = 'Y';
2675:

Line 2963: UPDATE ozf_offers

2959: FND_DSQL.do_binds;
2960: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2961: dbms_sql.close_cursor(l_denorm_csr);
2962:
2963: UPDATE ozf_offers
2964: SET qualifier_deleted = 'N'
2965: WHERE qp_list_header_id = i.object_id;
2966: END IF;
2967: l_group_count := l_group_count + 1;

Line 3317: UPDATE ozf_offers

3313: FND_DSQL.do_binds;
3314: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3315: dbms_sql.close_cursor(l_denorm_csr);
3316:
3317: UPDATE ozf_offers
3318: SET qualifier_deleted = 'N'
3319: WHERE qp_list_header_id = i.object_id;
3320: END IF;
3321: l_group_count := l_group_count + 1;

Line 3875: FROM ozf_offers o, qp_list_headers l

3871: /*
3872: DELETE FROM ozf_activity_customers
3873: WHERE object_id IN (
3874: SELECT l.list_header_id
3875: FROM ozf_offers o, qp_list_headers l
3876: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3877: AND o.qp_list_header_id = l.list_header_id
3878: )
3879: AND object_class = 'OFFR';

Line 3884: FROM ozf_offers o, qp_list_headers l

3880:
3881: DELETE FROM ozf_activity_products
3882: WHERE object_id IN (
3883: SELECT l.list_header_id
3884: FROM ozf_offers o, qp_list_headers l
3885: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3886: AND o.qp_list_header_id = l.list_header_id
3887: )
3888: AND object_class = 'OFFR';

Line 3894: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3890:
3891: DELETE FROM OZF_ACTIVITY_CUSTOMERS b
3892: WHERE
3893: exists ( SELECT L.LIST_HEADER_ID
3894: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3895: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3896: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3897: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3898:

Line 3902: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3898:
3899: DELETE FROM OZF_ACTIVITY_PRODUCTS b
3900: WHERE
3901: exists ( SELECT L.LIST_HEADER_ID
3902: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3903: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3904: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3905: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3906:

Line 4391: ozf_offers ao

4387: ozf_act_metric_facts_all fm,
4388: ozf_forecast_dimentions fp,
4389: qp_pricing_attributes qa,
4390: qp_list_lines ql,
4391: ozf_offers ao
4392: WHERE fp.obj_id = l_offer_id
4393: and fp.obj_type = 'OFFR'
4394: and fc.act_fcast_used_by_id = fp.obj_id
4395: and fc.last_scenario_id = (select max(last_scenario_id)