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_ACCRUAL_SEC_PVT dependencies on OKL_POOL_CONTENTS

Line 85: FROM okl_pool_contents opc,

81: IS
82: SELECT DISTINCT opc.khr_id khr_id,
83: opc.streams_to_date end_date,
84: khr.deal_type deal_type
85: FROM okl_pool_contents opc,
86: okl_pools op,
87: okl_k_headers khr,
88: -- Changed for User Defined Streams
89: --okl_strm_type_tl stytl

Line 106: FROM okl_pool_contents opc,

102: CURSOR get_kle_id_csr(p_khr_id NUMBER)
103: IS
104: SELECT opc.kle_id kle_id,
105: MIN(opc.streams_from_date) start_date
106: FROM okl_pool_contents opc,
107: okl_strm_type_b sty
108: WHERE opc.khr_id = p_khr_id
109: AND opc.sty_id = sty.id
110: --AND sty.code = 'RENT'

Line 129: FROM okl_pool_contents opc,

125: IS
126: SELECT DISTINCT opc.khr_id khr_id,
127: opc.streams_to_date end_date,
128: khr.deal_type deal_type
129: FROM okl_pool_contents opc,
130: okl_pools op,
131: okl_k_headers khr,
132: -- Changed for User Defined Streams
133: --okl_strm_type_tl stytl

Line 151: FROM okl_pool_contents opc,

147: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)
148: IS
149: SELECT opc.kle_id kle_id,
150: MIN(opc.streams_from_date) start_date
151: FROM okl_pool_contents opc,
152: okl_strm_type_b sty
153: WHERE opc.khr_id = p_khr_id
154: AND opc.sty_id = sty.id
155: --AND sty.code = 'RENT'

Line 164: FROM okl_pool_contents opc,

160:
161: CURSOR get_inv_pend_csr (p_khr_id NUMBER)
162: IS
163: SELECT DISTINCT op.khr_id
164: FROM okl_pool_contents opc,
165: okl_pools op,
166: okl_strm_type_b sty
167: WHERE op.id = opc.pol_id
168: AND opc.khr_id = p_khr_id

Line 239: FROM okl_pool_contents opc,

235: -- for a given Lease contract id
236: CURSOR get_inv_csr (p_khr_id NUMBER)
237: IS
238: SELECT DISTINCT op.khr_id
239: FROM okl_pool_contents opc,
240: okl_pools op,
241: okl_strm_type_b sty
242: WHERE op.id = opc.pol_id
243: AND opc.khr_id = p_khr_id

Line 1445: FROM OKL_POOL_CONTENTS opc,

1441: IS
1442: SELECT DISTINCT opc.khr_id khr_id,
1443: opc.streams_to_date end_date,
1444: khr.deal_type deal_type
1445: FROM OKL_POOL_CONTENTS opc,
1446: OKL_POOLS op,
1447: OKL_K_HEADERS khr,
1448: OKL_STRM_TYPE_B stytl
1449: WHERE op.khr_id = p_inv_id

Line 1463: FROM OKL_POOL_CONTENTS opc,

1459: CURSOR get_kle_id_csr(p_khr_id NUMBER)
1460: IS
1461: SELECT opc.kle_id kle_id,
1462: MIN(opc.streams_from_date) start_date
1463: FROM OKL_POOL_CONTENTS opc,
1464: OKL_STRM_TYPE_B sty
1465: WHERE opc.khr_id = p_khr_id
1466: AND opc.sty_id = sty.id
1467: --AND sty.code = 'RENT'

Line 1483: FROM OKL_POOL_CONTENTS opc,

1479: IS
1480: SELECT DISTINCT opc.khr_id khr_id,
1481: opc.streams_to_date end_date,
1482: khr.deal_type deal_type
1483: FROM OKL_POOL_CONTENTS opc,
1484: OKL_POOLS op,
1485: OKL_K_HEADERS khr,
1486: OKL_STRM_TYPE_B stytl
1487: WHERE op.khr_id = p_inv_id

Line 1501: FROM OKL_POOL_CONTENTS opc,

1497: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)
1498: IS
1499: SELECT opc.kle_id kle_id,
1500: MIN(opc.streams_from_date) start_date
1501: FROM OKL_POOL_CONTENTS opc,
1502: OKL_STRM_TYPE_B sty
1503: WHERE opc.khr_id = p_khr_id
1504: AND opc.sty_id = sty.id
1505: --AND sty.code = 'RENT'

Line 4160: FROM OKL_POOL_CONTENTS opc,

4156: CURSOR get_kle_id_pend_csr(p_khr_id NUMBER)
4157: IS
4158: SELECT opc.kle_id kle_id,
4159: MIN(opc.streams_from_date) start_date
4160: FROM OKL_POOL_CONTENTS opc,
4161: OKL_STRM_TYPE_B sty
4162: WHERE opc.khr_id = p_khr_id
4163: AND opc.sty_id = sty.id
4164: --AND sty.code = 'RENT'