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

1327:
1328: receipt_creation_method_rec receipt_creation_method_cur%ROWTYPE;
1329:
1330: /*Bug3348454 */
1331: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
1332: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;
1333:
1334: BEGIN
1335:

Line 1332: l_paying_customer_id ra_customer_trx.paying_customer_id%TYPE;

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

Line 1436: FROM ra_customer_trx t,

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

Line 1970: FROM RA_CUSTOMER_TRX

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

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

Line 2386: ra_customer_trx t

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