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.ARP_PROCESS_APPLICATION dependencies on AR_DISTRIBUTIONS

Line 403: from ar_distributions

399: update ar_receivable_applications
400: set reversal_gl_date = p_reversal_gl_date,
401: include_in_accumulation = 'N' -- bug 6924942 --> setting accumulation flag to 'N'
402: where receivable_application_id = (select source_id
403: from ar_distributions
404: where source_table = 'RA'
405: and source_type = 'UNAPP'
406: and source_id_secondary = l_ra_rec.receivable_application_id);
407:

Line 3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */

3362: l_receipt_info_rec AR_AUTOREC_API.receipt_info_rec;
3363:
3364: l_old_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3365: l_new_ps_rec ar_payment_schedules%ROWTYPE; /* jrautiai BR implementation */
3366: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
3367: l_exchange_rate_type ra_customer_trx.exchange_rate_type%TYPE;
3368: l_exchange_rate_date ra_customer_trx.exchange_date%TYPE;
3369: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
3370: l_trx_number ra_customer_trx.trx_number%TYPE;

Line 3916: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.

3912: -- and payment schedule tables.
3913: --
3914:
3915: /* 14-APR-2000 jrautiai BR implementation
3916: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.
3917: * instead of ra_cust_trx_line_gl_dist */
3918:
3919: --for PS -2, it should go in side the if condition
3920:

Line 4238: --in ar_distributions

4234:
4235: IF nvl(l_rec_ra_rec.postable,'Y') = 'Y' THEN -- jrautiai BR project
4236: --
4237: --Release 11.5 VAT changes, create paired UNAPP record accounting
4238: --in ar_distributions
4239: --
4240: l_ae_doc_rec.source_id := l_rec_ra_rec.receivable_application_id;
4241: l_ae_doc_rec.source_id_old := l_inv_ra_rec.receivable_application_id; --Paired application id
4242: l_ae_doc_rec.other_flag := 'PAIR';

Line 4278: --in ar_distributions

4274: END IF;
4275:
4276: --
4277: --Release 11.5 VAT changes, create APP record accounting
4278: --in ar_distributions
4279: --
4280: l_ae_doc_rec.source_id := l_inv_ra_rec.receivable_application_id;
4281: l_ae_doc_rec.source_id_old := '';
4282: l_ae_doc_rec.other_flag := '';

Line 4694: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */

4690:
4691: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
4692: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
4693: l_ae_doc_rec ae_doc_rec_type;
4694: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
4695: l_flag char; /* added for bug 2318048 */
4696: l_upgrade_flag VARCHAR2(30);
4697:
4698:

Line 4816: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.

4812: -- and Payment Schedule table.
4813: --
4814:
4815: /* 14-APR-2000 jrautiai BR implementation
4816: * Moved into a procedure for BR transactions has the accounting in ar_distributions table.
4817: * instead of ra_cust_trx_line_gl_dist */
4818:
4819: ARP_PROCESS_APPLICATION.fetch_app_ccid(p_invoice_ps_id,
4820: l_inv_ra_rec.applied_customer_trx_id,

Line 4984: --in ar_distributions

4980: AR_BUS_EVENT_COVER.Raise_CM_Apply_Event(l_inv_ra_rec.receivable_application_id);
4981:
4982: --
4983: --Release 11.5 VAT changes, create APP record accounting
4984: --in ar_distributions
4985: --
4986: l_ae_doc_rec.document_type := 'CREDIT_MEMO';
4987: l_ae_doc_rec.document_id := l_inv_ra_rec.customer_trx_id;
4988: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 5465: --in ar_distributions

5461: END IF;
5462:
5463: --
5464: --Release 11.5 VAT changes, create paired UNAPP record accounting
5465: --in ar_distributions
5466: --
5467: l_ae_doc_rec.document_type := 'RECEIPT';
5468: l_ae_doc_rec.document_id := l_ra_rec.cash_receipt_id;
5469: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 5478: --in ar_distributions

5474: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
5475:
5476: --
5477: --Release 11.5 VAT changes, create ACC record accounting
5478: --in ar_distributions
5479: --
5480: l_ae_doc_rec.source_id := l_ra_rec.receivable_application_id;
5481: l_ae_doc_rec.source_id_old := '';
5482: l_ae_doc_rec.other_flag := '';

Line 6435: * in ar_distributions */

6431:
6432: /* Otherwise the UNAPP record is postable so create paired accounting */
6433:
6434: /* Release 11.5 VAT changes, create paired UNAPP record accounting
6435: * in ar_distributions */
6436:
6437: l_ae_doc_rec.document_type := 'RECEIPT';
6438: l_ae_doc_rec.document_id := l_ra_rec.cash_receipt_id;
6439: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 6448: * in ar_distributions */

6444: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
6445:
6446:
6447: /* Release 11.5 VAT changes, create ACTIVITY record accounting
6448: * in ar_distributions */
6449:
6450: l_ae_doc_rec.source_id := l_ra_rec.receivable_application_id;
6451: l_ae_doc_rec.source_id_old := '';
6452: l_ae_doc_rec.other_flag := '';

Line 6624: | stored in the ar_distributions table instead of the |

6620: | |
6621: | DESCRIPTION |
6622: | This procedure fetches the CCID for the application. This changed for |
6623: | the BR project since the accounting for Bills Receivable document is |
6624: | stored in the ar_distributions table instead of the |
6625: | ra_cust_trx_lines_gl_dist table (where the accounting is stored for |
6626: | other transactions). This was done to confirm with SLA standards |
6627: | |
6628: | SCOPE - PRIVATE |

Line 6648: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS

6644: PROCEDURE fetch_app_ccid(
6645: p_invoice_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6646: p_applied_customer_trx_id OUT NOCOPY ar_receivable_applications.applied_customer_trx_id%TYPE,
6647: p_code_combination_id OUT NOCOPY ar_receivable_applications.code_combination_id%TYPE,
6648: p_source_type OUT NOCOPY ar_distributions.source_type%TYPE) IS
6649:
6650: /* Cursor to fetch the given transaction information */
6651: CURSOR doc_cur IS
6652: SELECT ps.customer_trx_id,

Line 6669: FROM ar_distributions dist

6665:
6666: /* Cursor to fetch BR transaction CCID, new functionality */
6667: CURSOR br_dist_cur(p_transaction_history_id ar_transaction_history.transaction_history_id%TYPE, p_sign NUMBER) IS
6668: SELECT dist.code_combination_id, dist.source_type
6669: FROM ar_distributions dist
6670: WHERE dist.source_id = p_transaction_history_id
6671: AND dist.source_table = 'TH'
6672: AND dist.source_type in ('REC','REMITTANCE','FACTOR','UNPAIDREC')
6673: AND dist.source_id_secondary IS null

Line 7462: --in ar_distributions

7458:
7459: -- Call mrc engine to process inserts in to receivable apps
7460: --
7461: --Release 11.5 VAT changes, create paired UNAPP record accounting
7462: --in ar_distributions
7463: --
7464: l_ae_doc_rec.document_type := 'RECEIPT';
7465: l_ae_doc_rec.document_id := l_ra_rec.cash_receipt_id;
7466: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 7475: --in ar_distributions

7471: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
7472:
7473: --
7474: --Release 11.5 VAT changes, create OTHER ACC record accounting
7475: --in ar_distributions
7476: --
7477:
7478: l_ae_doc_rec.source_id := l_ra_rec.receivable_application_id;
7479: l_ae_doc_rec.source_id_old := '';

Line 8718: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */

8714:
8715: l_inv_ra_rec ar_receivable_applications%ROWTYPE;
8716: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
8717: l_ae_doc_rec ae_doc_rec_type;
8718: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
8719: l_flag char;
8720: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
8721:
8722: l_inv_bal_amount NUMBER;

Line 9075: and exists (select 'x' from ar_distributions

9071:
9072: For rec in (select receivable_application_id source_id from ar_receivable_applications ra
9073: where customer_trx_id = p_cust_Trx_id
9074: and applied_customer_trx_id = p_app_cust_trx_id
9075: and exists (select 'x' from ar_distributions
9076: where source_id = ra.receivable_application_id
9077: and source_table = 'RA'
9078: and ref_customer_trx_line_id is not null
9079: and ref_prev_cust_trx_line_id is null)) Loop

Line 9082: update ar_distributions ard

9078: and ref_customer_trx_line_id is not null
9079: and ref_prev_cust_trx_line_id is null)) Loop
9080: arp_debug.debug('Updating CM ard to stamp ref_prev_cust_trx_line_id');
9081:
9082: update ar_distributions ard
9083: set ref_prev_cust_trx_line_id = (select previous_customer_trx_line_id
9084: from ra_customer_trx_lines
9085: where customer_trx_line_id = ard.ref_customer_trx_line_id)
9086: where source_id = rec.source_id

Line 9102: update ar_distributions ard

9098:
9099: IF l_cnt > 0 THEN
9100: arp_debug.debug('Updating INV ard to stamp ref_prev_cust_trx_line_id');
9101:
9102: update ar_distributions ard
9103: set ref_prev_cust_trx_line_id = (select ref_customer_trx_line_id
9104: from ar_distributions
9105: where source_id = rec.source_id
9106: and ref_prev_cust_trx_line_id = ard.ref_customer_trx_line_id

Line 9104: from ar_distributions

9100: arp_debug.debug('Updating INV ard to stamp ref_prev_cust_trx_line_id');
9101:
9102: update ar_distributions ard
9103: set ref_prev_cust_trx_line_id = (select ref_customer_trx_line_id
9104: from ar_distributions
9105: where source_id = rec.source_id
9106: and ref_prev_cust_trx_line_id = ard.ref_customer_trx_line_id
9107: and rownum = 1)
9108: where source_id = rec.source_id