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 1063: ra_batch_sources_all without an org_Id join. This resulted

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

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

1065: ID was set Y (or N) respectively. In other words, the EXISTS
1066: would test all batch sources of that ID and fail if even one
1067: had the opposite setting as the record for the current org.
1068:
1069: REMOVED _ALL from ra_batch_sources in exists clauses */
1070:
1071: INSERT INTO ar_trx_errors_gt (
1072: trx_header_id,
1073: error_message,

Line 1081: ra_batch_sources b

1077: arp_standard.fnd_message('AR_INAPI_TRX_NUM_NOT_REQUIRED'),
1078: arp_standard.fnd_message('AR_TW_NULL_TRX_NUMBER')),
1079: trx_number
1080: FROM ar_trx_header_gt gt,
1081: ra_batch_sources b
1082: WHERE b.batch_source_id = gt.batch_source_id
1083: AND ((gt.trx_number IS NULL AND
1084: NVL(b.auto_trx_numbering_flag,'N') = 'N')
1085: OR (gt.trx_number IS NOT NULL AND

Line 1401: FROM ra_batch_sources batch,

1397: WHERE gt.trx_number IS NOT NULL
1398: AND gt.batch_source_id IS NOT NULL
1399: AND EXISTS (
1400: SELECT 'X'
1401: FROM ra_batch_sources batch,
1402: ra_customer_trx trx
1403: WHERE trx.batch_source_id = gt.batch_source_id
1404: AND trx.trx_number = gt.trx_number
1405: AND trx.customer_trx_id <> NVL(gt.customer_trx_id, -99)

Line 1413: ra_batch_sources batch

1409: UNION
1410: SELECT 'X'
1411: FROM ra_recur_interim ri,
1412: ra_customer_trx ct,
1413: ra_batch_sources batch
1414: WHERE ct.customer_trx_id = ri.customer_trx_id
1415: AND ct.batch_source_id = gt.batch_source_id
1416: AND ri.trx_number = gt.trx_number
1417: AND NVL(ri.new_customer_trx_id, -98)

Line 1424: FROM ra_batch_sources bs,

1420: AND nvl(batch.copy_doc_number_flag,'N') = 'N'
1421: AND nvl(batch.allow_duplicate_trx_num_flag,'N') = 'N'
1422: UNION
1423: SELECT 'X'
1424: FROM ra_batch_sources bs,
1425: ar_trx_header_gt ril
1426: WHERE ril.batch_source_id = bs.batch_source_id
1427: AND bs.batch_source_id = gt.batch_source_id
1428: AND ril.trx_number = gt.trx_number

Line 1504: FROM ra_batch_sources bs

1500: batch_source_id
1501: FROM ar_trx_header_gt gt
1502: WHERE NOT EXISTS (
1503: SELECT 'X'
1504: FROM ra_batch_sources bs
1505: where nvl(gt.trx_date, trunc(sysdate)) between
1506: nvl(bs.start_date, nvl(gt.trx_date, trunc(sysdate)))
1507: and nvl(bs.end_date, nvl(gt.trx_date, trunc(sysdate)))
1508: and nvl(bs.status, 'A') = 'A'

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

2510: FROM ar_trx_header_gt gt
2511: WHERE gt.related_customer_trx_id IS NOT NULL
2512: AND NOT EXISTS (
2513: SELECT 'X'
2514: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,
2515: ra_cust_trx_types types
2516: where trx.batch_source_id = bs.batch_source_id
2517: and trx.cust_trx_type_id = types.cust_trx_type_id
2518: and look.lookup_type = 'INV/CM'

Line 2745: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;

2741: PROCEDURE Get_batch_source_details (
2742: x_errmsg OUT NOCOPY VARCHAR2,
2743: x_return_status OUT NOCOPY VARCHAR2) IS
2744:
2745: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2746: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2747: l_dft_ref ra_batch_sources.default_reference%type;
2748: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2749: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;

Line 2746: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;

2742: x_errmsg OUT NOCOPY VARCHAR2,
2743: x_return_status OUT NOCOPY VARCHAR2) IS
2744:
2745: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2746: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2747: l_dft_ref ra_batch_sources.default_reference%type;
2748: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2749: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2750: BEGIN

Line 2747: l_dft_ref ra_batch_sources.default_reference%type;

2743: x_return_status OUT NOCOPY VARCHAR2) IS
2744:
2745: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2746: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2747: l_dft_ref ra_batch_sources.default_reference%type;
2748: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2749: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2750: BEGIN
2751: IF pg_debug = 'Y'

Line 2748: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;

2744:
2745: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2746: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2747: l_dft_ref ra_batch_sources.default_reference%type;
2748: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2749: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2750: BEGIN
2751: IF pg_debug = 'Y'
2752: THEN

Line 2749: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;

2745: l_bs_batch_auto_num_flag ra_batch_sources.auto_batch_numbering_flag%type;
2746: l_bs_auto_trx_num_flag ra_batch_sources.auto_trx_numbering_flag%type;
2747: l_dft_ref ra_batch_sources.default_reference%type;
2748: l_cust_trx_type_id ra_batch_sources.default_inv_trx_type%type;
2749: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
2750: BEGIN
2751: IF pg_debug = 'Y'
2752: THEN
2753: debug ('AR_INVOICE_UTILS.Get_batch_source_details(+)' );

Line 2768: FROM RA_BATCH_SOURCES bs

2764: l_bs_auto_trx_num_flag,
2765: l_dft_ref,
2766: l_cust_trx_type_id,
2767: l_copy_doc_number_flag
2768: FROM RA_BATCH_SOURCES bs
2769: WHERE batch_source_id = (SELECT gt.batch_source_id
2770: FROM ar_trx_header_gt gt
2771: WHERE rownum =1 );
2772: