APPS.ARP_RATE_ADJ dependencies on AR_DISTRIBUTIONS

Line 78: AR_DISTRIBUTIONS d

74: d.source_type,
75: d.source_table
76: FROM AR_CASH_RECEIPT_HISTORY crh,
77: AR_CASH_RECEIPT_HISTORY crh2,
78: AR_DISTRIBUTIONS d
79: WHERE crh.cash_receipt_id = cr_id
80: AND crh2.cash_receipt_id = cr_id
81: AND d.source_id = crh.cash_receipt_history_id
82: AND crh2.current_record_flag = 'Y'

Line 194: acctd_dis_amount AR_DISTRIBUTIONS.ACCTD_AMOUNT_DR%TYPE;

190: unapp_id AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE;
191:
192: dis DIS_INFO%ROWTYPE;
193: acctd_curr_amount AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;
194: acctd_dis_amount AR_DISTRIBUTIONS.ACCTD_AMOUNT_DR%TYPE;
195: amount_cr NUMBER;
196: amount_dr NUMBER;
197: acctd_amount_cr NUMBER;
198: acctd_amount_dr NUMBER;

Line 221: l_dist_rec ar_distributions%ROWTYPE;

217: net_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
218:
219: -- Added for 11.5 VAT changes
220: l_cr_rec ar_cash_receipts%ROWTYPE;
221: l_dist_rec ar_distributions%ROWTYPE;
222: l_dummy ar_distributions.line_id%TYPE;
223: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
224: l_ae_doc_rec ae_doc_rec_type;
225:

Line 222: l_dummy ar_distributions.line_id%TYPE;

218:
219: -- Added for 11.5 VAT changes
220: l_cr_rec ar_cash_receipts%ROWTYPE;
221: l_dist_rec ar_distributions%ROWTYPE;
222: l_dummy ar_distributions.line_id%TYPE;
223: l_app_id ar_receivable_applications.receivable_application_id%TYPE;
224: l_ae_doc_rec ae_doc_rec_type;
225:
226: -- Added for iClaim API calls

Line 284: FROM ar_distributions

280: p_source_table IN VARCHAR2,
281: p_status IN VARCHAR2)
282: IS
283: SELECT *
284: FROM ar_distributions
285: WHERE source_table = 'CRH'
286: AND source_id = p_source_id
287: AND ((DECODE(p_status,'CONFIRMED',DECODE(source_type,'CONFIRMATION','Y','N'),
288: 'REMITTED' ,DECODE(source_type,'REMITTANCE','Y','N'),

Line 1023: FROM ar_distributions

1019: cr.tax_rate IS NOT NULL
1020: THEN
1021: SELECT code_combination_id
1022: INTO l_ae_doc_rec.gl_tax_acct
1023: FROM ar_distributions
1024: WHERE source_id = old_misc.misc_cash_distribution_id
1025: AND source_table ='MCD'
1026: AND source_type = 'TAX';
1027: END IF;

Line 1037: --misc cash accounting records in ar_distributions.

1033: END;
1034:
1035: --
1036: --Release 11.5 VAT changes, reverse the application accounting for
1037: --misc cash accounting records in ar_distributions.
1038: --
1039: l_ae_doc_rec.document_type := 'RECEIPT';
1040: l_ae_doc_rec.document_id := old_misc.cash_receipt_id;
1041: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1118: --in the ar_distributions table.

1114: END LOOP;
1115:
1116: --
1117: --Release 11.5 VAT changes, create accounting for the new MCD records
1118: --in the ar_distributions table.
1119: --
1120: l_ae_doc_rec.document_type := 'RECEIPT';
1121: l_ae_doc_rec.document_id := new_adj.cash_receipt_id;
1122: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1492: --confirmed records in ar_distributions.

1488: END IF;
1489:
1490: --
1491: --Release 11.5 VAT changes, reverse the application accounting for
1492: --confirmed records in ar_distributions.
1493: --
1494: l_ae_doc_rec.document_type := 'RECEIPT';
1495: l_ae_doc_rec.document_id := cr.cash_receipt_id;
1496: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1597: FROM ar_distributions ard,

1593: ,'' -- TAX_INC_FLAG
1594: ,'' -- TAX_LINK_ID
1595: ,trx.invoice_currency_code -- TO_CURRENCY
1596: ,'' -- REF_MF_DIST_FLAG
1597: FROM ar_distributions ard,
1598: ar_receivable_applications ora,
1599: ra_customer_trx trx
1600: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1601: AND ard.source_table = 'RA'

Line 2055: FROM ar_distributions ard,

2051: ,'' -- TAX_INC_FLAG
2052: ,'' -- TAX_LINK_ID
2053: ,trx.invoice_currency_code -- TO_CURRENCY
2054: ,'' -- REF_MF_DIST_FLAG
2055: FROM ar_distributions ard,
2056: ar_receivable_applications ora,
2057: ra_customer_trx trx
2058: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
2059: AND ard.source_table = 'RA'