[Home] [Help]
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
4169: and lline.reference_id = ent.source_id_int_1
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
4209: and ent.entity_code = 'ADJUSTMENTS'
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
5120: and XLEE.source_id_int_1 = dh.loan_id
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
5144: and XLEE.source_id_int_1 = ladj.loan_id
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
6599: and ent.entity_code = 'ADJUSTMENTS'
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
6631: and ent.entity_code = 'TRANSACTIONS'