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 760: FROM ozf_offers

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

Line 994: FROM ozf_offers

990: AND excluder_flag = 'Y';
991:
992: CURSOR c_offer_id(l_list_header_id NUMBER) IS
993: SELECT offer_id
994: FROM ozf_offers
995: WHERE qp_list_header_id = l_list_header_id;
996:
997:
998: l_api_version CONSTANT NUMBER := 1.0;

Line 1178: FROM ozf_offers

1174: )
1175: IS
1176: CURSOR c_qualifier_exists IS
1177: SELECT 'Y'
1178: FROM ozf_offers
1179: WHERE qualifier_type IS NOT NULL
1180: AND qualifier_id IS NOT NULL
1181: AND qp_list_header_id = p_list_header_id;
1182:

Line 1193: FROM ozf_offers

1189: 'CUSTOMER', 'QUALIFIER_ATTRIBUTE2',
1190: 'CUSTOMER_BILL_TO', 'QUALIFIER_ATTRIBUTE14',
1191: 'SHIP_TO', 'QUALIFIER_ATTRIBUTE11') qualifier_attribute,
1192: qualifier_id qualifier_attr_value
1193: FROM ozf_offers
1194: WHERE qp_list_header_id = p_list_header_id;
1195:
1196: l_api_name CONSTANT VARCHAR2(30) := 'refresh_lumpsum_parties';
1197: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 1602: FROM ozf_offers

1598: AND b.query_for = 'ELIG';
1599:
1600: CURSOR c_offer_type IS
1601: SELECT offer_type
1602: FROM ozf_offers
1603: WHERE qp_list_header_id = p_list_header_id;
1604:
1605:
1606: CURSOR c_elig_exists IS

Line 2064: FROM ozf_offers

2060:
2061:
2062: CURSOR c_offer_type IS
2063: SELECT offer_type
2064: FROM ozf_offers
2065: WHERE qp_list_header_id = p_list_header_id;
2066:
2067: CURSOR c_na_offer_type IS
2068: SELECT offer_type

Line 2069: FROM ozf_offers

2065: WHERE qp_list_header_id = p_list_header_id;
2066:
2067: CURSOR c_na_offer_type IS
2068: SELECT offer_type
2069: FROM ozf_offers
2070: WHERE offer_id = p_list_header_id;
2071:
2072: CURSOR c_no_products IS
2073: SELECT COUNT(DISTINCT list_line_id)

Line 2331: FROM ozf_offers o,

2327: o.confidential_flag,
2328: o.custom_setup_id,
2329: af.forecast_uom_code,
2330: o.fund_request_curr_code curr_code
2331: FROM ozf_offers o,
2332: qp_list_headers l,
2333: ozf_act_offers ao,
2334: ams_campaigns_vl ct,
2335: ozf_act_forecasts_all af

Line 2347: FROM ozf_offers

2343: and af.freeze_flag(+) = 'Y';
2344:
2345: CURSOR c_offer_changed(l_list_header_id NUMBER, l_date DATE) IS
2346: SELECT 'Y'
2347: FROM ozf_offers
2348: WHERE qp_list_header_id = l_list_header_id
2349: AND (last_update_date > l_date OR qualifier_deleted = 'Y');
2350:
2351: CURSOR c_qualifier_changed(l_list_header_id NUMBER, l_date DATE) IS

Line 2505: ozf_offers ao

2501: ozf_act_metric_facts_all fm,
2502: ozf_forecast_dimentions fp,
2503: qp_pricing_attributes qa,
2504: qp_list_lines ql,
2505: ozf_offers ao
2506: WHERE fp.obj_id = l_offer_id
2507: and fp.obj_type = 'OFFR'
2508: and fc.act_fcast_used_by_id = fp.obj_id
2509: and fc.last_scenario_id = (select max(last_scenario_id)

Line 2538: FROM qp_modifier_summary_v a, ozf_offers b

2534:
2535:
2536: CURSOR c_list_lines(ll_list_header_id NUMBER) IS
2537: SELECT DISTINCT list_line_id lline_id
2538: FROM qp_modifier_summary_v a, ozf_offers b
2539: WHERE a.list_header_id = ll_list_header_id
2540: AND b.qp_list_header_id = a.list_header_id
2541: AND b.offer_type <> 'VOLUME_OFFER'
2542: AND (a.end_date_active IS NULL

Line 2546: FROM ozf_offer_discount_products a, ozf_offers b

2542: AND (a.end_date_active IS NULL
2543: OR a.end_date_active >= SYSDATE)
2544: UNION
2545: SELECT off_discount_product_id lline_id
2546: FROM ozf_offer_discount_products a, ozf_offers b
2547: WHERE b.qp_list_header_id = ll_list_header_id
2548: AND a.offer_id = b.offer_id
2549: and b.offer_type = 'NET_ACCRUAL'
2550: AND a.excluder_flag = 'N'

Line 2561: FROM ozf_offer_discount_lines a, ozf_offers b

2557: AND arc_act_product_used_by = 'OFFR'
2558: AND excluded_flag = 'N'
2559: UNION
2560: SELECT distinct offer_discount_line_id lline_id
2561: FROM ozf_offer_discount_lines a, ozf_offers b
2562: WHERE b.qp_list_header_id = ll_list_header_id
2563: AND a.offer_id = b.offer_id
2564: AND b.offer_type = 'VOLUME_OFFER'
2565: and a.tier_type = 'PBH'

Line 2589: FROM ozf_offer_qualifiers a, ozf_offers b

2585: AND a.qualifier_attribute = b.attribute
2586: AND b.query_for = 'ELIG'
2587: UNION
2588: SELECT a.qualifier_id qnum
2589: FROM ozf_offer_qualifiers a, ozf_offers b
2590: WHERE b.qp_list_header_id = ll_list_header_id
2591: AND a.offer_id = b.offer_id
2592: AND a.active_flag = 'Y'
2593: UNION

Line 2595: FROM ozf_offers

2591: AND a.offer_id = b.offer_id
2592: AND a.active_flag = 'Y'
2593: UNION
2594: SELECT qualifier_id qnum
2595: FROM ozf_offers
2596: WHERE qp_list_header_id = ll_list_header_id
2597: AND offer_type in ('SCAN_DATA', 'LUMPSUM')
2598: UNION
2599: select -99 qnum

Line 2614: FROM ozf_offer_qualifiers a, ozf_offers b

2610: AND a.qualifier_attribute = b.attribute
2611: AND b.query_for = 'ELIG'
2612: UNION
2613: SELECT count(a.qualifier_id)
2614: FROM ozf_offer_qualifiers a, ozf_offers b
2615: WHERE b.qp_list_header_id = ll_list_header_id
2616: AND a.offer_id = b.offer_id
2617: AND a.active_flag = 'Y';
2618:

Line 2904: UPDATE ozf_offers

2900: FND_DSQL.do_binds;
2901: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2902: dbms_sql.close_cursor(l_denorm_csr);
2903:
2904: UPDATE ozf_offers
2905: SET qualifier_deleted = 'N'
2906: WHERE qp_list_header_id = i.object_id;
2907: END IF;
2908: l_group_count := l_group_count + 1;

Line 3257: UPDATE ozf_offers

3253: FND_DSQL.do_binds;
3254: l_ignore := DBMS_SQL.execute(l_denorm_csr);
3255: dbms_sql.close_cursor(l_denorm_csr);
3256:
3257: UPDATE ozf_offers
3258: SET qualifier_deleted = 'N'
3259: WHERE qp_list_header_id = i.object_id;
3260: END IF;
3261: l_group_count := l_group_count + 1;

Line 3815: FROM ozf_offers o, qp_list_headers l

3811: /*
3812: DELETE FROM ozf_activity_customers
3813: WHERE object_id IN (
3814: SELECT l.list_header_id
3815: FROM ozf_offers o, qp_list_headers l
3816: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3817: AND o.qp_list_header_id = l.list_header_id
3818: )
3819: AND object_class = 'OFFR';

Line 3824: FROM ozf_offers o, qp_list_headers l

3820:
3821: DELETE FROM ozf_activity_products
3822: WHERE object_id IN (
3823: SELECT l.list_header_id
3824: FROM ozf_offers o, qp_list_headers l
3825: WHERE o.status_code IN ('CANCELLED', 'TERMINATED', 'CLOSED')
3826: AND o.qp_list_header_id = l.list_header_id
3827: )
3828: AND object_class = 'OFFR';

Line 3834: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3830:
3831: DELETE FROM OZF_ACTIVITY_CUSTOMERS b
3832: WHERE
3833: exists ( SELECT L.LIST_HEADER_ID
3834: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3835: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3836: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3837: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3838:

Line 3842: FROM OZF_OFFERS O, QP_LIST_HEADERS L

3838:
3839: DELETE FROM OZF_ACTIVITY_PRODUCTS b
3840: WHERE
3841: exists ( SELECT L.LIST_HEADER_ID
3842: FROM OZF_OFFERS O, QP_LIST_HEADERS L
3843: WHERE O.STATUS_CODE IN ('CANCELLED', 'TERMINATED', 'CLOSED') AND
3844: O.QP_LIST_HEADER_ID = L.LIST_HEADER_ID and
3845: b.object_id = l.list_header_id ) AND OBJECT_CLASS = 'OFFR';
3846:

Line 4328: ozf_offers ao

4324: ozf_act_metric_facts_all fm,
4325: ozf_forecast_dimentions fp,
4326: qp_pricing_attributes qa,
4327: qp_list_lines ql,
4328: ozf_offers ao
4329: WHERE fp.obj_id = l_offer_id
4330: and fp.obj_type = 'OFFR'
4331: and fc.act_fcast_used_by_id = fp.obj_id
4332: and fc.last_scenario_id = (select max(last_scenario_id)