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 2119: oe_price_adjustments oe

2115: FROM ozf_funds_utilized_all_b util,
2116: ozf_temp_eligibility temp,
2117: ozf_offer_adjustment_lines adjl,
2118: oe_order_lines_all ol,
2119: oe_price_adjustments oe
2120: WHERE util.plan_type = 'OFFR'
2121: AND product_id IS NOT NULL
2122: AND util.plan_id = p_qp_list_header_id
2123: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 2199: oe_price_adjustments oe,

2195: ((adjl.modified_discount - oe.operand) * amount / oe.operand)
2196: ) amount
2197: FROM ozf_funds_utilized_all_b util,
2198: oe_price_adj_assocs assocs,
2199: oe_price_adjustments oe,
2200: ozf_offer_adjustment_lines adjl,
2201: ozf_temp_eligibility temp
2202: WHERE util.plan_id = p_qp_list_header_id
2203: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 2245: oe_price_adjustments oe

2241: FROM ozf_funds_utilized_all_b util,
2242: ozf_temp_eligibility temp,
2243: ozf_offer_adjustment_lines adjl,
2244: oe_order_lines_all ol,
2245: oe_price_adjustments oe
2246: WHERE util.plan_type = 'OFFR'
2247: AND product_id IS NOT NULL
2248: AND util.plan_id = p_qp_list_header_id
2249: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 2334: oe_price_adjustments oe

2330: FROM ozf_funds_utilized_all_b util,
2331: ozf_temp_eligibility temp,
2332: ozf_offer_adjustment_lines adjl,
2333: oe_order_lines_all ol,
2334: oe_price_adjustments oe
2335: WHERE util.plan_type = 'OFFR'
2336: AND product_id IS NOT NULL
2337: AND util.plan_id = p_qp_list_header_id
2338: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

Line 2416: oe_price_adjustments oe

2412: ,util.reference_id
2413: FROM ozf_funds_utilized_all_b util,
2414: ozf_offer_adjustment_lines adjl,
2415: oe_order_lines_all ol,
2416: oe_price_adjustments oe
2417: WHERE util.plan_type = 'OFFR'
2418: AND util.plan_id = p_qp_list_header_id
2419: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id
2420: -- AND adjl.list_line_id = oe.list_line_id

Line 2464: oe_price_adjustments oe

2460: FROM ozf_funds_utilized_all_b util,
2461: ozf_temp_eligibility temp,
2462: ozf_offer_adjustment_lines adjl,
2463: oe_order_lines_all ol,
2464: oe_price_adjustments oe
2465: WHERE util.plan_type = 'OFFR'
2466: AND product_id IS NOT NULL
2467: AND util.plan_id = p_qp_list_header_id
2468: AND util.product_id = DECODE (temp.eligibility_id, -1, util.product_id, temp.eligibility_id)

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

3509: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
3510: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
3511: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
3512: ), header.transactional_curr_code
3513: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
3514: WHERE line.line_id = adj.line_id
3515: AND line.header_id = header.header_id
3516: AND line.header_id = adj.header_id
3517: AND adj.list_header_id = p_list_header_id

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

3527: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
3528: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
3529: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
3530: ), header.transactional_curr_code
3531: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
3532: WHERE line.line_id = adj.line_id
3533: AND line.header_id = header.header_id
3534: AND line.header_id = adj.header_id
3535: AND adj.list_header_id = p_list_header_id

Line 3854: FROM oe_price_adjustments

3850: AND liability_flag = 'N';
3851:
3852: CURSOR c_unit_discount(p_order_line_id IN NUMBER, p_price_adjust_id NUMBER) IS
3853: SELECT SUM(adjusted_amount_per_pqty)
3854: FROM oe_price_adjustments
3855: WHERE line_id = p_order_line_id
3856: AND accrual_flag = 'N'
3857: AND applied_flag = 'Y'
3858: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE')

Line 3860: (SELECT pricing_group_sequence FROM oe_price_adjustments

3856: AND accrual_flag = 'N'
3857: AND applied_flag = 'Y'
3858: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE')
3859: and pricing_group_sequence <
3860: (SELECT pricing_group_sequence FROM oe_price_adjustments
3861: WHERE price_Adjustment_id = p_price_adjust_id) ;
3862:
3863: CURSOR c_discount(p_order_line_id IN NUMBER, p_price_adjust_id NUMBER) IS
3864: SELECT SUM(adjusted_amount_per_pqty)

Line 3865: FROM oe_price_adjustments

3861: WHERE price_Adjustment_id = p_price_adjust_id) ;
3862:
3863: CURSOR c_discount(p_order_line_id IN NUMBER, p_price_adjust_id NUMBER) IS
3864: SELECT SUM(adjusted_amount_per_pqty)
3865: FROM oe_price_adjustments
3866: WHERE line_id = p_order_line_id
3867: AND accrual_flag = 'N'
3868: AND applied_flag = 'Y'
3869: AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE');