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_STRM_TYPE_B

Line 88: okl_strm_type_b stytl

84: okl_pools op,
85: okl_k_headers khr,
86: -- Changed for User Defined Streams
87: --okl_strm_type_tl stytl
88: okl_strm_type_b stytl
89: WHERE op.khr_id = p_inv_id
90: AND opc.khr_id = p_khr_id
91: AND op.id = opc.pol_id
92: AND opc.khr_id = khr.id

Line 105: okl_strm_type_b sty

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

Line 132: okl_strm_type_b stytl

128: okl_pools op,
129: okl_k_headers khr,
130: -- Changed for User Defined Streams
131: --okl_strm_type_tl stytl
132: okl_strm_type_b stytl
133: WHERE op.khr_id = p_inv_id
134: AND opc.khr_id = p_khr_id
135: AND op.id = opc.pol_id
136: AND opc.khr_id = khr.id

Line 150: okl_strm_type_b sty

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

Line 164: okl_strm_type_b sty

160: IS
161: SELECT DISTINCT op.khr_id
162: FROM okl_pool_contents opc,
163: okl_pools op,
164: okl_strm_type_b sty
165: WHERE op.id = opc.pol_id
166: AND opc.khr_id = p_khr_id
167: AND opc.sty_id = sty.id
168: --AND sty.code = 'RENT';

Line 184: okl_strm_type_b strm

180: FROM okc_k_headers_b k,
181: okc_rule_groups_b rg,
182: okc_rules_b slh,
183: okc_rules_b sll,
184: okl_strm_type_b strm
185: WHERE slh.rule_information_category = 'LASLH'
186: AND slh.rgp_id = rg.id
187: AND sll.object2_id1 = to_char(slh.id)
188: AND sll.rgp_id = rg.id

Line 239: okl_strm_type_b sty

235: IS
236: SELECT DISTINCT op.khr_id
237: FROM okl_pool_contents opc,
238: okl_pools op,
239: okl_strm_type_b sty
240: WHERE op.id = opc.pol_id
241: AND opc.khr_id = p_khr_id
242: AND opc.sty_id = sty.id
243: --AND sty.code = 'RENT';

Line 268: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

264: end_date DATE,
265: l_stream_type_purpose VARCHAR2)
266: IS
267: select ste.stream_element_date stream_element_date,ste.amount amount
268: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
269: WHERE
270: stm.sty_id = sty.id
271: AND ste.stm_id = stm.id
272: AND stm.active_yn = 'Y'

Line 483: FROM okl_strm_type_b sty,

479: --IF l_contracts_csr.deal_type IN ('LEASEOP','LEASEDF','LEASEST') THEN
480: -- Commented for SQL Literals on 12-09-2006
481: /* l_stmt := 'SELECT ste.stream_element_date stream_element_date,
482: ste.amount amount
483: FROM okl_strm_type_b sty,
484: okl_streams stm,
485: okl_strm_elements ste
486: WHERE 1 = 1
487: AND stm.sty_id = sty.id

Line 983: OKL_STRM_TYPE_B stytl

979: khr.deal_type deal_type
980: FROM OKL_POOL_CONTENTS opc,
981: OKL_POOLS op,
982: OKL_K_HEADERS khr,
983: OKL_STRM_TYPE_B stytl
984: WHERE op.khr_id = p_inv_id
985: AND op.id = opc.pol_id
986: AND opc.khr_id = khr.id
987: AND opc.sty_id = stytl.id

Line 999: OKL_STRM_TYPE_B sty

995: IS
996: SELECT opc.kle_id kle_id,
997: MIN(opc.streams_from_date) start_date
998: FROM OKL_POOL_CONTENTS opc,
999: OKL_STRM_TYPE_B sty
1000: WHERE opc.khr_id = p_khr_id
1001: AND opc.sty_id = sty.id
1002: --AND sty.code = 'RENT'
1003: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 1021: OKL_STRM_TYPE_B stytl

1017: khr.deal_type deal_type
1018: FROM OKL_POOL_CONTENTS opc,
1019: OKL_POOLS op,
1020: OKL_K_HEADERS khr,
1021: OKL_STRM_TYPE_B stytl
1022: WHERE op.khr_id = p_inv_id
1023: AND op.id = opc.pol_id
1024: AND opc.khr_id = khr.id
1025: AND opc.sty_id = stytl.id

Line 1037: OKL_STRM_TYPE_B sty

1033: IS
1034: SELECT opc.kle_id kle_id,
1035: MIN(opc.streams_from_date) start_date
1036: FROM OKL_POOL_CONTENTS opc,
1037: OKL_STRM_TYPE_B sty
1038: WHERE opc.khr_id = p_khr_id
1039: AND opc.sty_id = sty.id
1040: --AND sty.code = 'RENT'
1041: AND sty.stream_type_purpose IN ('RENT', 'PRINCIPAL_PAYMENT')

Line 1057: OKL_STRM_TYPE_B STRM

1053: FROM OKC_K_HEADERS_B K,
1054: OKC_RULE_GROUPS_B RG,
1055: OKC_RULES_B SLH,
1056: OKC_RULES_B SLL,
1057: OKL_STRM_TYPE_B STRM
1058: WHERE slh.rule_information_category = 'LASLH'
1059: AND slh.rgp_id = rg.id
1060: AND sll.object2_id1 = to_char(slh.id)
1061: AND sll.rgp_id = rg.id

Line 1075: FROM OKL_STRM_TYPE_B

1071: -- cursor to get stream type id
1072: CURSOR get_sty_id_csr (p_sty_name VARCHAR2)
1073: IS
1074: SELECT id
1075: FROM OKL_STRM_TYPE_B
1076: WHERE code = p_sty_name;
1077:
1078: -- list of all investors for the agreement
1079: CURSOR get_investors_csr(p_khr_id IN NUMBER)

Line 1123: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste

1119: p_end_date DATE,
1120: p_stream_type_purpose VARCHAR2)
1121: IS
1122: select ste.stream_element_date stream_element_date,ste.amount amount
1123: FROM okl_strm_type_b sty, okl_streams stm, okl_strm_elements ste
1124: WHERE
1125: stm.sty_id = sty.id
1126: AND ste.stm_id = stm.id
1127: AND stm.active_yn = 'Y'

Line 1276: FROM OKL_STRM_TYPE_B sty

1272:
1273: -- SQL Literals Change on 12/09/2006
1274: /*l_stmt := 'SELECT ste.stream_element_date stream_element_date
1275: ,ste.amount amount
1276: FROM OKL_STRM_TYPE_B sty
1277: ,OKL_STREAMS stm
1278: ,OKL_STRM_ELEMENTS ste
1279: WHERE 1 = 1
1280: AND stm.sty_id = sty.id

Line 1900: FROM OKL_STRM_TYPE_B sty,

1896: WHERE id = p_khr_id;
1897:
1898: CURSOR non_accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1899: SELECT ste.id
1900: FROM OKL_STRM_TYPE_B sty,
1901: OKL_STREAMS stm,
1902: OKL_STRM_ELEMENTS ste
1903: WHERE stm.khr_id = p_khr_id
1904: AND stm.sty_id = sty.id

Line 1915: FROM OKL_STRM_TYPE_B sty,

1911: AND ste.accrued_yn IS NULL;
1912:
1913: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
1914: SELECT ste.id
1915: FROM OKL_STRM_TYPE_B sty,
1916: OKL_STREAMS stm,
1917: OKL_STRM_ELEMENTS ste
1918: WHERE stm.khr_id = p_khr_id
1919: AND stm.sty_id = sty.id

Line 2141: okl_strm_type_b sty

2137: IS
2138: SELECT
2139: str.sty_id sty_id
2140: FROM okl_streams str,
2141: okl_strm_type_b sty
2142: WHERE str.sty_id = sty.id
2143: AND str.say_code = 'CURR'
2144: AND str.khr_id = chrid
2145: AND str.kle_id = kleid;

Line 2156: okl_strm_type_b sty

2152: str.sty_id sty_id
2153: --FROM okl_streams str,
2154: FROM okl_streams_rep_v str, -- MGAAP 7263041
2155: okl_strm_elements ste,
2156: okl_strm_type_b sty
2157: WHERE ste.stm_id = str.id
2158: AND str.sty_id = sty.id
2159: AND str.say_code = 'CURR'
2160: AND str.khr_id = chrid

Line 2174: okl_strm_type_b sty

2170: str.sty_id sty_id
2171: --FROM okl_streams str,
2172: FROM okl_streams_rep_v str, -- MGAAP 7263041
2173: okl_strm_elements ste,
2174: okl_strm_type_b sty
2175: WHERE ste.stm_id = str.id
2176: AND str.sty_id = sty.id
2177: AND str.say_code = 'CURR'
2178: AND str.khr_id = chrid

Line 2192: okl_strm_type_b sty

2188: sum(ste.amount)
2189: --FROM okl_streams str,
2190: FROM okl_streams_rep_v str, -- MGAAP 7263041
2191: okl_strm_elements ste,
2192: okl_strm_type_b sty
2193: WHERE ste.stm_id = str.id
2194: AND str.sty_id = sty.id
2195: AND str.say_code = 'CURR'
2196: AND str.khr_id = chrid

Line 2208: okl_strm_type_b sty

2204: sum(ste.amount)
2205: --FROM okl_streams str,
2206: FROM okl_streams_rep_v str, -- MGAAP 7263041
2207: okl_strm_elements ste,
2208: okl_strm_type_b sty
2209: WHERE ste.stm_id = str.id
2210: AND str.sty_id = sty.id
2211: AND str.say_code = 'CURR'
2212: AND str.khr_id = chrid

Line 2261: FROM OKL_STRM_TYPE_B sty,

2257:
2258: CURSOR l_pdt_accrual_csr(chrId NUMBER)
2259: IS
2260: SELECT sty.id sty_id
2261: FROM OKL_STRM_TYPE_B sty,
2262: OKL_PROD_STRM_TYPES psty,
2263: OKL_K_HEADERS khr
2264: WHERE khr.id = chrId
2265: --AND khr.pdt_id = psty.pdt_id

Line 2279: sty_id OKL_STRM_TYPE_B.ID%TYPE);

2275: l_pmt_sty_rec l_pmt_sty_csr%ROWTYPE;
2276:
2277:
2278: TYPE p_pdt_accrual_rec_type IS RECORD(
2279: sty_id OKL_STRM_TYPE_B.ID%TYPE);
2280:
2281: TYPE p_pdt_accrual_tbl_type IS TABLE OF p_pdt_accrual_rec_type
2282: INDEX BY BINARY_INTEGER;
2283: