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 1402: ra_customer_trx trx

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

Line 1412: ra_customer_trx ct,

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

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

5050: AND gt.doc_sequence_value IS NOT NULL
5051: AND EXISTS (
5052: SELECT 'Y' --already exists
5053: FROM ra_recur_interim ri,
5054: ra_customer_trx ct
5055: WHERE ct.customer_trx_id = ri.customer_trx_id
5056: AND ct.cust_trx_type_id = gt.cust_trx_type_id
5057: AND ri.doc_sequence_value = gt.doc_sequence_value
5058: AND NVL(ri.new_customer_trx_id, -98)

Line 5098: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;

5094: SELECT trx_header_id FROM
5095: ar_trx_errors_gt);
5096:
5097: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
5098: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
5099: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
5100: l_dummy BINARY_INTEGER;
5101:
5102: l_status number;

Line 5099: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;

5095: ar_trx_errors_gt);
5096:
5097: l_sequence_name FND_DOCUMENT_SEQUENCES.NAME%TYPE;
5098: l_doc_sequence_id ra_customer_trx.doc_sequence_id%type;
5099: l_doc_sequence_value ra_customer_trx.doc_sequence_value%type;
5100: l_dummy BINARY_INTEGER;
5101:
5102: l_status number;
5103:

Line 5117: l_trx_number ra_customer_trx.trx_number%type;

5113: l_update_trx boolean := FALSE;
5114: l_seq_err boolean := FALSE;
5115: l_trx_str VARCHAR2(2000);
5116: l_org_str VARCHAR2(30);
5117: l_trx_number ra_customer_trx.trx_number%type;
5118: l_seq_num_profile fnd_profile_option_values.profile_option_value%type;
5119: BEGIN
5120: IF pg_debug = 'Y'
5121: THEN

Line 5287: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

5283:
5284: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
5285: l_cpy_msg_data VARCHAR2(2000);
5286: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
5287: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
5288: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5289: l_party_id NUMBER;
5290: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
5291: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

Line 5291: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

5287: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
5288: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5289: l_party_id NUMBER;
5290: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
5291: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
5292:
5293: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5294: l_assignment_id NUMBER;
5295:

Line 5996: l_exchange_rate ra_customer_trx.exchange_rate%type;

5992: x_return_status OUT NOCOPY VARCHAR2) IS
5993:
5994:
5995: l_relation VARCHAR2(1);
5996: l_exchange_rate ra_customer_trx.exchange_rate%type;
5997: l_default_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
5998: CURSOR cExchangeRate IS
5999: SELECT trx_header_id, trx_currency,
6000: nvl(exchange_rate_type,

Line 5997: l_default_exchange_rate_type ra_customer_trx.exchange_rate_type%type;

5993:
5994:
5995: l_relation VARCHAR2(1);
5996: l_exchange_rate ra_customer_trx.exchange_rate%type;
5997: l_default_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
5998: CURSOR cExchangeRate IS
5999: SELECT trx_header_id, trx_currency,
6000: nvl(exchange_rate_type,
6001: p_trx_profile_rec.default_exchange_rate_type) exchange_rate_type,

Line 7527: --RA_CUSTOMER_TRX PREV_TRX,

7523: ar_trx_header_gt h
7524: --RA_CUST_TRX_TYPES TYPE,
7525: FND_CURRENCIES C,
7526: GL_SETS_OF_BOOKS G,
7527: --RA_CUSTOMER_TRX PREV_TRX,
7528: ar_trx_LINES_GT L_PARENT,
7529: ar_trx_LINES_GT L
7530: WHERE --L.REQUEST_ID = :request_id
7531: --L.PREVIOUS_CUSTOMER_TRX_ID = PREV_TRX.CUSTOMER_TRX_ID(+)