DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 1620: ar_cash_receipts_all cra,

1616: okl_txl_ar_inv_lns_b til,
1617: okl_trx_ar_invoices_b tai,
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

Line 1653: ar_cash_receipts_all cra,

1649: okl_txl_ar_inv_lns_b til,
1650: okl_trx_ar_invoices_b tai,
1651: ar_payment_schedules_all aps,
1652: ar_receivable_applications_all raa,
1653: ar_cash_receipts_all cra,
1654: okl_strm_type_b sty
1655: WHERE tai.trx_status_code = 'PROCESSED'
1656: AND tai.khr_id = p_contract_id
1657: AND tld.khr_id = p_contract_id

Line 2333: ar_cash_receipts_all cra,

2329: 'R' txn_type
2330: FROM okl_bpd_tld_ar_lines_v tld,
2331: ar_payment_schedules_all aps,
2332: ar_receivable_applications_all raa,
2333: ar_cash_receipts_all cra,
2334: okl_strm_type_v sty
2335: WHERE tld.trx_status_code = 'PROCESSED'
2336: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
2337: AND tld.customer_trx_id = aps.customer_trx_id

Line 4535: ,ar_cash_receipts_all cra

4531: ,okl_txl_ar_inv_lns_b til
4532: ,okl_trx_ar_invoices_b tai
4533: ,ar_payment_schedules_all aps
4534: ,ar_receivable_applications_all raa
4535: ,ar_cash_receipts_all cra
4536: ,okl_strm_type_b sty
4537: WHERE tai.trx_status_code = 'PROCESSED'
4538: AND tai.khr_id = cp_khr_id
4539: AND tld.khr_id = cp_khr_id

Line 4957: ,ar_cash_receipts_all cra

4953: ,okl_txl_ar_inv_lns_b til
4954: ,okl_trx_ar_invoices_b tai
4955: ,ar_payment_schedules_all aps
4956: ,ar_receivable_applications_all raa
4957: ,ar_cash_receipts_all cra
4958: ,okl_strm_type_b sty
4959: WHERE tai.trx_status_code = 'PROCESSED'
4960: AND tai.khr_id = cp_khr_id
4961: AND tld.khr_id = cp_khr_id