DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 3052: , ra_customer_trx_lines_all cust_lines

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);
3056:

Line 5072: , ra_customer_trx_lines_all cust_lines

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
5076: AND interface_line_context = 'ORDER ENTRY'