APPS.ARP_TRX_VALIDATE dependencies on RA_CUSTOMER_TRX_LINES

Line 505: FROM ra_customer_trx_lines

501: arp_util.debug('arp_trx_validate.check_dup_line_number()+');
502:
503: SELECT count(*)
504: INTO l_count
505: FROM ra_customer_trx_lines
506: WHERE customer_trx_id = p_customer_trx_id
507: AND line_number = p_line_number
508: AND line_type = 'LINE'
509: AND customer_trx_line_id <> nvl(p_customer_trx_line_id, -100);

Line 574: FROM ra_customer_trx_lines

570: arp_util.debug('arp_trx_validate.check_has_one_line()+');
571:
572: SELECT count(*)
573: INTO l_count
574: FROM ra_customer_trx_lines
575: WHERE customer_trx_id = p_customer_trx_id
576: AND link_to_cust_trx_line_id is NULL;
577:
578: IF (l_count <= 1)

Line 807: FROM ra_customer_trx_lines ctl

803: )
804: INTO l_new_line,
805: l_new_tax,
806: l_new_freight
807: FROM ra_customer_trx_lines ctl
808: WHERE customer_trx_id = p_customer_trx_id;
809:
810:
811: /*------------------------------------------------------+

Line 2087: ra_customer_trx_lines ctl,

2083: TO_CHAR(MIN(ctl.line_number))
2084: INTO l_temp,
2085: l_temp2
2086: FROM ra_cust_trx_line_salesreps ls,
2087: ra_customer_trx_lines ctl,
2088: ra_salesreps s
2089: WHERE ls.salesrep_id = s.salesrep_id
2090: AND ls.customer_trx_id = p_customer_trx_id
2091: AND ls.customer_trx_line_id = ctl.customer_trx_line_id(+)

Line 2172: FROM ra_customer_trx_lines lines,

2168: BEGIN
2169:
2170: SELECT TO_CHAR(MIN(lines.line_number))
2171: INTO l_temp
2172: FROM ra_customer_trx_lines lines,
2173: ar_memo_lines aml
2174: WHERE lines.customer_trx_id = p_customer_trx_id
2175: AND lines.memo_line_id = aml.memo_line_id
2176: AND p_trx_date NOT BETWEEN NVL(aml.start_date, p_trx_date)

Line 2385: ra_customer_trx_lines l,

2381: d.gl_date,
2382: rec.gl_date
2383: FROM ra_cust_trx_line_gl_dist rec,
2384: ra_cust_trx_line_gl_dist d,
2385: ra_customer_trx_lines l,
2386: ra_customer_trx t
2387: WHERE l.customer_trx_line_id = d.customer_trx_line_id(+)
2388: AND l.customer_trx_line_id = p_customer_trx_line_id
2389: AND l.customer_trx_id = t.customer_trx_id