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.LNS_DISTRIBUTIONS_PUB dependencies on XLA_TRANSACTION_ENTITIES

Line 62: from xla_transaction_entities xlee

58: l_disbursement_id number;
59:
60: cursor c_events(p_loan_id number) is
61: select event_id
62: from xla_transaction_entities xlee
63: ,xla_events xle
64: where xle.application_id = 206
65: and xle.entity_id = xlee.entity_id
66: and xlee.source_id_int_1 = p_loan_id

Line 314: from xla_transaction_entities xlee

310:
311:
312: cursor c_event (c_loan_id number, c_loan_amount_adj_id number) is
313: select xle.event_id, xll.source_distribution_id_num_1, ledger_id
314: from xla_transaction_entities xlee
315: ,xla_events xle
316: ,xla_distribution_links xll
317: where xle.application_id = 206
318: and xle.entity_id = xlee.entity_id

Line 328: ,xla_transaction_entities xlee

324:
325: cursor c_loan_adj(c_loan_id number) is
326: select max(ladj.loan_amount_adj_id)
327: from lns_loan_amount_adjs ladj
328: ,xla_transaction_entities xlee
329: ,xla_events xle
330: where ladj.loan_id = c_loan_id
331: and xlee.entity_id = xle.entity_id
332: and xle.event_type_code in ('DIRECT_LOAN_ADJ_APPROVED', 'DIRECT_LOAN_ADJ_REVERSED')

Line 531: from xla_transaction_entities xlee

527:
528: -- get budgetary control events only
529: cursor c_events(p_loan_id number) is
530: select event_id
531: from xla_transaction_entities xlee
532: ,xla_events xle
533: where xle.application_id = 206
534: and xle.entity_id = xlee.entity_id
535: and xlee.source_id_int_1 = p_loan_id

Line 554: from xla_transaction_entities xlee

550: where loan_id = p_loan_id;
551:
552: cursor c_budget_event(p_loan_id number) is
553: select count(1)
554: from xla_transaction_entities xlee
555: ,xla_events xle
556: where xle.application_id = 206
557: and xle.entity_id = xlee.entity_id
558: and xlee.source_id_int_1 = p_loan_id

Line 4164: ,xla_transaction_entities ent

4160: cursor C_ERS_LOAN_RECEIVABLE(p_loan_id number) is
4161: select sum(lline.requested_amount)
4162: ,ael.code_combination_id
4163: from ra_customer_trx_all inv
4164: ,xla_transaction_entities ent
4165: ,xla_ae_headers aeh
4166: ,xla_ae_lines ael
4167: ,lns_loan_lines lline
4168: where ent.application_id = 222

Line 4204: ,xla_transaction_entities ent

4200: cursor C_ERS_LOAN_CLEARING(p_loan_id number) is
4201: select sum(ael.entered_dr)
4202: ,ael.code_combination_id
4203: from ar_adjustments_all adj
4204: ,xla_transaction_entities ent
4205: ,xla_ae_headers aeh
4206: ,xla_ae_lines ael
4207: where ent.application_id = 222
4208: and adj.adjustment_id = ent.source_id_int_1

Line 4286: ,xla_transaction_entities xlt

4282: -- cursor to get accounting errors
4283: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is
4284: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
4285: from xla_accounting_errors err
4286: ,xla_transaction_entities xlt
4287: where xlt.application_id = 222
4288: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
4289: and xlt.entity_id = err.entity_id
4290: and xlt.entity_id in (select entity_id from xla_transaction_entities

Line 4290: and xlt.entity_id in (select entity_id from xla_transaction_entities

4286: ,xla_transaction_entities xlt
4287: where xlt.application_id = 222
4288: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
4289: and xlt.entity_id = err.entity_id
4290: and xlt.entity_id in (select entity_id from xla_transaction_entities
4291: where application_id = 222
4292: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
4293: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))
4294: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));

Line 4298: from xla_transaction_entities

4294: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));
4295: -- -----------------------------------------------------------------
4296: cursor c_entities(p_loan_id number) is
4297: select entity_id, entity_code, source_id_int_1, transaction_number
4298: from xla_transaction_entities
4299: where application_id = 222
4300: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
4301: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id)
4302: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_id = p_loan_id))));

Line 4548: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching entities xla_transaction_entities...');

4544:
4545: end loop;
4546: close c_get_loan_documents;
4547:
4548: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching entities xla_transaction_entities...');
4549: l_transactions_count := 0;
4550: open c_entities(p_loan_id);
4551: loop
4552: fetch c_entities into l_entity_id, l_entity_code, l_source_id_int_1, l_transaction_number;

Line 5096: ,xla_Transaction_entities xlt

5092: -- this is only for loans entities
5093: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is
5094: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
5095: from xla_accounting_errors err
5096: ,xla_Transaction_entities xlt
5097: where xlt.application_id = 206
5098: and err.accounting_batch_id = p_accounting_batch_id
5099: and err.entity_id = xlt.entity_id
5100: and xlt.entity_id in (select entity_id from xla_transaction_entities

Line 5100: and xlt.entity_id in (select entity_id from xla_transaction_entities

5096: ,xla_Transaction_entities xlt
5097: where xlt.application_id = 206
5098: and err.accounting_batch_id = p_accounting_batch_id
5099: and err.entity_id = xlt.entity_id
5100: and xlt.entity_id in (select entity_id from xla_transaction_entities
5101: where application_id = 206
5102: and entity_code = 'LOANS'
5103: and source_id_int_1 = p_loan_id
5104: and source_id_int_2 IN

Line 5115: ,XLA_TRANSACTION_ENTITIES XLEE

5111: and dh.status = 'FULLY_FUNDED'
5112: and not exists
5113: (select 'X'
5114: from xla_events xle
5115: ,XLA_TRANSACTION_ENTITIES XLEE
5116: ,xla_ae_headers aeh
5117: where XLE.application_id = 206
5118: and XLE.event_id = disb.event_id
5119: and XLE.entity_id = xlee.entity_id

Line 5139: ,XLA_TRANSACTION_ENTITIES XLEE

5135: and ladj.status = 'APPROVED'
5136: and not exists
5137: (select 'X'
5138: from xla_events xle
5139: ,XLA_TRANSACTION_ENTITIES XLEE
5140: ,xla_ae_headers aeh
5141: where XLE.application_id = 206
5142: and XLE.event_id = disb.event_id
5143: and XLE.entity_id = xlee.entity_id

Line 5183: select entity_id from xla_transaction_entities

5179: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ERS loan accounting');
5180: -- at this point in time, the INVOICES and ADJUSTMENTS MUST have already been accounted for
5181: insert into XLA_ACCT_PROG_DOCS_GT
5182: (entity_id)
5183: select entity_id from xla_transaction_entities
5184: where application_id = 206
5185: and entity_code = 'LOANS'
5186: and source_id_int_1 = p_loan_id
5187: and source_id_int_2 = -1

Line 5197: select entity_id from xla_transaction_entities

5193:
5194: -- can we make join thru lns_distributions
5195: insert into XLA_ACCT_PROG_DOCS_GT
5196: (entity_id)
5197: select entity_id from xla_transaction_entities
5198: where application_id = 206
5199: and entity_code = 'LOANS'
5200: and source_id_int_1 = p_loan_id
5201: and (source_id_int_2 = -1

Line 5987: from xla_transaction_entities xlee

5983:
5984: -- get budgetary control events only
5985: cursor c_events(c_loan_amount_adj_id number, c_event_type varchar2) is
5986: select event_id
5987: from xla_transaction_entities xlee
5988: ,xla_events xle
5989: where xle.application_id = 206
5990: and xle.entity_id = xlee.entity_id
5991: and xlee.source_id_int_3 = c_loan_amount_adj_id

Line 6023: from xla_transaction_entities xlee

6019:
6020:
6021: cursor c_budget_event(c_loan_adj_id number, c_event_type varchar2) is
6022: select count(1)
6023: from xla_transaction_entities xlee
6024: ,xla_events xle
6025: where xle.application_id = 206
6026: and xle.entity_id = xlee.entity_id
6027: and xlee.source_id_int_3 = c_loan_adj_id

Line 6569: from xla_transaction_entities

6565: and lines.reference_id = trx.customer_trx_id;
6566:
6567: cursor c_entities(p_loan_line_id number) is
6568: select entity_id, entity_code, source_id_int_1, transaction_number
6569: from xla_transaction_entities
6570: where application_id = 222
6571: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
6572: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_line_id = p_loan_line_id)
6573: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_line_id = p_loan_line_id))));

Line 6579: ,xla_transaction_entities xlt

6575: -- cursor to get accounting errors
6576: cursor c_acc_errors (p_loan_line_id number, p_accounting_batch_id number) is
6577: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
6578: from xla_accounting_errors err
6579: ,xla_transaction_entities xlt
6580: where xlt.application_id = 222
6581: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
6582: and xlt.entity_id = err.entity_id
6583: and xlt.entity_id in (select entity_id from xla_transaction_entities

Line 6583: and xlt.entity_id in (select entity_id from xla_transaction_entities

6579: ,xla_transaction_entities xlt
6580: where xlt.application_id = 222
6581: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
6582: and xlt.entity_id = err.entity_id
6583: and xlt.entity_id in (select entity_id from xla_transaction_entities
6584: where application_id = 222
6585: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
6586: and ((source_id_int_1 in (select reference_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_line_id = p_loan_line_id))
6587: OR (source_id_int_1 in (select rec_adjustment_id from lns_loan_lines where end_date is null and reference_type = 'RECEIVABLE' and loan_line_id = p_loan_line_id))));

Line 6594: ,xla_transaction_entities ent

6590: cursor C_ERS_LOAN_CLEARING(p_loan_line_id number) is
6591: select sum(ael.entered_dr)
6592: ,ael.code_combination_id
6593: from ar_adjustments_all adj
6594: ,xla_transaction_entities ent
6595: ,xla_ae_headers aeh
6596: ,xla_ae_lines ael
6597: where ent.application_id = 222
6598: and adj.adjustment_id = ent.source_id_int_1

Line 6626: ,xla_transaction_entities ent

6622: cursor C_ERS_LOAN_RECEIVABLE(p_loan_line_id number) is
6623: select sum(ael.entered_dr)
6624: ,ael.code_combination_id
6625: from ra_customer_trx_all inv
6626: ,xla_transaction_entities ent
6627: ,xla_ae_headers aeh
6628: ,xla_ae_lines ael
6629: where ent.application_id = 222
6630: and inv.customer_trx_id = ent.source_id_int_1

Line 6800: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching entities xla_transaction_entities...');

6796:
6797: end loop;
6798: close c_get_line_documents;
6799:
6800: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching entities xla_transaction_entities...');
6801: l_transactions_count := 0;
6802: open c_entities(p_loan_line_id);
6803: loop
6804: fetch c_entities into l_entity_id, l_entity_code, l_source_id_int_1, l_transaction_number;

Line 7645: from xla_transaction_entities xlee

7641: l_PAYMENT_REQUEST_DATE date;
7642:
7643: cursor c_events(p_loan_id number) is
7644: select event_id
7645: from xla_transaction_entities xlee
7646: ,xla_events xle
7647: where xle.application_id = 206
7648: and xle.entity_id = xlee.entity_id
7649: and xlee.source_id_int_1 = p_loan_id

Line 9081: ,xla_transaction_entities xlt

9077: -- cursor to get accounting errors
9078: CURSOR cur_acc_errors(c_event_id NUMBER) IS
9079: SELECT xlt.transaction_number, xlt.entity_code, err.encoded_msg
9080: FROM xla_accounting_errors err
9081: ,xla_transaction_entities xlt
9082: WHERE xlt.application_id = 206
9083: AND xlt.entity_id = err.entity_id
9084: AND err.event_id = C_EVENT_ID;
9085: