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 7439: ,okl_pool_contents pocb

7435: IS
7436: SELECT NVL(SUM(selb.amount),0) total_amount
7437: FROM okl_strm_elements selb
7438: ,okl_streams stmb
7439: ,okl_pool_contents pocb
7440: ,okl_strm_type_v styv --ankushar --Bug 6594724
7441: ,okc_k_headers_b chrb --ankushar --Bug 6594724
7442: WHERE stmb.khr_id = p_dnz_chr_id
7443: AND stmb.kle_id = p_kle_id

Line 7491: ,okl_pool_contents pocb

7487: IS
7488: SELECT NVL(SUM(selb.amount),0) total_amount
7489: FROM okl_strm_elements selb
7490: ,okl_streams stmb
7491: ,okl_pool_contents pocb
7492: WHERE stmb.khr_id = p_dnz_chr_id
7493: AND stmb.kle_id = p_kle_id
7494: AND stmb.sty_id = p_sty_id
7495: AND selb.stm_id = stmb.id

Line 7588: ,okl_pool_contents pocb

7584: SELECT NVL(SUM(selb.amount),0) total_amount
7585: FROM okl_strm_elements selb
7586: ,okl_streams stmb
7587: ,okl_strm_type_v styv
7588: ,okl_pool_contents pocb
7589: WHERE stmb.source_id = p_chr_id
7590: AND styv.stream_type_purpose = p_sty_purpose
7591: AND stmb.sty_id = styv.id
7592: AND selb.stm_id = stmb.id

Line 7605: ,okl_pool_contents pocb

7601: SELECT NVL(SUM(selb.amount),0) total_amount
7602: FROM okl_strm_elements selb
7603: ,okl_streams stmb
7604: ,okl_strm_type_v styv
7605: ,okl_pool_contents pocb
7606: WHERE stmb.source_id = p_chr_id
7607: AND styv.stream_type_purpose = p_sty_purpose
7608: AND stmb.sty_id = styv.id
7609: AND selb.stm_id = stmb.id

Line 7841: FROM OKL_POOL_CONTENTS POC,

7837: AND STYV.STREAM_TYPE_PURPOSE IN ('INVESTOR_PRETAX_INCOME','INVESTOR_RENTAL_ACCRUAL','INVESTOR_INTEREST_INCOME')
7838: AND STMB.SAY_CODE = 'CURR'
7839: AND STMB.ACTIVE_YN = 'Y'
7840: AND EXISTS (SELECT 1
7841: FROM OKL_POOL_CONTENTS POC,
7842: OKL_POOLS POL,
7843: OKL_STRM_TYPE_V STYS
7844: WHERE POC.POL_ID = POL.ID
7845: AND POC.KHR_ID = STMB.KHR_ID

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

7859: AND STMB.STY_ID = STYV.ID
7860: AND STYV.STREAM_TYPE_PURPOSE IN ('INVESTOR_PRETAX_INCOME','INVESTOR_RENTAL_ACCRUAL','INVESTOR_INTEREST_INCOME')
7861: AND STMB.SAY_CODE = 'CURR'
7862: AND STMB.ACTIVE_YN = 'Y'
7863: AND EXISTS (SELECT 1 FROM OKL_POOL_CONTENTS POC,
7864: OKL_POOLS POL,
7865: OKL_STRM_TYPE_V STYS
7866: WHERE POC.POL_ID = POL.ID
7867: AND POC.KHR_ID = STMB.KHR_ID

Line 8061: okl_pool_contents pocb

8057: FROM
8058: okl_strm_type_v styv,
8059: okl_streams stmb,
8060: okl_strm_elements selb,
8061: okl_pool_contents pocb
8062: WHERE styv.stream_type_subclass = p_stm_sub_class
8063: AND styv.id = stmb.sty_id
8064: AND stmb.id = selb.stm_id
8065: AND pocb.pol_id = p_pol_id

Line 8082: okl_pool_contents pocb

8078: FROM
8079: okl_strm_type_v styv,
8080: okl_streams stmb,
8081: okl_strm_elements selb,
8082: okl_pool_contents pocb
8083: WHERE styv.stream_type_subclass = p_stm_sub_class
8084: AND styv.id = stmb.sty_id
8085: AND stmb.id = selb.stm_id
8086: AND pocb.pol_id = p_pol_id

Line 8792: ,okl_pool_contents pocb

8788: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
8789: FROM okl_streams stm,
8790: okl_strm_type_b sty,
8791: okl_strm_elements ste
8792: ,okl_pool_contents pocb
8793: WHERE stm.khr_id = cp_contract_id
8794: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
8795: AND stm.active_yn = 'Y'
8796: AND stm.say_code = 'CURR'

Line 8819: ,okl_pool_contents pocb

8815: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
8816: FROM okl_streams stm,
8817: okl_strm_type_b sty,
8818: okl_strm_elements ste
8819: ,okl_pool_contents pocb
8820: WHERE stm.khr_id = cp_contract_id
8821: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
8822: AND stm.active_yn = 'Y'
8823: AND stm.say_code= 'CURR'

Line 8843: ,okl_pool_contents pocb

8839: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
8840: FROM okl_streams stm,
8841: okl_strm_type_b sty,
8842: okl_strm_elements ste
8843: ,okl_pool_contents pocb
8844: WHERE stm.khr_id = cp_contract_id
8845: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
8846: AND stm.active_yn = 'Y'
8847: AND stm.say_code = 'CURR'

Line 8869: ,okl_pool_contents pocb

8865: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
8866: FROM okl_streams stm,
8867: okl_strm_type_b sty,
8868: okl_strm_elements ste
8869: ,okl_pool_contents pocb
8870: WHERE stm.khr_id = cp_contract_id
8871: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
8872: AND stm.active_yn = 'Y'
8873: AND stm.say_code = 'CURR'

Line 9063: okl_pool_contents pocb

9059: SELECT NVL(SUM (NVL (ste.amount, 0)), 0) amount_due
9060: FROM okl_streams stm,
9061: okl_strm_type_b sty,
9062: okl_strm_elements ste,
9063: okl_pool_contents pocb
9064: WHERE stm.khr_id = cp_contract_id
9065: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9066: AND stm.active_yn = 'Y'
9067: AND stm.say_code = 'CURR'

Line 9088: okl_pool_contents pocb

9084: SELECT NVL(SUM (NVL (ste.amount, 0)), 0) amount_due
9085: FROM okl_streams stm,
9086: okl_strm_type_b sty,
9087: okl_strm_elements ste,
9088: okl_pool_contents pocb
9089: WHERE stm.khr_id = cp_contract_id
9090: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9091: AND stm.active_yn = 'Y'
9092: AND stm.say_code = 'CURR'

Line 9214: ,okl_pool_contents pocb

9210: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
9211: FROM okl_streams stm,
9212: okl_strm_type_b sty,
9213: okl_strm_elements ste
9214: ,okl_pool_contents pocb
9215: WHERE stm.khr_id = cp_contract_id
9216: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9217: AND stm.active_yn = 'Y'
9218: AND stm.say_code = 'CURR'

Line 9239: ,okl_pool_contents pocb

9235: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
9236: FROM okl_streams stm,
9237: okl_strm_type_b sty,
9238: okl_strm_elements ste
9239: ,okl_pool_contents pocb
9240: WHERE stm.khr_id = cp_contract_id
9241: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9242: AND stm.active_yn = 'Y'
9243: AND stm.say_code= 'CURR'

Line 9262: okl_pool_contents pocb

9258: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_due
9259: FROM okl_streams stm,
9260: okl_strm_type_b sty,
9261: okl_strm_elements ste,
9262: okl_pool_contents pocb
9263: WHERE stm.khr_id = cp_contract_id
9264: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9265: AND stm.active_yn = 'Y'
9266: AND stm.say_code = 'CURR'

Line 9287: okl_pool_contents pocb

9283: SELECT NVL(SUM (NVL (ste.amount, 0)),0) amount_payable
9284: FROM okl_streams stm,
9285: okl_strm_type_b sty,
9286: okl_strm_elements ste,
9287: okl_pool_contents pocb
9288: WHERE stm.khr_id = cp_contract_id
9289: AND stm.kle_id = NVL(cp_contract_line_id, stm.kle_id)
9290: AND stm.active_yn = 'Y'
9291: AND stm.say_code = 'CURR'