eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_POOL_CONTENTS

Line 8088: ,okl_pool_contents pocb

8084: IS
8085: SELECT NVL(SUM(selb.amount),0) total_amount
8086: FROM okl_strm_elements selb
8087: ,okl_streams stmb
8088: ,okl_pool_contents pocb
8089: ,okl_strm_type_v styv --ankushar --Bug 6594724
8090: ,okc_k_headers_b chrb --ankushar --Bug 6594724
8091: WHERE stmb.khr_id = p_dnz_chr_id
8092: AND stmb.kle_id = p_kle_id

Line 8140: ,okl_pool_contents pocb

8136: IS
8137: SELECT NVL(SUM(selb.amount),0) total_amount
8138: FROM okl_strm_elements selb
8139: ,okl_streams stmb
8140: ,okl_pool_contents pocb
8141: WHERE stmb.khr_id = p_dnz_chr_id
8142: AND stmb.kle_id = p_kle_id
8143: AND stmb.sty_id = p_sty_id
8144: AND selb.stm_id = stmb.id

Line 8239: ,okl_pool_contents pocb

8235: SELECT NVL(SUM(selb.amount),0) total_amount
8236: FROM okl_strm_elements selb
8237: ,okl_streams stmb
8238: ,okl_strm_type_v styv
8239: ,okl_pool_contents pocb
8240: ,okl_strm_type_v styv1
8241: WHERE stmb.source_id = p_chr_id
8242: AND styv.stream_type_purpose = p_sty_purpose
8243: AND stmb.sty_id = styv.id

Line 8261: ,okl_pool_contents pocb

8257: SELECT NVL(SUM(selb.amount),0) total_amount
8258: FROM okl_strm_elements selb
8259: ,okl_streams stmb
8260: ,okl_strm_type_v styv
8261: ,okl_pool_contents pocb
8262: ,okl_strm_type_v styv1
8263: WHERE stmb.source_id = p_chr_id
8264: AND styv.stream_type_purpose = p_sty_purpose
8265: AND stmb.sty_id = styv.id

Line 8515: FROM OKL_POOL_CONTENTS POC,

8511: AND STYV.STREAM_TYPE_PURPOSE IN ('INVESTOR_PRETAX_INCOME','INVESTOR_RENTAL_ACCRUAL','INVESTOR_INTEREST_INCOME')
8512: AND STMB.SAY_CODE = 'CURR'
8513: AND STMB.ACTIVE_YN = 'Y'
8514: AND EXISTS (SELECT 1
8515: FROM OKL_POOL_CONTENTS POC,
8516: OKL_POOLS POL,
8517: OKL_STRM_TYPE_V STYS
8518: WHERE POC.POL_ID = POL.ID
8519: AND POC.KHR_ID = STMB.KHR_ID

Line 8537: AND EXISTS (SELECT 1 FROM OKL_POOL_CONTENTS POC,

8533: AND STMB.STY_ID = STYV.ID
8534: AND STYV.STREAM_TYPE_PURPOSE IN ('INVESTOR_PRETAX_INCOME','INVESTOR_RENTAL_ACCRUAL','INVESTOR_INTEREST_INCOME')
8535: AND STMB.SAY_CODE = 'CURR'
8536: AND STMB.ACTIVE_YN = 'Y'
8537: AND EXISTS (SELECT 1 FROM OKL_POOL_CONTENTS POC,
8538: OKL_POOLS POL,
8539: OKL_STRM_TYPE_V STYS
8540: WHERE POC.POL_ID = POL.ID
8541: AND POC.KHR_ID = STMB.KHR_ID

Line 8735: okl_pool_contents pocb

8731: FROM
8732: okl_strm_type_v styv,
8733: okl_streams stmb,
8734: okl_strm_elements selb,
8735: okl_pool_contents pocb
8736: WHERE styv.stream_type_subclass = p_stm_sub_class
8737: AND styv.id = stmb.sty_id
8738: AND stmb.id = selb.stm_id
8739: AND pocb.pol_id = p_pol_id

Line 8756: okl_pool_contents pocb

8752: FROM
8753: okl_strm_type_v styv,
8754: okl_streams stmb,
8755: okl_strm_elements selb,
8756: okl_pool_contents pocb
8757: WHERE styv.stream_type_subclass = p_stm_sub_class
8758: AND styv.id = stmb.sty_id
8759: AND stmb.id = selb.stm_id
8760: AND pocb.pol_id = p_pol_id

Line 9642: ,okl_pool_contents pocb

9638: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
9639: FROM okl_streams stm,
9640: okl_strm_type_b sty,
9641: okl_strm_elements ste
9642: ,okl_pool_contents pocb
9643: WHERE stm.khr_id = cp_contract_id
9644: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9645: AND stm.active_yn = 'Y'
9646: AND stm.say_code = 'CURR'

Line 9669: -- ,okl_pool_contents pocb

9665: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
9666: FROM okl_streams stm,
9667: okl_strm_type_b sty,
9668: okl_strm_elements ste
9669: -- ,okl_pool_contents pocb
9670: WHERE stm.khr_id = cp_contract_id
9671: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9672: AND stm.active_yn = 'Y'
9673: AND stm.say_code= 'CURR'

Line 9694: ,okl_pool_contents pocb

9690: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
9691: FROM okl_streams stm,
9692: okl_strm_type_b sty,
9693: okl_strm_elements ste
9694: ,okl_pool_contents pocb
9695: WHERE stm.khr_id = cp_contract_id
9696: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9697: AND stm.active_yn = 'Y'
9698: AND stm.say_code = 'CURR'

Line 9720: --,okl_pool_contents pocb

9716: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
9717: FROM okl_streams stm,
9718: okl_strm_type_b sty,
9719: okl_strm_elements ste
9720: --,okl_pool_contents pocb
9721: WHERE stm.khr_id = cp_contract_id
9722: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9723: AND stm.active_yn = 'Y'
9724: AND stm.say_code = 'CURR'

Line 9915: okl_pool_contents pocb

9911: SELECT NVL(SUM (NVL (ste.amount, 0)), 0) amount_due
9912: FROM okl_streams stm,
9913: okl_strm_type_b sty,
9914: okl_strm_elements ste,
9915: okl_pool_contents pocb
9916: WHERE stm.khr_id = cp_contract_id
9917: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9918: AND stm.active_yn = 'Y'
9919: AND stm.say_code = 'CURR'

Line 9940: okl_pool_contents pocb

9936: SELECT NVL(SUM (NVL (ste.amount, 0)), 0) amount_due
9937: FROM okl_streams stm,
9938: okl_strm_type_b sty,
9939: okl_strm_elements ste,
9940: okl_pool_contents pocb
9941: WHERE stm.khr_id = cp_contract_id
9942: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9943: AND stm.active_yn = 'Y'
9944: AND stm.say_code = 'CURR'

Line 10066: ,okl_pool_contents pocb

10062: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
10063: FROM okl_streams stm,
10064: okl_strm_type_b sty,
10065: okl_strm_elements ste
10066: ,okl_pool_contents pocb
10067: WHERE stm.khr_id = cp_contract_id
10068: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
10069: AND stm.active_yn = 'Y'
10070: AND stm.say_code = 'CURR'

Line 10091: ,okl_pool_contents pocb

10087: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
10088: FROM okl_streams stm,
10089: okl_strm_type_b sty,
10090: okl_strm_elements ste
10091: ,okl_pool_contents pocb
10092: WHERE stm.khr_id = cp_contract_id
10093: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
10094: AND stm.active_yn = 'Y'
10095: AND stm.say_code= 'CURR'

Line 10114: okl_pool_contents pocb

10110: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
10111: FROM okl_streams stm,
10112: okl_strm_type_b sty,
10113: okl_strm_elements ste,
10114: okl_pool_contents pocb
10115: WHERE stm.khr_id = cp_contract_id
10116: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
10117: AND stm.active_yn = 'Y'
10118: AND stm.say_code = 'CURR'

Line 10139: okl_pool_contents pocb

10135: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
10136: FROM okl_streams stm,
10137: okl_strm_type_b sty,
10138: okl_strm_elements ste,
10139: okl_pool_contents pocb
10140: WHERE stm.khr_id = cp_contract_id
10141: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
10142: AND stm.active_yn = 'Y'
10143: AND stm.say_code = 'CURR'