DBA Data[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on XLA_TRANSACTION_ENTITIES

Line 56: from xla_transaction_entities xlee

52: l_disbursement_id number;
53:
54: cursor c_events(p_loan_id number) is
55: select event_id
56: from xla_transaction_entities xlee
57: ,xla_events xle
58: where xle.application_id = 206
59: and xle.entity_id = xlee.entity_id
60: and xlee.source_id_int_1 = p_loan_id

Line 278: from xla_transaction_entities xlee

274: l_sequence_id number;
275:
276: cursor c_event (p_loan_id number) is
277: select xle.event_id, xll.source_distribution_id_num_1, ledger_id
278: from xla_transaction_entities xlee
279: ,xla_events xle
280: ,xla_distribution_links xll
281: where xle.application_id = 206
282: and xle.entity_id = xlee.entity_id

Line 417: from xla_transaction_entities xlee

413:
414: -- get budgetary control events only
415: cursor c_events(p_loan_id number) is
416: select event_id
417: from xla_transaction_entities xlee
418: ,xla_events xle
419: where xle.application_id = 206
420: and xle.entity_id = xlee.entity_id
421: and xlee.source_id_int_1 = p_loan_id

Line 439: from xla_transaction_entities xlee

435: where loan_id = p_loan_id;
436:
437: cursor c_budget_event(p_loan_id number, p_disb_header_id number) is
438: select count(1)
439: from xla_transaction_entities xlee
440: ,xla_events xle
441: where xle.application_id = 206
442: and xle.entity_id = xlee.entity_id
443: and xlee.source_id_int_1 = p_loan_id

Line 3335: ,xla_transaction_entities ent

3331: cursor C_ERS_LOAN_RECEIVABLE(p_loan_id number) is
3332: select sum(ael.entered_dr)
3333: ,ael.code_combination_id
3334: from ra_customer_trx_all inv
3335: ,xla_transaction_entities ent
3336: ,xla_ae_headers aeh
3337: ,xla_ae_lines ael
3338: where ent.application_id = 222
3339: and inv.customer_trx_id = ent.source_id_int_1

Line 3370: ,xla_transaction_entities ent

3366: cursor C_ERS_LOAN_CLEARING(p_loan_id number) is
3367: select sum(ael.entered_dr)
3368: ,ael.code_combination_id
3369: from ar_adjustments_all adj
3370: ,xla_transaction_entities ent
3371: ,xla_ae_headers aeh
3372: ,xla_ae_lines ael
3373: where ent.application_id = 222
3374: and adj.adjustment_id = ent.source_id_int_1

Line 3449: ,xla_transaction_entities xlt

3445: -- cursor to get accounting errors
3446: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is
3447: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
3448: from xla_accounting_errors err
3449: ,xla_transaction_entities xlt
3450: where xlt.application_id = 222
3451: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
3452: and xlt.entity_id = err.entity_id
3453: and xlt.entity_id in (select entity_id from xla_transaction_entities

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

3449: ,xla_transaction_entities xlt
3450: where xlt.application_id = 222
3451: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
3452: and xlt.entity_id = err.entity_id
3453: and xlt.entity_id in (select entity_id from xla_transaction_entities
3454: where application_id = 222
3455: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
3456: 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))
3457: 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 3461: from xla_transaction_entities

3457: 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))));
3458: -- -----------------------------------------------------------------
3459: cursor c_entities(p_loan_id number) is
3460: select entity_id, entity_code, source_id_int_1, transaction_number
3461: from xla_transaction_entities
3462: where application_id = 222
3463: and entity_code IN ('TRANSACTIONS', 'ADJUSTMENTS')
3464: 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)
3465: 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 3676: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching entities xla_transaction_entities...');

3672:
3673: end loop;
3674: close c_get_loan_documents;
3675:
3676: logMessage(FND_LOG.level_statement, G_PKG_NAME, 'Fetching entities xla_transaction_entities...');
3677: l_transactions_count := 0;
3678: open c_entities(p_loan_id);
3679: loop
3680: fetch c_entities into l_entity_id, l_entity_code, l_source_id_int_1, l_transaction_number;

Line 4135: ,xla_Transaction_entities xlt

4131: -- this is only for loans entities
4132: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is
4133: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
4134: from xla_accounting_errors err
4135: ,xla_Transaction_entities xlt
4136: where xlt.application_id = 206
4137: and err.accounting_batch_id = p_accounting_batch_id
4138: and err.entity_id = xlt.entity_id
4139: and xlt.entity_id in (select entity_id from xla_transaction_entities

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

4135: ,xla_Transaction_entities xlt
4136: where xlt.application_id = 206
4137: and err.accounting_batch_id = p_accounting_batch_id
4138: and err.entity_id = xlt.entity_id
4139: and xlt.entity_id in (select entity_id from xla_transaction_entities
4140: where application_id = 206
4141: and entity_code = 'LOANS'
4142: and source_id_int_1 = p_loan_id
4143: and source_id_int_2 IN

Line 4154: ,XLA_TRANSACTION_ENTITIES XLEE

4150: and dh.status = 'FULLY_FUNDED'
4151: and not exists
4152: (select 'X'
4153: from xla_events xle
4154: ,XLA_TRANSACTION_ENTITIES XLEE
4155: ,xla_ae_headers aeh
4156: where XLE.application_id = 206
4157: and XLE.event_id = disb.event_id
4158: and XLE.entity_id = xlee.entity_id

Line 4196: select entity_id from xla_transaction_entities

4192: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ERS loan accounting');
4193: -- at this point in time, the INVOICES and ADJUSTMENTS MUST have already been accounted for
4194: insert into XLA_ACCT_PROG_DOCS_GT
4195: (entity_id)
4196: select entity_id from xla_transaction_entities
4197: where application_id = 206
4198: and entity_code = 'LOANS'
4199: and source_id_int_1 = p_loan_id
4200: and source_id_int_2 = -1;

Line 4209: select entity_id from xla_transaction_entities

4205:
4206: -- can we make join thru lns_distributions
4207: insert into XLA_ACCT_PROG_DOCS_GT
4208: (entity_id)
4209: select entity_id from xla_transaction_entities
4210: where application_id = 206
4211: and entity_code = 'LOANS'
4212: and source_id_int_1 = p_loan_id
4213: and source_id_int_2 in (select disb.disb_header_id

Line 4223: -- ,XLA_TRANSACTION_ENTITIES XLEE

4219: and dh.status = 'FULLY_FUNDED');
4220: -- and not exists
4221: -- (select 'X'
4222: -- from xla_events xle
4223: -- ,XLA_TRANSACTION_ENTITIES XLEE
4224: -- ,xla_ae_headers aeh
4225: -- where XLE.application_id = 206
4226: -- and XLE.event_id = disb.event_id
4227: -- and XLE.entity_id = xlee.entity_id