APPS.OZF_ACCRUAL_ENGINE dependencies on RA_CUSTOMER_TRX_ALL

Line 62: -- 14/10/2004 Ribha Fixed Performance Bug 3917556 for queries on ra_customer_trx_all

58: -- populate reference_type/id for special pricing
59: -- 05/11/2004 kdass fixed bug 3609771
60: -- 06/10/2004 feliu fixed bug 3667697,3684809
61: -- 08/03/2004 feliu fixed bug 3813516.
62: -- 14/10/2004 Ribha Fixed Performance Bug 3917556 for queries on ra_customer_trx_all
63: -- 01/31/2005 kdass fixed 11.5.9 bug 4067266
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

Line 3051: FROM ra_customer_trx_all cust

3047: WHERE line_id = p_line_id;
3048:
3049: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
3050: SELECT cust.trx_date -- transaction(invoice) date
3051: FROM ra_customer_trx_all cust
3052: , ra_customer_trx_lines_all cust_lines
3053: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
3054: AND cust_lines.sales_order = p_order_number -- added condition for partial index for bug fix 3917556
3055: AND cust_lines.interface_line_attribute6 = TO_CHAR(p_line_id);

Line 5071: FROM ra_customer_trx_all cust

5067: AND price_adjustment_id IS NOT NULL;
5068:
5069: CURSOR c_get_invoice_status(p_price_adjustment_id IN NUMBER, p_order_number IN VARCHAR2) IS
5070: SELECT customer_trx_line_id, cust.trx_date
5071: FROM ra_customer_trx_all cust
5072: , ra_customer_trx_lines_all cust_lines
5073: , oe_price_adjustments price
5074: WHERE price.price_adjustment_id = p_price_adjustment_id
5075: AND cust_lines.customer_trx_line_id IS NOT NULL