APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 904: FROM ra_customer_trx_all cust

900: WHERE line_id = p_line_id;
901:
902: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
903: SELECT cust.trx_date -- transaction(invoice) date
904: FROM ra_customer_trx_all cust
905: , ra_customer_trx_lines_all cust_lines
906: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
907: AND cust_lines.sales_order = p_order_number -- added condition for partial index for bug fix 3917556
908: AND cust_lines.interface_line_attribute6 = TO_CHAR(p_line_id);