APPS.ARP_TRX_VALIDATE dependencies on RA_CUSTOMER_TRX

Line 298: FROM ra_customer_trx

294:
295: -- check if the transaction number exists already
296: CURSOR duptrx IS
297: SELECT 'Y' -- already exists in the transaction table
298: FROM ra_customer_trx
299: WHERE batch_source_id = p_batch_source_id
300: AND trx_number = p_trx_number
301: AND customer_trx_id <> NVL(p_customer_trx_id, -99)
302: UNION

Line 305: ra_customer_trx ct

301: AND customer_trx_id <> NVL(p_customer_trx_id, -99)
302: UNION
303: SELECT 'Y' -- already exists in the interim table
304: FROM ra_recur_interim ri,
305: ra_customer_trx ct
306: WHERE ct.customer_trx_id = ri.customer_trx_id
307: AND ct.batch_source_id = p_batch_source_id
308: AND ri.trx_number = p_trx_number
309: AND NVL(ri.new_customer_trx_id, -98) <> NVL(p_customer_trx_id, -99)

Line 425: ra_customer_trx ct

421: THEN
422: SELECT 'Y' --already exists
423: INTO l_temp
424: FROM ra_recur_interim ri,
425: ra_customer_trx ct
426: WHERE ct.customer_trx_id = ri.customer_trx_id
427: AND ct.cust_trx_type_id = p_cust_trx_type_id
428: AND ri.doc_sequence_value = p_doc_sequence_value
429: AND NVL(ri.new_customer_trx_id, -98)

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 1328: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

1324:
1325: receipt_creation_method_rec receipt_creation_method_cur%ROWTYPE;
1326:
1327: /*Bug3348454 */
1328: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
1329: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;
1330:
1331: BEGIN
1332:

Line 1329: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;

1325: receipt_creation_method_rec receipt_creation_method_cur%ROWTYPE;
1326:
1327: /*Bug3348454 */
1328: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
1329: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;
1330:
1331: BEGIN
1332:
1333: arp_util.debug('ARP_TRX_VALIDATE.validate_trx_date()+');

Line 1433: FROM ra_customer_trx t,

1429: l_so_source_code,
1430: 'N')
1431: INTO l_temp,
1432: l_commit_bal
1433: FROM ra_customer_trx t,
1434: ra_cust_trx_types tt
1435: WHERE t.customer_trx_id = p_initial_customer_trx_id
1436: AND t.cust_trx_type_id = tt.cust_trx_type_id
1437: AND p_trx_date

Line 1967: FROM RA_CUSTOMER_TRX

1963: BEGIN
1964: SELECT arp_trx_defaults_3.get_party_id(paying_customer_id),
1965: arp_trx_defaults_3.get_party_id(bill_to_customer_id)
1966: INTO l_paying_customer_id,l_bill_to_customer_id
1967: FROM RA_CUSTOMER_TRX
1968: WHERE customer_trx_id=p_customer_trx_id;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: RAISE;

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

Line 2383: ra_customer_trx t

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
2387: AND rec.customer_trx_id = l.customer_trx_id