DBA Data[Home] [Help]

APPS.IEX_TRX_VIEW_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 80: from ra_customer_trx_lines

76: FUNCTION get_sales_order(p_customer_trx_id NUMBER) RETURN VARCHAR2
77: IS
78: cursor c_so IS
79: select sales_order
80: from ra_customer_trx_lines
81: where customer_trx_id = p_customer_trx_id
82: -- Begin fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order
83: and line_type = 'LINE'
84: -- End fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order

Line 210: from ra_customer_trx_lines

206: and status = 'COLLECTABLE';
207:
208: cursor c_so(p_customer_trx_id NUMBER) IS
209: select sales_order
210: from ra_customer_trx_lines
211: where customer_trx_id = p_customer_trx_id
212: -- Begin fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order
213: and line_type = 'LINE'
214: -- End fix bug #5012865-JYPARK-02/01/2006-getting line type to get sales_order