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 RA_CUSTOMER_TRX_LINES_ALL

Line 1064: , ra_customer_trx_lines_all cust_lines

1060:
1061: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
1062: SELECT cust.trx_date -- transaction(invoice) date
1063: FROM ra_customer_trx_all cust
1064: , ra_customer_trx_lines_all cust_lines
1065: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
1066: AND cust_lines.sales_order = p_order_number -- added condition for partial index for bug fix 3917556
1067: AND cust_lines.interface_line_attribute6 = TO_CHAR(p_line_id);
1068:

Line 4111: ra_customer_trx_lines_all cust_lines

4107:
4108: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
4109: SELECT cust.trx_date -- transaction(invoice) date
4110: FROM ra_customer_trx_all cust,
4111: ra_customer_trx_lines_all cust_lines
4112: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
4113: AND cust_lines.sales_order = p_order_number -- added condition for partial index for bug fix 3917556
4114: AND cust_lines.interface_line_attribute6 = to_char(p_line_id);
4115: