APPS.OKL_POOL_PVT dependencies on OKL_POOL_SRCH_V

Line 2616: FROM okl_pool_srch_v pol

2612: ,MIN(pol.stream_element_due_date) streams_from_date
2613: ,DECODE(pol.stream_type_subclass, 'RESIDUAL', NULL, pol.end_date) streams_to_date
2614: -- mvasudev, stm_id changes
2615: ,pol.stm_id
2616: FROM okl_pool_srch_v pol
2617: WHERE
2618: -- pre-req
2619: pol.currency_code = p_currency_code
2620: AND pol.sts_code = 'BOOKED'

Line 2692: -- link from okl_pool_srch_v pol

2688: okc_k_lines_b cle
2689: WHERE cle.id = tal.kle_id
2690: AND tal.id = tdas.tal_id
2691: AND tal.tal_type = 'ALI'
2692: -- link from okl_pool_srch_v pol
2693: AND cle.cle_id = pol.kle_id -- top line id
2694: AND tal.dnz_khr_id = pol.dnz_chr_id
2695: -- link from okl_pool_srch_v pol
2696: AND EXISTS (SELECT '1'

Line 2695: -- link from okl_pool_srch_v pol

2691: AND tal.tal_type = 'ALI'
2692: -- link from okl_pool_srch_v pol
2693: AND cle.cle_id = pol.kle_id -- top line id
2694: AND tal.dnz_khr_id = pol.dnz_chr_id
2695: -- link from okl_pool_srch_v pol
2696: AND EXISTS (SELECT '1'
2697: FROM okl_trx_assets tas
2698: WHERE tas.id = tal.tas_id
2699: AND tas.tas_type = 'ALI'

Line 2819: -- link from okl_pool_srch_v pol

2815: okc_k_lines_b cle
2816: WHERE cle.id = tal.kle_id
2817: AND tal.id = tdas.tal_id
2818: AND tal.tal_type = 'ALI'
2819: -- link from okl_pool_srch_v pol
2820: AND cle.cle_id = pol.kle_id -- top line id
2821: AND tal.dnz_khr_id = pol.dnz_chr_id
2822: -- link from okl_pool_srch_v pol
2823: AND EXISTS (SELECT '1'

Line 2822: -- link from okl_pool_srch_v pol

2818: AND tal.tal_type = 'ALI'
2819: -- link from okl_pool_srch_v pol
2820: AND cle.cle_id = pol.kle_id -- top line id
2821: AND tal.dnz_khr_id = pol.dnz_chr_id
2822: -- link from okl_pool_srch_v pol
2823: AND EXISTS (SELECT '1'
2824: FROM okl_trx_assets tas
2825: WHERE tas.id = tal.tas_id
2826: AND tas.tas_type = 'ALI'

Line 3085: FROM okl_pool_srch_v pol

3081: ,pol.lessee
3082: ,lkup.meaning sty_subclass_meaning
3083: ,pol.asset_number
3084: ,hcp.credit_classification
3085: FROM okl_pool_srch_v pol
3086: ,fnd_lookups lkup
3087: ,hz_customer_profiles hcp
3088: WHERE
3089: -- pre-req

Line 3229: -- link from okl_pool_srch_v pol

3225: okc_k_lines_b cle
3226: WHERE cle.id = tal.kle_id
3227: AND tal.id = tdas.tal_id
3228: AND tal.tal_type = 'ALI'
3229: -- link from okl_pool_srch_v pol
3230: AND cle.cle_id = p_kle_id -- top line id
3231: AND tal.dnz_khr_id = p_dnz_chr_id
3232: -- link from okl_pool_srch_v pol
3233: AND EXISTS (SELECT '1'

Line 3232: -- link from okl_pool_srch_v pol

3228: AND tal.tal_type = 'ALI'
3229: -- link from okl_pool_srch_v pol
3230: AND cle.cle_id = p_kle_id -- top line id
3231: AND tal.dnz_khr_id = p_dnz_chr_id
3232: -- link from okl_pool_srch_v pol
3233: AND EXISTS (SELECT '1'
3234: FROM okl_trx_assets tas
3235: WHERE tas.id = tal.tas_id
3236: AND tas.tas_type = 'ALI'