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_CUSTOMER_TRX

Line 1395: ra_customer_trx trx

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)
1399: AND trx.batch_source_id = batch.batch_source_id

Line 1405: ra_customer_trx ct,

1401: AND nvl(batch.allow_duplicate_trx_num_flag,'N') = 'N'
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

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 4927: ra_customer_trx ct

4923: AND gt.doc_sequence_value IS NOT NULL
4924: AND EXISTS (
4925: SELECT 'Y' --already exists
4926: FROM ra_recur_interim ri,
4927: ra_customer_trx ct
4928: WHERE ct.customer_trx_id = ri.customer_trx_id
4929: AND ct.cust_trx_type_id = gt.cust_trx_type_id
4930: AND ri.doc_sequence_value = gt.doc_sequence_value
4931: AND NVL(ri.new_customer_trx_id, -98)

Line 4971: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;

4967: SELECT trx_header_id FROM
4968: ar_trx_errors_gt);
4969:
4970: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
4971: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
4972: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
4973: l_dummy BINARY_INTEGER;
4974:
4975: l_status number;

Line 4972: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;

4968: ar_trx_errors_gt);
4969:
4970: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
4971: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
4972: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
4973: l_dummy BINARY_INTEGER;
4974:
4975: l_status number;
4976:

Line 4990: l_trx_number ra_customer_trx.trx_number%type;

4986: l_update_trx boolean := FALSE;
4987: l_seq_err boolean := FALSE;
4988: l_trx_str VARCHAR2(2000);
4989: l_org_str VARCHAR2(30);
4990: l_trx_number ra_customer_trx.trx_number%type;
4991: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
4992: BEGIN
4993: IF pg_debug = 'Y'
4994: THEN

Line 5160: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

5156:
5157: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
5158: l_cpy_msg_data VARCHAR2(2000);
5159: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
5160: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
5161: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5162: l_party_id NUMBER;
5163: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
5164: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

Line 5164: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

5160: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
5161: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5162: l_party_id NUMBER;
5163: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
5164: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
5165:
5166: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5167: l_assignment_id NUMBER;
5168:

Line 5869: l_exchange_rate ra_customer_trx.exchange_rate%type;

5865: x_return_status OUT NOCOPY VARCHAR2) IS
5866:
5867:
5868: l_relation VARCHAR2(1);
5869: l_exchange_rate ra_customer_trx.exchange_rate%type;
5870: l_default_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
5871: CURSOR cExchangeRate IS
5872: SELECT trx_header_id, trx_currency,
5873: nvl(exchange_rate_type,

Line 5870: l_default_exchange_rate_type ra_customer_trx.exchange_rate_type%type;

5866:
5867:
5868: l_relation VARCHAR2(1);
5869: l_exchange_rate ra_customer_trx.exchange_rate%type;
5870: l_default_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
5871: CURSOR cExchangeRate IS
5872: SELECT trx_header_id, trx_currency,
5873: nvl(exchange_rate_type,
5874: p_trx_profile_rec.default_exchange_rate_type) exchange_rate_type,

Line 7188: --RA_CUSTOMER_TRX PREV_TRX,

7184: ar_trx_header_gt h
7185: --RA_CUST_TRX_TYPES TYPE,
7186: FND_CURRENCIES C,
7187: GL_SETS_OF_BOOKS G,
7188: --RA_CUSTOMER_TRX PREV_TRX,
7189: ar_trx_LINES_GT L_PARENT,
7190: ar_trx_LINES_GT L
7191: WHERE --L.REQUEST_ID = :request_id
7192: --L.PREVIOUS_CUSTOMER_TRX_ID = PREV_TRX.CUSTOMER_TRX_ID(+)