APPS.AR_INVOICE_SQL_FUNC_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 45: from ra_customer_trx_lines

41: BEGIN
42:
43: select translated_description
44: into l_description
45: from ra_customer_trx_lines
46: where customer_trx_line_id = p_customer_trx_line_id;
47:
48: return(l_description);
49:

Line 198: ra_customer_trx_lines line

194: SELECT NVL(SUM(line.extended_amount),0)
195: INTO commit_total_activity
196: FROM ra_customer_trx trx,
197: ra_cust_trx_types type,
198: ra_customer_trx_lines line
199: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
200: AND trx.customer_trx_id = line.customer_trx_id
201: AND type.type = 'CM'
202: AND trx.complete_flag = 'Y'

Line 370: ra_customer_trx_lines line

366: SELECT NVL(SUM(line.extended_amount),0)
367: INTO commit_total_activity
368: FROM ra_customer_trx trx,
369: ra_cust_trx_types type,
370: ra_customer_trx_lines line
371: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
372: AND trx.customer_trx_id = line.customer_trx_id
373: AND type.type = 'CM'
374: AND trx.complete_flag = 'Y'

Line 514: FROM ra_customer_trx_lines l

510:
511: CURSOR sel_taxyn( line_id in number ) IS
512: SELECT 'x' from dual where exists
513: ( SELECT 'x'
514: FROM ra_customer_trx_lines l
515: WHERE l.link_to_cust_trx_line_id = line_id
516: AND l.line_type = 'TAX'
517: AND l.extended_amount <> 0 );
518: