eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_INVOICE_UTILS dependencies on RA_BATCH_SOURCES

Line 1056: ra_batch_sources_all without an org_Id join. This resulted

1052: -- Reject Trx Number as input if the batch source passed has
1053: -- automatic transaction numbering:
1054:
1055: /* 4536358 - both trx_number validations tested using
1056: ra_batch_sources_all without an org_Id join. This resulted
1057: in false error returns if even a single batch source of that
1058: ID was set Y (or N) respectively. In other words, the EXISTS
1059: would test all batch sources of that ID and fail if even one
1060: had the opposite setting as the record for the current org.

Line 1062: REMOVED _ALL from ra_batch_sources in exists clauses */

1058: ID was set Y (or N) respectively. In other words, the EXISTS
1059: would test all batch sources of that ID and fail if even one
1060: had the opposite setting as the record for the current org.
1061:
1062: REMOVED _ALL from ra_batch_sources in exists clauses */
1063:
1064: INSERT INTO ar_trx_errors_gt (
1065: trx_header_id,
1066: error_message,

Line 1074: ra_batch_sources b

1070: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),
1071: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),
1072: trx_number
1073: FROM ar_trx_header_gt gt,
1074: ra_batch_sources b
1075: WHERE b.batch_source_id = gt.batch_source_id
1076: AND ((gt.trx_number IS NULL AND
1077: NVL(b.auto_trx_numbering_flag,'N') = 'N')
1078: OR (gt.trx_number IS NOT NULL AND

Line 1394: FROM ra_batch_sources batch,

1390: WHERE gt.trx_number IS NOT NULL
1391: AND gt.batch_source_id IS NOT NULL
1392: AND EXISTS (
1393: SELECT 'X'
1394: FROM ra_batch_sources batch,
1395: ra_customer_trx trx
1396: WHERE trx.batch_source_id = gt.batch_source_id
1397: AND trx.trx_number = gt.trx_number
1398: AND trx.customer_trx_id <> NVL(gt.customer_trx_id, -99)

Line 1406: ra_batch_sources batch

1402: UNION
1403: SELECT 'X'
1404: FROM ra_recur_interim ri,
1405: ra_customer_trx ct,
1406: ra_batch_sources batch
1407: WHERE ct.customer_trx_id = ri.customer_trx_id
1408: AND ct.batch_source_id = gt.batch_source_id
1409: AND ri.trx_number = gt.trx_number
1410: AND NVL(ri.new_customer_trx_id, -98)

Line 1417: FROM ra_batch_sources bs,

1413: AND nvl(batch.copy_doc_number_flag,'N') = 'N'
1414: AND nvl(batch.allow_duplicate_trx_num_flag,'N') = 'N'
1415: UNION
1416: SELECT 'X'
1417: FROM ra_batch_sources bs,
1418: ar_trx_header_gt ril
1419: WHERE ril.batch_source_id = bs.batch_source_id
1420: AND bs.batch_source_id = gt.batch_source_id
1421: AND ril.trx_number = gt.trx_number

Line 1463: FROM ra_batch_sources bs

1459: batch_source_id
1460: FROM ar_trx_header_gt gt
1461: WHERE NOT EXISTS (
1462: SELECT 'X'
1463: FROM ra_batch_sources bs
1464: where nvl(gt.trx_date, trunc(sysdate)) between
1465: nvl(bs.start_date, nvl(gt.trx_date, trunc(sysdate)))
1466: and nvl(bs.end_date, nvl(gt.trx_date, trunc(sysdate)))
1467: and nvl(bs.status, 'A') = 'A'

Line 2437: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,

2433: FROM ar_trx_header_gt gt
2434: WHERE gt.related_customer_trx_id IS NOT NULL
2435: AND NOT EXISTS (
2436: SELECT 'X'
2437: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,
2438: ra_cust_trx_types types
2439: where trx.batch_source_id = bs.batch_source_id
2440: and trx.cust_trx_type_id = types.cust_trx_type_id
2441: and look.lookup_type = 'INV/CM'

Line 2668: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;

2664: PROCEDURE Get_batch_source_details (
2665: x_errmsg OUT NOCOPY VARCHAR2,
2666: x_return_status OUT NOCOPY VARCHAR2) IS
2667:
2668: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2669: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2670: l_dft_ref ra_batch_sources.default_reference%type;
2671: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2672: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;

Line 2669: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;

2665: x_errmsg OUT NOCOPY VARCHAR2,
2666: x_return_status OUT NOCOPY VARCHAR2) IS
2667:
2668: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2669: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2670: l_dft_ref ra_batch_sources.default_reference%type;
2671: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2672: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2673: BEGIN

Line 2670: l_dft_ref ra_batch_sources.default_reference%type;

2666: x_return_status OUT NOCOPY VARCHAR2) IS
2667:
2668: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2669: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2670: l_dft_ref ra_batch_sources.default_reference%type;
2671: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2672: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2673: BEGIN
2674: IF pg_debug = 'Y'

Line 2671: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;

2667:
2668: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2669: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2670: l_dft_ref ra_batch_sources.default_reference%type;
2671: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2672: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2673: BEGIN
2674: IF pg_debug = 'Y'
2675: THEN

Line 2672: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;

2668: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2669: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2670: l_dft_ref ra_batch_sources.default_reference%type;
2671: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2672: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2673: BEGIN
2674: IF pg_debug = 'Y'
2675: THEN
2676: debug ('AR_INVOICE_UTILS.Get_batch_source_details(+)' );

Line 2691: FROM RA_BATCH_SOURCES bs

2687: l_bs_auto_trx_num_flag,
2688: l_dft_ref,
2689: l_cust_trx_type_id,
2690: l_copy_doc_number_flag
2691: FROM RA_BATCH_SOURCES bs
2692: WHERE batch_source_id = (SELECT gt.batch_source_id
2693: FROM ar_trx_header_gt gt
2694: WHERE rownum =1 );
2695: