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

Line 1102: okl_strm_type_b styb

1098: FROM okc_k_lines_b cleb,
1099: okc_rule_groups_b rgpb,
1100: okc_rules_b rulb,
1101: okc_rules_b rulb2,
1102: okl_strm_type_b styb
1103: WHERE rgpb.chr_id IS NULL
1104: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
1105: AND rgpb.cle_id = cleb.id
1106: AND cleb.dnz_chr_id = p_chr_id

Line 1392: OKL_STRM_TYPE_B stty

1388: crl.RULE_INFORMATION10,
1389: crl.RULE_INFORMATION11
1390: FROM OKC_RULE_GROUPS_B crg,
1391: OKC_RULES_B crl,
1392: OKL_STRM_TYPE_B stty
1393: WHERE stty.id = crl.object1_id1
1394: AND stty.stream_type_purpose IN (
1395: 'RENT', 'PRINCIPAL_PAYMENT', 'VARIABLE_INTEREST_SCHEDULE',
1396: 'LOAN_PAYMENT'

Line 1408: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

1404:
1405: CURSOR l_pmnt_strm_check(
1406: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1407: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1408: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1409: chrId NUMBER) IS
1410: SELECT crg.cle_id,
1411: crl.id,
1412: crl.object1_id1,

Line 1423: OKL_STRM_TYPE_B stty

1419: crl.RULE_INFORMATION10,
1420: crl.RULE_INFORMATION11
1421: FROM OKC_RULE_GROUPS_B crg,
1422: OKC_RULES_B crl,
1423: OKL_STRM_TYPE_B stty
1424: WHERE stty.id = crl.object1_id1
1425: AND stty.stream_type_purpose = pmnt_strm_purpose
1426: AND crl.rgp_id = crg.id
1427: AND crg.RGD_CODE = rgcode

Line 1434: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

1430:
1431: CURSOR l_pmnt_strm_check2(
1432: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1433: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1434: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1435: chrId NUMBER) IS
1436: SELECT crg.cle_id,
1437: crl.id,
1438: crl.object1_id1,

Line 1449: OKL_STRM_TYPE_B stty

1445: crl.RULE_INFORMATION10,
1446: crl.RULE_INFORMATION11
1447: FROM OKC_RULE_GROUPS_B crg,
1448: OKC_RULES_B crl,
1449: OKL_STRM_TYPE_B stty
1450: WHERE stty.id = crl.object1_id1
1451: AND stty.stream_type_purpose = pmnt_strm_purpose
1452: AND crl.rgp_id = crg.id
1453: AND crg.RGD_CODE = rgcode

Line 2476: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

2472: --Bug#3931587
2473: CURSOR l_pmnt_strm_check(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
2474: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
2475: --pmnt_strm_name OKL_STRMTYP_SOURCE_V.NAME%TYPE,
2476: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
2477: chrId NUMBER) IS
2478: SELECT crg.cle_id,
2479: crl.id,
2480: crl.object1_id1,

Line 2491: OKL_STRM_TYPE_B stty

2487: crl.RULE_INFORMATION10,
2488: crl.RULE_INFORMATION11
2489: FROM OKC_RULE_GROUPS_B crg,
2490: OKC_RULES_B crl,
2491: OKL_STRM_TYPE_B stty
2492: WHERE stty.id = crl.object1_id1
2493: --and stty.code = pmnt_strm_name
2494: AND stty.stream_type_purpose = pmnt_strm_purpose
2495: AND crl.rgp_id = crg.id

Line 3867: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

3863: AND crg.cle_id = cleId;
3864:
3865: CURSOR l_strm_asset_csr(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
3866: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
3867: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
3868: chrId NUMBER,
3869: cleId NUMBER) IS
3870: SELECT crl.id,
3871: crl.object1_id1

Line 3874: OKL_STRM_TYPE_B stty

3870: SELECT crl.id,
3871: crl.object1_id1
3872: FROM OKC_RULE_GROUPS_B crg,
3873: OKC_RULES_B crl,
3874: OKL_STRM_TYPE_B stty
3875: WHERE stty.id = TO_NUMBER(crl.object1_id1)
3876: AND stty.stream_type_purpose = pmnt_strm_purpose
3877: AND crl.rgp_id = crg.id
3878: AND crg.RGD_CODE = rgcode

Line 3887: okl_strm_type_b stty

3883: CURSOR est_head_csr (p_chr_id NUMBER) IS
3884: SELECT 'Y'
3885: FROM okc_rule_groups_b rgp,
3886: okc_rules_b rule,
3887: okl_strm_type_b stty
3888: WHERE rgp.id = rule.rgp_id
3889: AND stty.id = TO_NUMBER(rule.object1_id1)
3890: AND rgp.rgd_code = 'LALEVL'
3891: AND rule.rule_information_category = 'LASLH'

Line 4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )

4765: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4766: SELECT sll.rule_information2 start_date,
4767: SLL.rule_information3 periods,
4768: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
4769: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
4770: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
4771: --styt.name stream_type
4772: FROM okc_rules_b sll,
4773: okc_rules_b slh,

Line 4775: --okl_strm_type_b sty,

4771: --styt.name stream_type
4772: FROM okc_rules_b sll,
4773: okc_rules_b slh,
4774: okc_rule_groups_b rgp
4775: --okl_strm_type_b sty,
4776: --okl_strm_type_tl styt
4777: WHERE rgp.dnz_chr_id = p_khr_id
4778: AND rgp.cle_id = p_kle_id
4779: AND rgp.rgd_code = 'LALEVL'

Line 4800: okl_strm_type_b sty,

4796: styt.name stream_type
4797: FROM okc_rules_b sll,
4798: okc_rules_b slh,
4799: okc_rule_groups_b rgp,
4800: okl_strm_type_b sty,
4801: okl_strm_type_tl styt
4802: WHERE rgp.dnz_chr_id = p_khr_id
4803: AND rgp.cle_id = p_kle_id
4804: AND rgp.rgd_code = 'LALEVL'

Line 4819: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT

4815:
4816: --Bug#3877032
4817: CURSOR c_strm_slh_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
4818: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
4819: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT
4820: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
4821: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
4822: rule.id rule_id,
4823: rgp.id rgp_id

Line 4826: --okl_strm_type_b sty, Bug 4929573

4822: rule.id rule_id,
4823: rgp.id rgp_id
4824: FROM okc_rules_b rule,
4825: okc_rule_groups_b rgp
4826: --okl_strm_type_b sty, Bug 4929573
4827: --okl_strm_type_tl styt
4828: WHERE rgp.cle_id = p_kle_id
4829: AND rgp.dnz_chr_id = p_khr_id
4830: AND rgp.rgd_code = 'LALEVL'

Line 4876: okl_strm_type_b sty,

4872: SELECT COUNT(sll.id)
4873: FROM okc_rules_b sll,
4874: okc_rules_b slh,
4875: okc_rule_groups_b rgp,
4876: okl_strm_type_b sty,
4877: okl_strm_type_tl styt
4878: WHERE rgp.dnz_chr_id = p_khr_id
4879: AND rgp.cle_id = p_kle_id
4880: AND rgp.rgd_code = 'LALEVL'

Line 5837: okl_strm_type_b sty,

5833: styt.name stream_type
5834: FROM okc_rules_b sll,
5835: okc_rules_b slh,
5836: okc_rule_groups_b rgp,
5837: okl_strm_type_b sty,
5838: okl_strm_type_tl styt
5839: WHERE rgp.dnz_chr_id = chrID
5840: AND rgp.cle_id = feeLine
5841: AND rgp.rgd_code = 'LALEVL'

Line 5860: okl_strm_type_b sty,

5856:
5857: SELECT slh.id
5858: FROM okc_rules_b slh,
5859: okc_rule_groups_b rgp,
5860: okl_strm_type_b sty,
5861: okl_strm_type_tl styt
5862: WHERE rgp.dnz_chr_id = chrID
5863: AND rgp.cle_id = feeLine
5864: AND rgp.rgd_code = 'LALEVL'

Line 6280: okl_strm_type_b sty,

6276: styt.name stream_type
6277: FROM okc_rules_b sll,
6278: okc_rules_b slh,
6279: okc_rule_groups_b rgp,
6280: okl_strm_type_b sty,
6281: okl_strm_type_tl styt
6282: WHERE rgp.dnz_chr_id = chrID
6283: AND rgp.cle_id = feeLine
6284: AND rgp.rgd_code = 'LALEVL'

Line 6303: okl_strm_type_b sty,

6299:
6300: SELECT slh.id
6301: FROM okc_rules_b slh,
6302: okc_rule_groups_b rgp,
6303: okl_strm_type_b sty,
6304: okl_strm_type_tl styt
6305: WHERE rgp.dnz_chr_id = chrID
6306: AND rgp.cle_id = feeLine
6307: AND rgp.rgd_code = 'LALEVL'

Line 6987: OKL_STRM_TYPE_B stty

6983: SELECT rgp.id,rgp.cle_id
6984: FROM OKC_RULE_GROUPS_B rgp,
6985: OKC_RULES_B crl2,
6986: okc_k_lines_b cleb,
6987: OKL_STRM_TYPE_B stty
6988: WHERE stty.id = crl2.object1_id1
6989: AND stty.stream_type_purpose = 'RENT'
6990: AND rgp.id = crl2.rgp_id
6991: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 7416: OKL_STRM_TYPE_B stty

7412: crl.object1_id1,
7413: crl.RULE_INFORMATION6
7414: FROM OKC_RULE_GROUPS_B crg,
7415: OKC_RULES_B crl,
7416: OKL_STRM_TYPE_B stty
7417: WHERE stty.id = crl.object1_id1
7418: AND stty.stream_type_purpose = 'DOWN_PAYMENT'
7419: AND crl.rgp_id = crg.id
7420: AND crg.RGD_CODE = 'LALEVL'

Line 10774: okl_strm_type_b strm

10770: FROM okc_rules_b rule,
10771: okc_rule_groups_b rgp,
10772: okc_k_lines_b line,
10773: okc_line_styles_b style,
10774: okl_strm_type_b strm
10775: WHERE rgp.dnz_chr_id = p_chr_id
10776: AND rgp.cle_id IS NOT NULL
10777: AND rgp.cle_id = line.id
10778: AND line.lse_id = style.id

Line 11836: okl_strm_type_b sty,

11832: rule.id rule_id,
11833: rgp.id rgp_id
11834: FROM okc_rules_b rule,
11835: okc_rule_groups_b rgp,
11836: okl_strm_type_b sty,
11837: okl_strm_type_tl styt
11838: WHERE NVL(rgp.cle_id, -1) = p_kle_id
11839: AND rgp.dnz_chr_id = p_khr_id
11840: AND rgp.rgd_code = 'LALEVL'