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.

[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 975: FROM ozf_offer_discount_lines

971:
972:
973: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
974: SELECT discount_type,volume_type
975: FROM ozf_offer_discount_lines
976: WHERE offer_discount_line_id = p_discount_line_id
977: AND tier_type = 'PBH';
978:
979: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 993: FROM ozf_offer_discount_lines

989: AND opt.qp_list_header_id = p_list_header_id;
990:
991: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
992: SELECT discount
993: FROM ozf_offer_discount_lines
994: WHERE p_volume > volume_from
995: AND p_volume <= volume_to
996: AND parent_discount_line_id = p_parent_discount_id;
997:

Line 1000: FROM ozf_offer_discount_lines

996: AND parent_discount_line_id = p_parent_discount_id;
997:
998: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
999: SELECT MIN(volume_from),MAX(volume_to)
1000: FROM ozf_offer_discount_lines
1001: WHERE parent_discount_line_id = p_parent_discount_id;
1002:
1003: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
1004: SELECT discount

Line 1005: FROM ozf_offer_discount_lines

1001: WHERE parent_discount_line_id = p_parent_discount_id;
1002:
1003: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
1004: SELECT discount
1005: FROM ozf_offer_discount_lines
1006: WHERE volume_to =p_max_volume_to
1007: AND parent_discount_line_id = p_parent_discount_id;
1008:
1009:

Line 1037: FROM ozf_offer_discount_lines

1033: AND utilization_type NOT IN ('REQUEST', 'TRANSFER');
1034:
1035: CURSOR c_prior_tiers(p_parent_discount_id IN NUMBER, p_volume IN NUMBER ) IS
1036: SELECT offer_discount_line_id ,volume_from ,volume_to, discount
1037: FROM ozf_offer_discount_lines
1038: WHERE parent_discount_line_id = p_parent_discount_id
1039: AND p_volume >= volume_from
1040: ORDER BY volume_from DESC;
1041:

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

1040: ORDER BY volume_from DESC;
1041:
1042: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
1043: SELECT a.discount
1044: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
1045: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
1046: AND b.pbh_offer_discount_id = p_pbh_line_id
1047: AND b.offer_market_option_id = c.offer_market_option_id
1048: AND c.qp_list_header_id = p_qp_list_header_id

Line 3792: FROM ozf_offer_discount_lines

3788:
3789:
3790: CURSOR c_prior_tiers(p_parent_discount_id IN NUMBER, p_volume IN NUMBER ) IS
3791: SELECT offer_discount_line_id ,volume_from ,volume_to, discount
3792: FROM ozf_offer_discount_lines
3793: WHERE parent_discount_line_id = p_parent_discount_id
3794: AND p_volume >= volume_from
3795: ORDER BY volume_from DESC;
3796:

Line 3800: FROM ozf_offer_discount_lines

3796:
3797:
3798: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
3799: SELECT discount_type,volume_type
3800: FROM ozf_offer_discount_lines
3801: WHERE offer_discount_line_id = p_discount_line_id
3802: AND tier_type = 'PBH';
3803:
3804: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 3819: FROM ozf_offer_discount_lines

3815:
3816: --fix for bug 5975203
3817: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
3818: SELECT discount
3819: FROM ozf_offer_discount_lines
3820: WHERE p_volume > volume_from
3821: AND p_volume <= volume_to
3822: AND parent_discount_line_id = p_parent_discount_id;
3823:

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

3831: AND det.source_code = p_source_code;
3832: */
3833: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
3834: SELECT a.discount
3835: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
3836: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
3837: AND b.pbh_offer_discount_id = p_pbh_line_id
3838: AND b.offer_market_option_id = c.offer_market_option_id
3839: AND c.qp_list_header_id = p_qp_list_header_id

Line 3873: FROM ozf_offer_discount_lines

3869: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE');
3870:
3871: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
3872: SELECT MIN(volume_from),MAX(volume_to)
3873: FROM ozf_offer_discount_lines
3874: WHERE parent_discount_line_id = p_parent_discount_id;
3875:
3876: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
3877: SELECT discount

Line 3878: FROM ozf_offer_discount_lines

3874: WHERE parent_discount_line_id = p_parent_discount_id;
3875:
3876: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
3877: SELECT discount
3878: FROM ozf_offer_discount_lines
3879: WHERE volume_to =p_max_volume_to
3880: AND parent_discount_line_id = p_parent_discount_id;
3881:
3882: CURSOR c_offer_curr IS

Line 4632: FROM ozf_offer_discount_lines

4628:
4629:
4630: CURSOR c_discount_header(p_discount_line_id IN NUMBER) IS
4631: SELECT discount_type,volume_type
4632: FROM ozf_offer_discount_lines
4633: WHERE offer_discount_line_id = p_discount_line_id
4634: AND tier_type = 'PBH';
4635:
4636: CURSOR c_get_group(p_order_line_id IN NUMBER,p_list_header_id IN NUMBER) IS

Line 4650: FROM ozf_offer_discount_lines

4646: AND opt.qp_list_header_id = p_list_header_id;
4647:
4648: CURSOR c_current_discount(p_volume IN NUMBER, p_parent_discount_id IN NUMBER) IS
4649: SELECT discount
4650: FROM ozf_offer_discount_lines
4651: WHERE p_volume > volume_from
4652: AND p_volume <= volume_to
4653: AND parent_discount_line_id = p_parent_discount_id;
4654:

Line 4657: FROM ozf_offer_discount_lines

4653: AND parent_discount_line_id = p_parent_discount_id;
4654:
4655: CURSOR c_get_tier_limits (p_parent_discount_id IN NUMBER) IS
4656: SELECT MIN(volume_from),MAX(volume_to)
4657: FROM ozf_offer_discount_lines
4658: WHERE parent_discount_line_id = p_parent_discount_id;
4659:
4660: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
4661: SELECT discount

Line 4662: FROM ozf_offer_discount_lines

4658: WHERE parent_discount_line_id = p_parent_discount_id;
4659:
4660: CURSOR c_get_max_tier (p_max_volume_to IN NUMBER,p_parent_discount_id IN NUMBER) IS
4661: SELECT discount
4662: FROM ozf_offer_discount_lines
4663: WHERE volume_to =p_max_volume_to
4664: AND parent_discount_line_id = p_parent_discount_id;
4665:
4666: CURSOR c_order_line_info(p_order_line_id IN NUMBER) IS

Line 4739: FROM ozf_offer_discount_lines

4735:
4736:
4737: CURSOR c_prior_tiers(p_parent_discount_id IN NUMBER, p_volume IN NUMBER ) IS
4738: SELECT offer_discount_line_id ,volume_from ,volume_to, discount
4739: FROM ozf_offer_discount_lines
4740: WHERE parent_discount_line_id = p_parent_discount_id
4741: AND p_volume >= volume_from
4742: ORDER BY volume_from DESC;
4743:

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

4742: ORDER BY volume_from DESC;
4743:
4744: CURSOR c_preset_tier(p_pbh_line_id IN NUMBER, p_qp_list_header_id IN NUMBER,p_group_id IN NUMBER) IS
4745: SELECT a.discount
4746: FROM ozf_offer_discount_lines a, ozf_market_preset_tiers b, ozf_offr_market_options c
4747: WHERE a.offer_discount_line_id = b.dis_offer_discount_id
4748: AND b.pbh_offer_discount_id = p_pbh_line_id
4749: AND b.offer_market_option_id = c.offer_market_option_id
4750: AND c.qp_list_header_id = p_qp_list_header_id