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_OFFER_ADJ_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 45: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c

41: RETURN VARCHAR2
42: IS
43: CURSOR c_offerType(cp_offerAdjNewLineId NUMBER) IS
44: SELECT offer_type
45: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c
46: WHERE
47: a.qp_list_header_id = b.list_header_id
48: AND b.offer_adjustment_id = c.offer_adjustment_id
49: AND c.offer_adj_new_line_id = cp_offerAdjNewLineId;

Line 93: FROM ozf_offer_adjustments_b

89: RETURN DATE IS
90: l_effectiveDate DATE;
91: CURSOR c_effectiveDate(cp_offerAdjustmentId NUMBER) IS
92: SELECT effective_date
93: FROM ozf_offer_adjustments_b
94: WHERE offer_adjustment_id = cp_offerAdjustmentId;
95: BEGIN
96: l_effectiveDate := null;
97:

Line 126: FROM ozf_offer_adjustments_b a

122: ,a.effective_date
123: INTO l_headerStDt
124: ,l_lineStDt
125: ,l_effectiveDt
126: FROM ozf_offer_adjustments_b a
127: ,qp_list_headers_b h
128: ,qp_list_lines l
129: WHERE a.list_header_id = h.list_header_id
130: and a.list_header_id = l.list_header_id

Line 1854: FROM ozf_offer_adjustment_lines a, ozf_offer_adjustments_b b

1850: CURSOR c_tdCrtLineDetails(cp_offerAdjustmentId NUMBER, cp_listLineId NUMBER) IS
1851: SELECT b.effective_date
1852: , nvl(a.modified_discount,a.original_discount) discount
1853: , nvl(a.modified_discount_td, a.original_discount_td) discount_td
1854: FROM ozf_offer_adjustment_lines a, ozf_offer_adjustments_b b
1855: WHERE a.offer_adjustment_id = b.offer_adjustment_id
1856: AND a.offer_adjustment_id = cp_offerAdjustmentId
1857: AND a.list_line_id = cp_listLineId;
1858: BEGIN

Line 2628: FROM ozf_offers a, ozf_offer_adjustments_b b

2624: IS
2625: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
2626: SELECT
2627: offer_type
2628: FROM ozf_offers a, ozf_offer_adjustments_b b
2629: WHERE a.qp_list_header_id = b.list_header_id
2630: AND b.offer_adjustment_id = cp_offerAdjustmentId;
2631: l_offerType c_offerType%ROWTYPE;
2632: BEGIN

Line 2716: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c

2712: , b.end_date_active
2713: , c.effective_date
2714: , c.list_header_id
2715: FROM
2716: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c
2717: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
2718: AND a.excluder_flag = 'N'
2719: AND b.offer_adjustment_id = c.offer_adjustment_id
2720: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;

Line 2945: FROM ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b, ozf_offer_adjustments_b c

2941: , b.product_attr_value
2942: , b.uom_code
2943: , c.effective_date
2944: , c.list_header_id
2945: FROM ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b, ozf_offer_adjustments_b c
2946: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
2947: AND a.offer_adjustment_id = c.offer_adjustment_id
2948: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
2949:

Line 3227: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c

3223: , b.uom_code
3224: , c.list_header_id
3225: , c.effective_date
3226: FROM
3227: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c
3228: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3229: AND a.offer_adjustment_id = c.offer_adjustment_id
3230: and a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3231: i NUMBER;

Line 3403: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c

3399: , b.list_header_id
3400: , decode(c.offer_type,'ACCRUAL','Y','N') accrual_flag
3401: , c.modifier_level_code
3402: FROM
3403: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c
3404: WHERE a.offer_adjustment_id = b.offer_adjustment_id
3405: AND b.list_header_id = c.qp_list_header_id
3406: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3407: i NUMBER;

Line 4052: FROM ozf_offers a, ozf_offer_adjustments_b b

4048: IS
4049: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
4050: SELECT
4051: offer_type
4052: FROM ozf_offers a, ozf_offer_adjustments_b b
4053: WHERE a.qp_list_header_id = b.list_header_id
4054: AND b.offer_adjustment_id = cp_offerAdjustmentId;
4055: l_offerType c_offerType%ROWTYPE;
4056: BEGIN

Line 4115: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c

4111: )
4112: IS
4113: CURSOR c_dates(cp_offerAdjustmentId NUMBER) IS
4114: SELECT a.effective_date , b.start_date_active , a.list_header_id , c.offer_type , c.object_version_number
4115: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c
4116: WHERE a.list_header_id = b.list_header_id
4117: AND b.list_header_id = c.qp_list_header_id
4118: AND a.offer_adjustment_id = cp_offerAdjustmentId ;
4119: