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 47: FROM ozf_offers a, ozf_offer_adjustments_b b, ozf_offer_adj_new_lines c

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

Line 95: FROM ozf_offer_adjustments_b

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

Line 128: FROM ozf_offer_adjustments_b a

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

Line 2112: , ozf_offer_adjustments_b b

2108: , nvl(a.modified_discount_td, a.original_discount_td) discount_td
2109: , a.discount_end_date
2110: , h.start_date_active
2111: FROM ozf_offer_adjustment_lines a
2112: , ozf_offer_adjustments_b b
2113: , qp_list_headers_b h
2114: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2115: AND a.list_header_id = h.list_header_id
2116: AND a.list_header_id = a.list_header_id

Line 2912: FROM ozf_offers a, ozf_offer_adjustments_b b

2908: IS
2909: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
2910: SELECT
2911: offer_type
2912: FROM ozf_offers a, ozf_offer_adjustments_b b
2913: WHERE a.qp_list_header_id = b.list_header_id
2914: AND b.offer_adjustment_id = cp_offerAdjustmentId;
2915: l_offerType c_offerType%ROWTYPE;
2916: BEGIN

Line 3000: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c

2996: , b.end_date_active
2997: , c.effective_date
2998: , c.list_header_id
2999: FROM
3000: ozf_offer_adj_new_products a, ozf_offer_adj_new_lines b , ozf_offer_adjustments_b c
3001: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3002: AND a.excluder_flag = 'N'
3003: AND b.offer_adjustment_id = c.offer_adjustment_id
3004: AND b.offer_adj_new_line_id = cp_offerAdjNewLineId;

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

3225: , b.product_attr_value
3226: , b.uom_code
3227: , c.effective_date
3228: , c.list_header_id
3229: FROM ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b, ozf_offer_adjustments_b c
3230: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3231: AND a.offer_adjustment_id = c.offer_adjustment_id
3232: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3233:

Line 3511: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c

3507: , b.uom_code
3508: , c.list_header_id
3509: , c.effective_date
3510: FROM
3511: ozf_offer_adj_new_lines a, ozf_offer_adj_new_products b , ozf_offer_adjustments_b c
3512: WHERE a.offer_adj_new_line_id = b.offer_adj_new_line_id
3513: AND a.offer_adjustment_id = c.offer_adjustment_id
3514: and a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3515: i NUMBER;

Line 3949: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c

3945: , b.list_header_id
3946: , decode(c.offer_type,'ACCRUAL','Y','N') accrual_flag
3947: , c.modifier_level_code
3948: FROM
3949: ozf_offer_adj_new_lines a, ozf_offer_adjustments_b b, ozf_offers c
3950: WHERE a.offer_adjustment_id = b.offer_adjustment_id
3951: AND b.list_header_id = c.qp_list_header_id
3952: AND a.offer_adj_new_line_id = cp_offerAdjNewLineId;
3953: i NUMBER;

Line 4598: FROM ozf_offers a, ozf_offer_adjustments_b b

4594: IS
4595: CURSOR c_offerType(cp_offerAdjustmentId NUMBER) IS
4596: SELECT
4597: offer_type
4598: FROM ozf_offers a, ozf_offer_adjustments_b b
4599: WHERE a.qp_list_header_id = b.list_header_id
4600: AND b.offer_adjustment_id = cp_offerAdjustmentId;
4601: l_offerType c_offerType%ROWTYPE;
4602: BEGIN

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

4659: CURSOR c_dates(cp_offerAdjustmentId NUMBER) IS
4660: SELECT a.effective_date , b.start_date_active , a.list_header_id
4661: ,c.offer_type , c.object_version_number
4662: ,c.custom_setup_id
4663: FROM ozf_offer_adjustments_b a, qp_list_headers_b b , ozf_offers c
4664: WHERE a.list_header_id = b.list_header_id
4665: AND b.list_header_id = c.qp_list_header_id
4666: AND a.offer_adjustment_id = cp_offerAdjustmentId ;
4667: