APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_DISTRIBUTIONS_ALL

Line 4286: ar_distributions_all ad

4282: ar_payment_schedules_all aps,
4283: ar_receivable_applications_all raa,
4284: ar_cash_receipts_all cra,
4285: okl_strm_type_b sty,
4286: ar_distributions_all ad
4287: WHERE tai.trx_status_code = 'PROCESSED'
4288: AND tai.khr_id = p_contract_id
4289: AND tld.khr_id = p_contract_id
4290: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 4333: FROM ar_distributions_all ad

4329: AND to_char(tld.id) = ractrl.interface_line_attribute14
4330: AND tld.til_id_details = til.id
4331: AND til.tai_id = tai.id
4332: AND EXISTS (SELECT 1
4333: FROM ar_distributions_all ad
4334: WHERE raa.receivable_application_id = ad.source_id
4335: AND ad.source_table = 'RA'
4336: AND ad.ref_customer_trx_Line_Id IS NULL)
4337: GROUP BY cra.receipt_date

Line 7866: FROM ar_distributions_all ad

7862: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
7863: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
7864: AND vpb.source_id = raa.receivable_application_id)
7865: AND EXISTS (SELECT 1
7866: FROM ar_distributions_all ad
7867: WHERE raa.receivable_application_id = ad.source_id
7868: AND ad.source_table = 'RA'
7869: AND (ad.ref_customer_trx_Line_Id IS NULL OR
7870: ad.ref_customer_trx_Line_Id = ractrl.customer_trx_line_id));

Line 8159: FROM ar_distributions_all ad

8155: AND vpb.source_table = 'AR_RECEIVABLE_APPLICATIONS_ALL'
8156: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
8157: AND vpb.source_id = raa.receivable_application_id)
8158: AND EXISTS (SELECT 1
8159: FROM ar_distributions_all ad
8160: WHERE raa.receivable_application_id = ad.source_id
8161: AND ad.source_table = 'RA'
8162: AND (ad.ref_customer_trx_Line_Id IS NULL OR
8163: ad.ref_customer_trx_Line_Id = ractrl.customer_trx_line_id));