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_STREAM_GENERATOR_PVT dependencies on OKL_STRM_TYPE_B

Line 58: okl_strm_type_b sty

54: Select distinct nvl(slh.object1_id1, -1) styId
55: From OKC_RULE_GROUPS_B rgp,
56: OKC_RULES_B sll,
57: okc_rules_b slh,
58: okl_strm_type_b sty
59: Where slh.rgp_id = rgp.id
60: and rgp.RGD_CODE = 'LALEVL'
61: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
62: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 787: okl_strm_type_b stm

783: okc_line_styles_b lse,
784: okc_rules_b sll,
785: okc_rules_b slh,
786: okc_rule_groups_b rgp,
787: okl_strm_type_b stm
788: WHERE chr_so.id = p_khr_id
789: and cle.sts_code in( 'COMPLETE', 'INCOMPLETE')--'ENTERED'
790: AND cle.dnz_chr_id = chr_so.id
791: AND cle.id = kle.id

Line 1638: okl_strm_type_b sty,

1634: SELECT sel.amount income_amount,
1635: sel.stream_element_date income_date
1636: FROM okl_strm_elements sel,
1637: okl_streams stm,
1638: okl_strm_type_b sty,
1639: okl_strm_type_tl styt
1640: WHERE stm.khr_id = p_khr_id
1641: AND stm.say_code = 'WORK'
1642: AND stm.id = sel.stm_id

Line 1684: okl_strm_type_b sty

1680: Select distinct nvl(slh.object1_id1, -1) styId
1681: From OKC_RULE_GROUPS_B rgp,
1682: OKC_RULES_B sll,
1683: okc_rules_b slh,
1684: okl_strm_type_b sty
1685: Where slh.rgp_id = rgp.id
1686: and rgp.RGD_CODE = 'LALEVL'
1687: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
1688: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 1888: FROM okl_strm_type_b sty,

1884: x_return_status OUT NOCOPY VARCHAR2) IS
1885:
1886: CURSOR c_sty_name IS
1887: SELECT styt.name
1888: FROM okl_strm_type_b sty,
1889: okl_strm_type_tl styt
1890: WHERE sty.id = p_sty_id
1891: AND sty.version = '1.0' -- not really needed in 1159
1892: AND sty.id = styt.id

Line 1899: FROM okl_strm_type_b sty,

1895: AND NVL(sty.end_date, SYSDATE) >= TRUNC(SYSDATE);
1896:
1897: CURSOR c_sty_id IS
1898: SELECT sty.id
1899: FROM okl_strm_type_b sty,
1900: okl_strm_type_tl styt
1901: WHERE styt.name = p_sty_name
1902: AND styt.language = 'US'
1903: AND styt.id = sty.id

Line 2043: okl_strm_type_b sty

2039: Select distinct nvl(slh.object1_id1, -1) styId
2040: From OKC_RULE_GROUPS_B rgp,
2041: OKC_RULES_B sll,
2042: okc_rules_b slh,
2043: okl_strm_type_b sty
2044: Where slh.rgp_id = rgp.id
2045: and rgp.RGD_CODE = 'LALEVL'
2046: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
2047: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 3711: okl_strm_type_b sty

3707: sty.stream_type_purpose stm_purpose,
3708: ele.amount amount
3709: FROM okl_streams stm,
3710: okl_strm_elements ele,
3711: okl_strm_type_b sty
3712: WHERE stm.khr_id = p_khr_id
3713: AND ele.stm_id = stm.id
3714: AND stm.say_code = 'WORK'
3715: AND NVL(stm.purpose_code, '-99') = p_purpose_code

Line 4031: okl_strm_type_b sty

4027: Select nvl(slh.object1_id1, -1) styId
4028: From OKC_RULE_GROUPS_B rgp,
4029: OKC_RULES_B sll,
4030: okc_rules_b slh,
4031: okl_strm_type_b sty
4032: Where slh.rgp_id = rgp.id
4033: and rgp.RGD_CODE = 'LALEVL'
4034: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
4035: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 4055: okl_strm_type_b sty

4051: okc_rules_b rul2,
4052: okc_k_lines_b cle,
4053: okl_k_lines kle,
4054: okc_line_styles_b lse,
4055: okl_strm_type_b sty
4056: WHERE rul1.rgp_id= rgp.id
4057: ANd rgp.rgd_code = 'LALEVL'
4058: AND rul2.rule_information_category = 'LASLL'
4059: and rul1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 4109: okl_strm_type_b sty,

4105: sll.object1_id1 cf_frequency,
4106: DECODE(sll.object1_id1, 'M', 30, 'Q', 90, 'S', 180, 'A', 360) days_per_period,
4107: DECODE(sll.object1_id1, 'M', 12, 'Q', 4, 'S', 2, 'A', 1) periods_per_year
4108: FROM okl_streams stm,
4109: okl_strm_type_b sty,
4110: okl_strm_elements sel,
4111: okc_k_lines_b cle,
4112: okc_line_styles_b lse,
4113: okc_rules_b sll,

Line 5918: okl_strm_type_b sty

5914: FROM okc_rule_groups_b rgp,
5915: okc_rules_b rul1,
5916: okc_rules_b rul2,
5917: okc_k_lines_b cle,
5918: okl_strm_type_b sty
5919: WHERE rul2.dnz_chr_id = p_khr_id
5920: AND rul2.rule_information_category = 'LASLL'
5921: AND rul2.rgp_id = rgp.id
5922: AND TO_NUMBER(rul2.object2_id1) = rul1.id

Line 6294: , OKL_STRM_TYPE_B STY

6290: , STM.TRANSACTION_NUMBER
6291: , STY.STREAM_TYPE_PURPOSE
6292: FROM OKL_STREAMS STM
6293: , OKL_STRM_ELEMENTS SEL
6294: , OKL_STRM_TYPE_B STY
6295: WHERE SEL.STM_ID = STM.ID
6296: AND STM.KHR_ID = cp_chr_id
6297: AND STM.KLE_ID = cp_cle_id
6298: AND DECODE(STM.PURPOSE_CODE, NULL, '-99', 'REPORT' ) = cp_purpose_code

Line 6371: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS

6367: and ole.lse_id = cle.lse_id
6368: and ole.id=cle.orig_system_id1;
6369:
6370: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
6371: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
6372: SELECT 'Y'
6373: FROM OKL_STRM_TYPE_B sty,
6374: OKL_PROD_STRM_TYPES psty
6375: WHERE sty.id = psty.sty_id

Line 6373: FROM OKL_STRM_TYPE_B sty,

6369:
6370: CURSOR c_chk_accrual_sty_on_pdt(cp_pdt_id OKL_PRODUCTS.ID%TYPE,
6371: cp_sty_id OKL_STRM_TYPE_B.ID%TYPE) IS
6372: SELECT 'Y'
6373: FROM OKL_STRM_TYPE_B sty,
6374: OKL_PROD_STRM_TYPES psty
6375: WHERE sty.id = psty.sty_id
6376: AND psty.pdt_id = cp_pdt_id
6377: AND psty.accrual_yn = 'Y'

Line 6897: okl_strm_type_b sty

6893: sty.stream_type_purpose,
6894: 'RENT_ACCRUAL', 1,
6895: 99 ) sty_priority
6896: FROM okl_streams stm,
6897: okl_strm_type_b sty
6898: WHERE stm.khr_id = p_khr_id
6899: AND stm.say_code = p_say_code
6900: AND NVL(stm.purpose_code, '-99') = p_purpose
6901: AND sty.id = stm.sty_id

Line 7010: okl_strm_type_b sty

7006: ) end_date
7007: FROM okc_rule_groups_b rgp,
7008: okc_rules_b slh,
7009: okc_rules_b sll,
7010: okl_strm_type_b sty
7011: WHERE sll.dnz_chr_id = p_khr_id
7012: AND sll.rule_information_category = 'LASLL'
7013: AND sll.rgp_id = rgp.id
7014: AND TO_NUMBER(sll.object2_id1) = slh.id

Line 7074: ,okl_strm_type_b sty

7070: SELECT TRUNC(sel.stream_element_date) income_date
7071: ,SUM(sel.amount) income_amount
7072: FROM okl_strm_elements sel
7073: ,okl_streams stm
7074: ,okl_strm_type_b sty
7075: ,okl_strm_type_tl styt
7076: WHERE stm.khr_id = p_khr_id
7077: AND stm.say_code = 'WORK'
7078: AND stm.id = sel.stm_id

Line 7111: okl_strm_type_b sty

7107: SELECT DISTINCT NVL(slh.object1_id1, -1) styid
7108: FROM OKC_RULE_GROUPS_B rgp,
7109: OKC_RULES_B sll,
7110: okc_rules_b slh,
7111: okl_strm_type_b sty
7112: WHERE slh.rgp_id = rgp.id
7113: AND rgp.RGD_CODE = 'LALEVL'
7114: AND sll.RULE_INFORMATION_CATEGORY = 'LASLL'
7115: AND slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 8042: okl_strm_type_b sty

8038: okc_rules_b rul2,
8039: okc_k_lines_b cle,
8040: okl_k_lines kle,
8041: okc_line_styles_b lse,
8042: okl_strm_type_b sty
8043: WHERE rul2.dnz_chr_id = p_khr_id
8044: AND rul2.rule_information_category = 'LASLL'
8045: AND rul2.rgp_id = rgp.id
8046: AND TO_NUMBER(rul2.object2_id1) = rul1.id

Line 8084: okl_strm_type_b sty,

8080: 'INCOME_AMORT' fee_line_level_type
8081: FROM okc_k_lines_b cle,
8082: okl_k_lines kle,
8083: okc_line_styles_b lse,
8084: okl_strm_type_b sty,
8085: okc_rule_groups_b rgp,
8086: okc_rules_b rul1
8087: WHERE
8088: rul1.dnz_chr_id = p_khr_id

Line 8125: okl_strm_type_b sty

8121: okc_rules_b rul2,
8122: okc_k_lines_b cle,
8123: okl_k_lines kle,
8124: okc_line_styles_b lse,
8125: okl_strm_type_b sty
8126: WHERE
8127: rul2.dnz_chr_id = p_khr_id
8128: AND rul2.rule_information_category = 'LASLL'
8129: AND rul2.rgp_id = rgp.id

Line 8158: okl_strm_type_b sty

8154: 'ASSET_ACCRUALS' fee_line_level_type
8155: FROM okc_rule_groups_b rgp,
8156: okc_rules_b rul1,
8157: okc_rules_b rul2,
8158: okl_strm_type_b sty
8159: WHERE
8160: rul2.dnz_chr_id = p_khr_id
8161: AND rul2.rule_information_category = 'LASLL'
8162: AND rul2.rgp_id = rgp.id

Line 8207: okl_strm_type_b sty

8203: Select nvl(slh.object1_id1, -1) styId
8204: From OKC_RULE_GROUPS_B rgp,
8205: OKC_RULES_B sll,
8206: okc_rules_b slh,
8207: okl_strm_type_b sty
8208: Where slh.rgp_id = rgp.id
8209: and rgp.RGD_CODE = 'LALEVL'
8210: and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
8211: and slh.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 8379: okl_strm_type_b stm

8375: CURSOR get_rent_sty_id (p_khr_id NUMBER) IS
8376: SELECT slh.object1_id1
8377: FROM okc_rules_b slh,
8378: okc_rule_groups_b rgp,
8379: okl_strm_type_b stm
8380: WHERE rgp.dnz_chr_id = p_khr_id
8381: AND rgp.rgd_code= 'LALEVL'
8382: AND rgp.id = slh.rgp_id
8383: AND slh.rule_information_category = 'LASLH'

Line 13438: okl_strm_type_b sty

13434: SELECT ele.amount,
13435: ele.stream_element_date
13436: FROM okl_streams stm,
13437: okl_strm_elements ele,
13438: okl_strm_type_b sty
13439: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
13440: AND stm.sty_id = sty.id
13441: AND stm.khr_id = p_khr_id
13442: AND stm.kle_id = p_kle_id

Line 13450: okl_strm_type_b sty

13446: AND ele.stream_element_date =
13447: ( SELECT max( ele.stream_element_date)
13448: FROM okl_streams stm,
13449: okl_strm_elements ele,
13450: okl_strm_type_b sty
13451: WHERE sty.stream_type_purpose = 'PRINCIPAL_BALANCE'
13452: AND stm.sty_id = sty.id
13453: AND stm.khr_id = p_khr_id
13454: AND stm.kle_id = p_kle_id

Line 13514: okl_strm_type_b sty

13510: SELECT sty.id
13511: FROM okc_rules_b sll,
13512: okc_rules_b slh,
13513: okc_rule_groups_b rgp,
13514: okl_strm_type_b sty
13515: WHERE rgp.dnz_chr_id = p_khr_id
13516: AND rgp.cle_id = p_kle_id
13517: AND rgp.rgd_code= 'LALEVL'
13518: AND rgp.id = slh.rgp_id

Line 13793: okl_strm_type_b sty

13789: TO_NUMBER(NULL) residual_value
13790: FROM okc_rule_groups_b rgp,
13791: okc_rules_b rul1,
13792: okc_rules_b rul2,
13793: okl_strm_type_b sty
13794: WHERE rul2.dnz_chr_id = khrid
13795: AND rul2.rule_information_category = 'LASLL'
13796: AND rul2.rgp_id = rgp.id
13797: AND rgp.cle_id IS NULL

Line 14312: okl_strm_type_b sty

14308: okc_rules_b rul2,
14309: okc_k_lines_b cle,
14310: okl_k_lines kle,
14311: okc_line_styles_b lse,
14312: okl_strm_type_b sty
14313: WHERE
14314: rul2.dnz_chr_id = p_khr_id
14315: AND rul2.rule_information_category = 'LASLL'
14316: AND rul2.rgp_id = rgp.id

Line 14350: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;

14346: l_pdt_tbl t_pdt_tbl;
14347: l_rep_flag t_pdt_tbl;
14348: -- R12.1.2 end.
14349:
14350: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
14351: l_sty_id okl_strm_type_b.ID%TYPE;
14352: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
14353: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
14354: l_pdt_id okl_products.id%type;

Line 14351: l_sty_id okl_strm_type_b.ID%TYPE;

14347: l_rep_flag t_pdt_tbl;
14348: -- R12.1.2 end.
14349:
14350: l_sty_purpose okl_strm_type_b.STREAM_TYPE_PURPOSE%TYPE;
14351: l_sty_id okl_strm_type_b.ID%TYPE;
14352: l_sty_name OKL_STRM_TYPE_v.name%TYPE;
14353: l_mapped_sty_name OKL_STRM_TYPE_v.name%TYPE;
14354: l_pdt_id okl_products.id%type;
14355: l_currency_code okc_k_headers_all_b.currency_code%type;