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 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 3941: FROM ra_customer_trx_all cust

3937:
3938: --fix for bug 13824967
3939: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
3940: SELECT cust.trx_date -- transaction(invoice) date
3941: FROM ra_customer_trx_all cust
3942: , ra_customer_trx_lines_all cust_lines
3943: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
3944: AND cust_lines.interface_line_attribute1 = p_order_number -- added condition for partial index for bug fix 3917556
3945: AND cust_lines.interface_line_attribute6 = TO_CHAR(p_line_id)

Line 6220: FROM ra_customer_trx_all cust,

6216:
6217: --fix for bug 13824967
6218: CURSOR c_invoice_date(p_headerId IN NUMBER, p_lineId IN NUMBER) IS
6219: SELECT trunc(cust.trx_date) -- transaction(invoice) date
6220: FROM ra_customer_trx_all cust,
6221: ra_customer_trx_lines_all cust_lines,
6222: oe_order_headers_all oeh
6223: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
6224: AND cust_lines.interface_line_attribute1 = oeh.order_number

Line 6401: FROM ra_customer_trx_all cust

6397:
6398: -- Replaced Sales_Order Column with interface_line_attribute1 for Bug 8463331
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