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 2084: ra_customer_trx_lines ctl,

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

Line 2169: FROM ra_customer_trx_lines lines,

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

Line 2382: ra_customer_trx_lines l,

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