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 OE_PRICE_ADJUSTMENTS

Line 4003: FROM oe_price_adjustments

3999:
4000:
4001: CURSOR line_adjustment_csr IS
4002: SELECT 1
4003: FROM oe_price_adjustments
4004: WHERE line_id = p_line_id
4005: AND list_header_id = p_list_header_id
4006: AND list_line_id IN (SELECT from_list_line_id
4007: FROM ozf_offer_adj_rltd_lines

Line 4016: FROM oe_price_adjustments

4012:
4013: --for volume offer, duplicate item cannot be added to the offer.
4014: CURSOR hdr_adjustment_csr IS
4015: SELECT 1
4016: FROM oe_price_adjustments
4017: WHERE line_id = p_line_id
4018: AND list_header_id = p_list_header_id;
4019:
4020: BEGIN

Line 5840: -- 2) No record should be present in oe_price_adjustments - taken care by perform_adj API (regular adj)

5836: IF l_ldets_tbl(k).list_line_type_code IN ('CIE', 'DIS', 'IUE', 'OID', 'PLL', 'PMR', 'TSN','PBH') THEN
5837: -- create utilization based on an offer
5838:
5839: -- only accrue for 1) TM offers,
5840: -- 2) No record should be present in oe_price_adjustments - taken care by perform_adj API (regular adj)
5841: -- 3) has a valid active adjustment i.e. a record exists in p_adjIdByListHdrId
5842: IF (l_ldets_tbl(k).applied_flag = 'Y' AND
5843: l_ldets_tbl(k).accrual_flag = 'N'
5844: )

Line 6032: oe_price_adjustments oe

6028: FROM ozf_funds_utilized_all_b util,
6029: ozf_temp_eligibility temp,
6030: ozf_offer_adjustment_lines adjl,
6031: oe_order_lines_all ol,
6032: oe_price_adjustments oe
6033: WHERE util.plan_type = 'OFFR'
6034: AND product_id IS NOT NULL
6035: AND util.plan_id = p_qp_list_header_id
6036: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 6126: oe_price_adjustments oe,

6122: ((adjl.modified_discount - oe.operand) * amount / oe.operand)
6123: ) amount
6124: FROM ozf_funds_utilized_all_b util,
6125: oe_price_adj_assocs assocs,
6126: oe_price_adjustments oe,
6127: ozf_offer_adjustment_lines adjl,
6128: ozf_temp_eligibility temp
6129: WHERE util.plan_id = p_qp_list_header_id
6130: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 6174: oe_price_adjustments oe

6170: FROM ozf_funds_utilized_all_b util,
6171: ozf_temp_eligibility temp,
6172: ozf_offer_adjustment_lines adjl,
6173: oe_order_lines_all ol,
6174: oe_price_adjustments oe
6175: WHERE util.plan_type = 'OFFR'
6176: AND product_id IS NOT NULL
6177: AND util.plan_id = p_qp_list_header_id
6178: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 6278: oe_price_adjustments oe

6274: FROM ozf_funds_utilized_all_b util,
6275: ozf_temp_eligibility temp,
6276: ozf_offer_adjustment_lines adjl,
6277: oe_order_lines_all ol,
6278: oe_price_adjustments oe
6279: WHERE util.plan_type = 'OFFR'
6280: AND product_id IS NOT NULL
6281: AND util.plan_id = p_qp_list_header_id
6282: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 6375: oe_price_adjustments oe

6371: ,util.exchange_rate_type
6372: FROM ozf_funds_utilized_all_b util,
6373: ozf_offer_adjustment_lines adjl,
6374: oe_order_lines_all ol,
6375: oe_price_adjustments oe
6376: WHERE util.plan_type = 'OFFR'
6377: AND util.plan_id = p_qp_list_header_id
6378: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
6379: -- AND adjl.list_line_id = oe.list_line_id

Line 6425: oe_price_adjustments oe

6421: FROM ozf_funds_utilized_all_b util,
6422: ozf_temp_eligibility temp,
6423: ozf_offer_adjustment_lines adjl,
6424: oe_order_lines_all ol,
6425: oe_price_adjustments oe
6426: WHERE util.plan_type = 'OFFR'
6427: AND product_id IS NOT NULL
6428: AND util.plan_id = p_qp_list_header_id
6429: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 7552: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header

7548: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
7549: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
7550: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
7551: ), header.transactional_curr_code
7552: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
7553: WHERE line.line_id = adj.line_id
7554: AND line.header_id = header.header_id
7555: AND line.header_id = adj.header_id
7556: AND adj.list_header_id = p_list_header_id

Line 7570: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header

7566: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
7567: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
7568: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
7569: ), header.transactional_curr_code
7570: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
7571: WHERE line.line_id = adj.line_id
7572: AND line.header_id = header.header_id
7573: AND line.header_id = adj.header_id
7574: AND adj.list_header_id = p_list_header_id

Line 7910: FROM oe_price_adjustments

7906: AND liability_flag = 'N';
7907:
7908: CURSOR c_unit_discount(p_order_line_id IN NUMBER, p_price_adjust_id NUMBER) IS
7909: SELECT SUM(adjusted_amount_per_pqty)
7910: FROM oe_price_adjustments
7911: WHERE line_id = p_order_line_id
7912: AND accrual_flag = 'N'
7913: AND applied_flag = 'Y'
7914: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE')

Line 7916: (SELECT pricing_group_sequence FROM oe_price_adjustments

7912: AND accrual_flag = 'N'
7913: AND applied_flag = 'Y'
7914: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE')
7915: and pricing_group_sequence <
7916: (SELECT pricing_group_sequence FROM oe_price_adjustments
7917: WHERE price_Adjustment_id = p_price_adjust_id) ;
7918:
7919: CURSOR c_discount(p_order_line_id IN NUMBER, p_price_adjust_id NUMBER) IS
7920: SELECT SUM(adjusted_amount_per_pqty)

Line 7921: FROM oe_price_adjustments

7917: WHERE price_Adjustment_id = p_price_adjust_id) ;
7918:
7919: CURSOR c_discount(p_order_line_id IN NUMBER, p_price_adjust_id NUMBER) IS
7920: SELECT SUM(adjusted_amount_per_pqty)
7921: FROM oe_price_adjustments
7922: WHERE line_id = p_order_line_id
7923: AND accrual_flag = 'N'
7924: AND applied_flag = 'Y'
7925: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE');