APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_DISTRIBUTIONS_ALL

Line 1622: ar_distributions_all ad

1618: ar_payment_schedules_all aps,
1619: ar_receivable_applications_all raa,
1620: ar_cash_receipts_all cra,
1621: okl_strm_type_b sty,
1622: ar_distributions_all ad
1623: WHERE tai.trx_status_code = 'PROCESSED'
1624: AND tai.khr_id = p_contract_id
1625: AND tld.khr_id = p_contract_id
1626: AND tld.kle_id = NVL(p_line_id, tld.kle_id)

Line 1673: FROM ar_distributions_all ad

1669: AND to_char(tld.id) = ractrl.interface_line_attribute14
1670: AND tld.til_id_details = til.id
1671: AND til.tai_id = tai.id
1672: AND EXISTS (SELECT 1
1673: FROM ar_distributions_all ad
1674: WHERE raa.receivable_application_id = ad.source_id
1675: AND ad.source_table = 'RA'
1676: AND ad.ref_customer_trx_Line_Id IS NULL)
1677: GROUP BY cra.receipt_date

Line 1713: ar_distributions_all ad

1709: ar_payment_schedules_all aps,
1710: ar_receivable_applications_all raa,
1711: ra_customer_trx_all cm,
1712: okl_strm_type_b sty,
1713: ar_distributions_all ad
1714: WHERE tai.trx_status_code = 'PROCESSED'
1715: AND tai.khr_id = p_contract_id
1716: AND tld.khr_id = p_contract_id
1717: AND tld.kle_id = NVL(p_line_id, tld.kle_id)

Line 1764: FROM ar_distributions_all ad

1760: AND to_char(tld.id) = ractrl.interface_line_attribute14
1761: AND tld.til_id_details = til.id
1762: AND til.tai_id = tai.id
1763: AND EXISTS (SELECT 1
1764: FROM ar_distributions_all ad
1765: WHERE raa.receivable_application_id = ad.source_id
1766: AND ad.source_table = 'RA'
1767: AND ad.ref_customer_trx_Line_Id IS NULL)
1768: GROUP BY cm.trx_date

Line 1779: ar_distributions_all ad

1775: okl_trx_ar_invoices_b tai,
1776: ar_payment_schedules_all aps,
1777: ar_adjustments_all adj,
1778: okl_strm_type_b sty,
1779: ar_distributions_all ad
1780: WHERE tai.trx_status_code = 'PROCESSED'
1781: AND tai.khr_id = p_contract_id
1782: AND tld.khr_id = p_contract_id
1783: AND tld.kle_id = NVL(p_line_id, tld.kle_id)

Line 4559: FROM ar_distributions_all ad

4555: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4556: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4557: AND vpb.source_id = raa.receivable_application_id)
4558: AND EXISTS (SELECT 1
4559: FROM ar_distributions_all ad
4560: WHERE raa.receivable_application_id = ad.source_id
4561: AND ad.source_table = 'RA'
4562: AND (ad.ref_customer_trx_Line_Id IS NULL OR
4563: ad.ref_customer_trx_Line_Id = ractrl.customer_trx_line_id));

Line 4640: FROM ar_distributions_all ad

4636: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4637: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4638: AND vpb.source_id = raa.receivable_application_id)
4639: AND EXISTS (SELECT 1
4640: FROM ar_distributions_all ad
4641: WHERE raa.receivable_application_id = ad.source_id
4642: AND ad.source_table = 'RA'
4643: AND (ad.ref_customer_trx_Line_Id IS NULL OR
4644: ad.ref_customer_trx_Line_Id = ractrl.customer_trx_line_id));

Line 4981: FROM ar_distributions_all ad

4977: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
4978: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4979: AND vpb.source_id = raa.receivable_application_id)
4980: AND EXISTS (SELECT 1
4981: FROM ar_distributions_all ad
4982: WHERE raa.receivable_application_id = ad.source_id
4983: AND ad.source_table = 'RA'
4984: AND (ad.ref_customer_trx_Line_Id IS NULL OR
4985: ad.ref_customer_trx_Line_Id = ractrl.customer_trx_line_id));

Line 5065: FROM ar_distributions_all ad

5061: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
5062: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
5063: AND vpb.source_id = raa.receivable_application_id)
5064: AND EXISTS (SELECT 1
5065: FROM ar_distributions_all ad
5066: WHERE raa.receivable_application_id = ad.source_id
5067: AND ad.source_table = 'RA'
5068: AND (ad.ref_customer_trx_Line_Id IS NULL OR
5069: ad.ref_customer_trx_Line_Id = ractrl.customer_trx_line_id));