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_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 1135: FROM ozf_offer_discount_lines

1131:
1132:
1133: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
1134: SELECT discount_type,volume_type
1135: FROM ozf_offer_discount_lines
1136: WHERE offer_discount_line_id = p_discount_line_id
1137: AND tier_type = 'PBH';
1138:
1139: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 1153: FROM ozf_offer_discount_lines

1149: AND opt.qp_list_header_id = p_list_header_id;
1150:
1151: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
1152: SELECT discount
1153: FROM ozf_offer_discount_lines
1154: WHERE p_volume > volume_from
1155: AND p_volume <= volume_to
1156: AND parent_discount_line_id = p_parent_discount_id;
1157:

Line 1160: FROM ozf_offer_discount_lines

1156: AND parent_discount_line_id = p_parent_discount_id;
1157:
1158: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
1159: SELECT MIN(volume_from),MAX(volume_to)
1160: FROM ozf_offer_discount_lines
1161: WHERE parent_discount_line_id = p_parent_discount_id;
1162:
1163: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
1164: SELECT discount

Line 1165: FROM ozf_offer_discount_lines

1161: WHERE parent_discount_line_id = p_parent_discount_id;
1162:
1163: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
1164: SELECT discount
1165: FROM ozf_offer_discount_lines
1166: WHERE volume_to =p_max_volume_to
1167: AND parent_discount_line_id = p_parent_discount_id;
1168:
1169:

Line 1198: FROM ozf_offer_discount_lines

1194: AND utilization_type NOT IN ('REQUEST', 'TRANSFER');
1195:
1196: CURSOR c_prior_tiers(p_parent_discount_id IN NUMBER, p_volume IN NUMBER ) IS
1197: SELECT offer_discount_line_id ,volume_from ,volume_to, discount
1198: FROM ozf_offer_discount_lines
1199: WHERE parent_discount_line_id = p_parent_discount_id
1200: AND p_volume >= volume_from
1201: ORDER BY volume_from DESC;
1202:

Line 1205: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

1201: ORDER BY volume_from DESC;
1202:
1203: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
1204: SELECT a.discount
1205: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1206: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1207: AND b.pbh_offer_discount_id = p_pbh_line_id
1208: AND b.offer_market_option_id = c.offer_market_option_id
1209: AND c.qp_list_header_id = p_qp_list_header_id

Line 1972: ozf_offer_discount_lines orig_line

1968: SELECT DISTINCT orig_line.parent_discount_line_id offer_adjustment_line_id,
1969: --AMITAMKU Fix for bug 15935374
1970: orig_line.parent_discount_line_id to_list_line_id --null to_list_line_id
1971: FROM ozf_offer_adjustment_tiers adj_line,
1972: ozf_offer_discount_lines orig_line
1973: WHERE adj_line.offer_adjustment_id = p_offer_adjustment_id
1974: AND adj_line.offer_discount_line_id = orig_line.offer_discount_line_id;
1975:
1976:

Line 2350: ozf_offer_discount_lines orig_disc,

2346: FROM oe_order_lines_all line,
2347: ozf_adj_temp_eligibility temp,
2348: ozf_offer_adjustments_b adj,
2349: ozf_offer_adjustment_tiers adj_line,
2350: ozf_offer_discount_lines orig_disc,
2351: ozf_offers off,
2352: qp_list_headers_all qp,
2353: ozf_qp_discounts map_lines,
2354: qp_list_lines lines

Line 2534: ozf_offer_discount_lines orig_disc,

2530: FROM oe_order_lines_all line,
2531: ozf_adj_temp_eligibility temp,
2532: ozf_offer_adjustments_b adj,
2533: ozf_offer_adjustment_tiers adj_line,
2534: ozf_offer_discount_lines orig_disc,
2535: ozf_offers off,
2536: qp_list_headers_all qp,
2537: ozf_qp_discounts map_lines,
2538: qp_list_lines lines

Line 4172: FROM ozf_offer_discount_lines

4168:
4169: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
4170: SELECT discount_type,
4171: volume_type
4172: FROM ozf_offer_discount_lines
4173: WHERE offer_discount_line_id = p_discount_line_id
4174: AND tier_type = 'PBH';
4175:
4176: CURSOR party_site_id_csr(p_account_site_id IN NUMBER) IS

Line 7848: FROM ozf_offer_discount_lines

7844:
7845:
7846: CURSOR c_prior_tiers(p_parent_discount_id IN NUMBER, p_volume IN NUMBER ) IS
7847: SELECT offer_discount_line_id ,volume_from ,volume_to, discount
7848: FROM ozf_offer_discount_lines
7849: WHERE parent_discount_line_id = p_parent_discount_id
7850: AND p_volume >= volume_from
7851: ORDER BY volume_from DESC;
7852:

Line 7856: FROM ozf_offer_discount_lines

7852:
7853:
7854: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
7855: SELECT discount_type,volume_type
7856: FROM ozf_offer_discount_lines
7857: WHERE offer_discount_line_id = p_discount_line_id
7858: AND tier_type = 'PBH';
7859:
7860: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 7875: FROM ozf_offer_discount_lines

7871:
7872: --fix for bug 5975203
7873: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
7874: SELECT discount
7875: FROM ozf_offer_discount_lines
7876: WHERE p_volume > volume_from
7877: AND p_volume <= volume_to
7878: AND parent_discount_line_id = p_parent_discount_id;
7879:

Line 7891: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

7887: AND det.source_code = p_source_code;
7888: */
7889: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
7890: SELECT a.discount
7891: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
7892: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
7893: AND b.pbh_offer_discount_id = p_pbh_line_id
7894: AND b.offer_market_option_id = c.offer_market_option_id
7895: AND c.qp_list_header_id = p_qp_list_header_id

Line 7929: FROM ozf_offer_discount_lines

7925: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE');
7926:
7927: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
7928: SELECT MIN(volume_from),MAX(volume_to)
7929: FROM ozf_offer_discount_lines
7930: WHERE parent_discount_line_id = p_parent_discount_id;
7931:
7932: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
7933: SELECT discount

Line 7934: FROM ozf_offer_discount_lines

7930: WHERE parent_discount_line_id = p_parent_discount_id;
7931:
7932: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
7933: SELECT discount
7934: FROM ozf_offer_discount_lines
7935: WHERE volume_to =p_max_volume_to
7936: AND parent_discount_line_id = p_parent_discount_id;
7937:
7938: CURSOR c_offer_curr IS

Line 8039: FROM ozf_offer_discount_lines

8035:
8036: -- Catch Weight - start
8037: CURSOR c_offer_uom_code(l_offer_id NUMBER) IS
8038: SELECT uom_code
8039: FROM ozf_offer_discount_lines
8040: WHERE offer_id = l_offer_id;
8041:
8042: l_offer_uom_code VARCHAR2(10);
8043: l_quantity NUMBER;

Line 8922: FROM ozf_offer_discount_lines

8918:
8919:
8920: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
8921: SELECT discount_type,volume_type
8922: FROM ozf_offer_discount_lines
8923: WHERE offer_discount_line_id = p_discount_line_id
8924: AND tier_type = 'PBH';
8925:
8926: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 8940: FROM ozf_offer_discount_lines

8936: AND opt.qp_list_header_id = p_list_header_id;
8937:
8938: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
8939: SELECT discount
8940: FROM ozf_offer_discount_lines
8941: WHERE p_volume > volume_from
8942: AND p_volume <= volume_to
8943: AND parent_discount_line_id = p_parent_discount_id;
8944:

Line 8947: FROM ozf_offer_discount_lines

8943: AND parent_discount_line_id = p_parent_discount_id;
8944:
8945: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
8946: SELECT MIN(volume_from),MAX(volume_to)
8947: FROM ozf_offer_discount_lines
8948: WHERE parent_discount_line_id = p_parent_discount_id;
8949:
8950: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
8951: SELECT discount

Line 8952: FROM ozf_offer_discount_lines

8948: WHERE parent_discount_line_id = p_parent_discount_id;
8949:
8950: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
8951: SELECT discount
8952: FROM ozf_offer_discount_lines
8953: WHERE volume_to =p_max_volume_to
8954: AND parent_discount_line_id = p_parent_discount_id;
8955:
8956: CURSOR c_order_line_info(p_order_line_id IN NUMBER) IS

Line 9029: FROM ozf_offer_discount_lines

9025:
9026:
9027: CURSOR c_prior_tiers(p_parent_discount_id IN NUMBER, p_volume IN NUMBER ) IS
9028: SELECT offer_discount_line_id ,volume_from ,volume_to, discount
9029: FROM ozf_offer_discount_lines
9030: WHERE parent_discount_line_id = p_parent_discount_id
9031: AND p_volume >= volume_from
9032: ORDER BY volume_from DESC;
9033:

Line 9036: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c

9032: ORDER BY volume_from DESC;
9033:
9034: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
9035: SELECT a.discount
9036: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
9037: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
9038: AND b.pbh_offer_discount_id = p_pbh_line_id
9039: AND b.offer_market_option_id = c.offer_market_option_id
9040: AND c.qp_list_header_id = p_qp_list_header_id