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_ACCRUAL_ENGINE dependencies on OE_PRICE_ADJUSTMENTS

Line 68: -- 06/26/2005 Ribha fixed bug 4173825 - get adjusted_amount from oe_price_adjustments

64: -- 06/08/2005 kdass Bug 4415878 SQL Repository Fix - added the column object_id to the cursor c_old_adjustment_amount
65: -- in procedure adjust_changed_order. Now passed object_id to the cursor c_split_line
66: -- and added condition - AND header_id = p_header_id
67: -- 06/12/2005 Ribha R12 Changes - populate new columns bill_to_site_use_id/ship_to_site_use_id in ozf_funds_utilized_all_b
68: -- 06/26/2005 Ribha fixed bug 4173825 - get adjusted_amount from oe_price_adjustments
69: -- 06/26/2005 Ribha fixed bug 4417084 - for partial return order
70: -- 07/27/2005 Feliu add enhancement for R12 to insert order info to ozf_sales_transaction table.
71: -- 08/01/2005 Ribha R12: populate universal currency amount in ozf_funds_utilized_all_b
72: -- 08/02/2005 Ribha R12: populate new table ozf_object_fund_summary

Line 974: FROM oe_price_adjustments

970: WHERE qp_list_header_id = p_offer_id;
971:
972: CURSOR c_accrual_flag (p_price_adjustment_id IN NUMBER) IS
973: SELECT NVL(accrual_flag,'N')
974: FROM oe_price_adjustments
975: WHERE price_Adjustment_id = p_price_Adjustment_id;
976:
977: CURSOR c_parent (p_fund_id IN NUMBER)IS
978: SELECT fund_id

Line 1103: --if formula is specified on offer line, then operand in oe_price_adjustments is not correct,

1099: FROM ozf_sys_parameters_all
1100: WHERE org_id = p_org_id;
1101:
1102: --kdass - bug 9470625
1103: --if formula is specified on offer line, then operand in oe_price_adjustments is not correct,
1104: --query it from qp_list_lines table
1105: CURSOR c_sd_offer_discount (p_price_adjustment_id IN NUMBER) IS
1106: SELECT NVL2(qpll.price_by_formula_id, qpll.operand, oe.operand),
1107: oe.arithmetic_operator

Line 1108: FROM oe_price_adjustments oe, qp_list_lines qpll

1104: --query it from qp_list_lines table
1105: CURSOR c_sd_offer_discount (p_price_adjustment_id IN NUMBER) IS
1106: SELECT NVL2(qpll.price_by_formula_id, qpll.operand, oe.operand),
1107: oe.arithmetic_operator
1108: FROM oe_price_adjustments oe, qp_list_lines qpll
1109: WHERE oe.price_adjustment_id = p_price_adjustment_id
1110: AND oe.list_line_id = qpll.list_line_id;
1111:
1112: --fix for bug 13742169

Line 2421: FROM oe_price_adjustments adj

2417:
2418: -- Added by rimehrot for R12
2419: CURSOR c_get_price_adj_dtl (p_price_adjustment_id IN NUMBER) IS
2420: SELECT creation_date
2421: FROM oe_price_adjustments adj
2422: WHERE adj.price_Adjustment_id = p_price_adjustment_id;
2423:
2424: CURSOR c_cust_number (p_header_id IN NUMBER) IS
2425: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id

Line 2883: FROM oe_price_adjustments

2879:
2880: -- Added adjusted_amount for bug fix 4173825
2881: CURSOR c_mod_level (p_price_ad_id IN NUMBER) IS
2882: SELECT modifier_level_code,range_break_quantity, adjusted_amount, operand, arithmetic_operator --ER9447673
2883: FROM oe_price_adjustments
2884: WHERE price_adjustment_id = p_price_ad_id;
2885:
2886: l_operand NUMBER;
2887: l_arithmetic_operator VARCHAR2(30);

Line 3863: FROM oe_price_adjustments

3859: adjusted_amount, -- yzhao: 03/21/2003 added following 2 for shipped order
3860: header_id,
3861: operand,
3862: arithmetic_operator
3863: FROM oe_price_adjustments
3864: WHERE line_id = p_line_id;
3865:
3866: -- used for cancelled order and partial ship.
3867: CURSOR c_old_adjustment_amount (p_price_adjustment_id IN NUMBER) IS

Line 3912: FROM oe_price_adjustments

3908: , plan_curr_amount, plan_curr_amount_remaining
3909: , univ_curr_amount
3910: FROM ozf_funds_utilized_all_b
3911: WHERE price_adjustment_id IN (SELECT price_adjustment_id
3912: FROM oe_price_adjustments
3913: WHERE line_id = p_line_id)
3914: AND gl_posted_flag = G_GL_FLAG_NO -- 'N'
3915: AND object_type = 'ORDER'
3916: -- 05/11/2004 kdass fixed bug 3609771 - added UTILIZED to query

Line 3959: FROM oe_price_adjustments

3955:
3956: -- add by feliu on 08/03/04, get price_adjustment_id to use in create postivie adjustment.
3957: CURSOR c_new_adj_line(p_line_id IN NUMBER, p_header_id IN NUMBER) IS
3958: SELECT price_adjustment_id
3959: FROM oe_price_adjustments
3960: WHERE line_id = p_line_id
3961: AND list_header_id = p_header_id;
3962: -- add by feliu on 08/03/04, get max utilization id to use in create adjustment.
3963: CURSOR c_max_utilized_id(p_price_adj_id IN NUMBER) IS

Line 4081: FROM oe_price_adjustments

4077: AND parent_discount_line_id = p_parent_discount_id;
4078:
4079: CURSOR c_discount(p_order_line_id IN NUMBER) IS
4080: SELECT SUM(adjusted_amount_per_pqty)
4081: FROM oe_price_adjustments
4082: WHERE line_id = p_order_line_id
4083: AND accrual_flag = 'N'
4084: AND applied_flag = 'Y'
4085: -- AND list_line_type_code IN ('DIS', 'SUR', 'PBH', 'FREIGHT_CHARGE');

Line 4720: AND EXISTS(select price_adjustment_id from oe_price_adjustments where price_adjustment_id = futb.price_adjustment_id); --ninarasi fix for bug 14750730/14695150

4716: SET gl_posted_flag = 'F'
4717: ,gl_date = NULL
4718: WHERE futb.order_line_id = p_line_tbl(i).line_id
4719: AND futb.gl_posted_flag <> 'Y' --bug 13517522 - added this condition so that duplicate ASO message should not re-post accrual to GL
4720: AND EXISTS(select price_adjustment_id from oe_price_adjustments where price_adjustment_id = futb.price_adjustment_id); --ninarasi fix for bug 14750730/14695150
4721:
4722: IF g_debug_flag = 'Y' THEN
4723: OZF_UTILITY_PVT.write_conc_log(' D: adjust_changed_order() auto-invoice not complete. gl posting failed');
4724: END IF;

Line 5713: ozf_offers off, oe_price_adjustments oe,

5709: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) ShippedQuantity,
5710: (NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0))*line.unit_selling_price) Revenue,
5711: NVL(util.plan_curr_amount,0) AccrualAmount
5712: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,
5713: ozf_offers off, oe_price_adjustments oe,
5714: ozf_xref_map map
5715: WHERE line.line_id = util.order_line_id
5716: AND line.header_id = util.object_id
5717: AND util.object_type = ''ORDER''

Line 5741: ozf_offers off, oe_price_adjustments oe,

5737: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) ShippedQuantity,
5738: (NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0))*line.unit_selling_price) Revenue,
5739: NVL(util.plan_curr_amount,0) AccrualAmount
5740: FROM oe_order_lines_all line, ozf_funds_utilized_all_b util,
5741: ozf_offers off, oe_price_adjustments oe,
5742: ozf_xref_map map
5743: WHERE line.line_id = util.order_line_id
5744: AND line.header_id = util.object_id
5745: AND util.object_type = ''ORDER''

Line 6403: , oe_price_adjustments price

6399: CURSOR c_get_invoice_status(p_price_adjustment_id IN NUMBER, p_order_number IN VARCHAR2) IS
6400: SELECT customer_trx_line_id, cust.trx_date
6401: FROM ra_customer_trx_all cust
6402: , ra_customer_trx_lines_all cust_lines
6403: , oe_price_adjustments price
6404: WHERE price.price_adjustment_id = p_price_adjustment_id
6405: AND cust_lines.customer_trx_line_id IS NOT NULL
6406: AND interface_line_context = 'ORDER ENTRY'
6407: AND cust_lines.interface_line_attribute6 = TO_CHAR(price.line_id)