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 280: FROM ar_distributions

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

Line 1010: FROM ar_distributions

1006: cr.tax_rate IS NOT NULL
1007: THEN
1008: SELECT code_combination_id
1009: INTO l_ae_doc_rec.gl_tax_acct
1010: FROM ar_distributions
1011: WHERE source_id = old_misc.misc_cash_distribution_id
1012: AND source_table ='MCD'
1013: AND source_type = 'TAX';
1014: END IF;

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

1020: END;
1021:
1022: --
1023: --Release 11.5 VAT changes, reverse the application accounting for
1024: --misc cash accounting records in ar_distributions.
1025: --
1026: l_ae_doc_rec.document_type := 'RECEIPT';
1027: l_ae_doc_rec.document_id := old_misc.cash_receipt_id;
1028: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1097: --in the ar_distributions table.

1093: END LOOP;
1094:
1095: --
1096: --Release 11.5 VAT changes, create accounting for the new MCD records
1097: --in the ar_distributions table.
1098: --
1099: l_ae_doc_rec.document_type := 'RECEIPT';
1100: l_ae_doc_rec.document_id := new_adj.cash_receipt_id;
1101: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1433: --confirmed records in ar_distributions.

1429: END IF;
1430:
1431: --
1432: --Release 11.5 VAT changes, reverse the application accounting for
1433: --confirmed records in ar_distributions.
1434: --
1435: l_ae_doc_rec.document_type := 'RECEIPT';
1436: l_ae_doc_rec.document_id := cr.cash_receipt_id;
1437: l_ae_doc_rec.accounting_entity_level := 'ONE';

Line 1538: FROM ar_distributions ard,

1534: ,'' -- TAX_INC_FLAG
1535: ,'' -- TAX_LINK_ID
1536: ,trx.invoice_currency_code -- TO_CURRENCY
1537: ,'' -- REF_MF_DIST_FLAG
1538: FROM ar_distributions ard,
1539: ar_receivable_applications ora,
1540: ra_customer_trx trx
1541: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1542: AND ard.source_table = 'RA'

Line 1979: FROM ar_distributions ard,

1975: ,'' -- TAX_INC_FLAG
1976: ,'' -- TAX_LINK_ID
1977: ,trx.invoice_currency_code -- TO_CURRENCY
1978: ,'' -- REF_MF_DIST_FLAG
1979: FROM ar_distributions ard,
1980: ar_receivable_applications ora,
1981: ra_customer_trx trx
1982: WHERE ora.receivable_application_id = old_rec_app.receivable_application_id
1983: AND ard.source_table = 'RA'