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 1082: okl_strm_type_b styb

1078: FROM okc_k_lines_b cleb,
1079: okc_rule_groups_b rgpb,
1080: okc_rules_b rulb,
1081: okc_rules_b rulb2,
1082: okl_strm_type_b styb
1083: WHERE rgpb.chr_id IS NULL
1084: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
1085: AND rgpb.cle_id = cleb.id
1086: AND cleb.dnz_chr_id = p_chr_id

Line 1398: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

1394:
1395: CURSOR l_pmnt_strm_check(
1396: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1397: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1398: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1399: chrId NUMBER) IS
1400: SELECT crg.cle_id,
1401: crl.id,
1402: crl.object1_id1,

Line 1413: OKL_STRM_TYPE_B stty

1409: crl.RULE_INFORMATION10,
1410: crl.RULE_INFORMATION11
1411: FROM OKC_RULE_GROUPS_B crg,
1412: OKC_RULES_B crl,
1413: OKL_STRM_TYPE_B stty
1414: WHERE stty.id = crl.object1_id1
1415: AND stty.stream_type_purpose = pmnt_strm_purpose
1416: AND crl.rgp_id = crg.id
1417: AND crg.RGD_CODE = rgcode

Line 1424: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

1420:
1421: CURSOR l_pmnt_strm_check2(
1422: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1423: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1424: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
1425: chrId NUMBER) IS
1426: SELECT crg.cle_id,
1427: crl.id,
1428: crl.object1_id1,

Line 1439: OKL_STRM_TYPE_B stty

1435: crl.RULE_INFORMATION10,
1436: crl.RULE_INFORMATION11
1437: FROM OKC_RULE_GROUPS_B crg,
1438: OKC_RULES_B crl,
1439: OKL_STRM_TYPE_B stty
1440: WHERE stty.id = crl.object1_id1
1441: AND stty.stream_type_purpose = pmnt_strm_purpose
1442: AND crl.rgp_id = crg.id
1443: AND crg.RGD_CODE = rgcode

Line 2633: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

2629: --Bug#3931587
2630: CURSOR l_pmnt_strm_check(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
2631: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
2632: --pmnt_strm_name OKL_STRMTYP_SOURCE_V.NAME%TYPE,
2633: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
2634: chrId NUMBER) IS
2635: SELECT crg.cle_id,
2636: crl.id,
2637: crl.object1_id1,

Line 2648: OKL_STRM_TYPE_B stty

2644: crl.RULE_INFORMATION10,
2645: crl.RULE_INFORMATION11
2646: FROM OKC_RULE_GROUPS_B crg,
2647: OKC_RULES_B crl,
2648: OKL_STRM_TYPE_B stty
2649: WHERE stty.id = crl.object1_id1
2650: --and stty.code = pmnt_strm_name
2651: AND stty.stream_type_purpose = pmnt_strm_purpose
2652: AND crl.rgp_id = crg.id

Line 4189: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,

4185: AND crg.cle_id = cleId;
4186:
4187: CURSOR l_strm_asset_csr(rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
4188: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
4189: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
4190: chrId NUMBER,
4191: cleId NUMBER) IS
4192: SELECT crl.id,
4193: crl.object1_id1

Line 4196: OKL_STRM_TYPE_B stty

4192: SELECT crl.id,
4193: crl.object1_id1
4194: FROM OKC_RULE_GROUPS_B crg,
4195: OKC_RULES_B crl,
4196: OKL_STRM_TYPE_B stty
4197: WHERE stty.id = TO_NUMBER(crl.object1_id1)
4198: AND stty.stream_type_purpose = pmnt_strm_purpose
4199: AND crl.rgp_id = crg.id
4200: AND crg.RGD_CODE = rgcode

Line 4209: okl_strm_type_b stty

4205: CURSOR est_head_csr (p_chr_id NUMBER) IS
4206: SELECT 'Y'
4207: FROM okc_rule_groups_b rgp,
4208: okc_rules_b rule,
4209: okl_strm_type_b stty
4210: WHERE rgp.id = rule.rgp_id
4211: AND stty.id = TO_NUMBER(rule.object1_id1)
4212: AND rgp.rgd_code = 'LALEVL'
4213: AND rule.rule_information_category = 'LASLH'

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

5152: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5153: SELECT sll.rule_information2 start_date,
5154: SLL.rule_information3 periods,
5155: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
5156: ( select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5157: AND to_number(SLH.OBJECT1_ID1) = STY.ID ) STREAM_TYPE
5158: --styt.name stream_type
5159: FROM okc_rules_b sll,
5160: okc_rules_b slh,

Line 5162: --okl_strm_type_b sty,

5158: --styt.name stream_type
5159: FROM okc_rules_b sll,
5160: okc_rules_b slh,
5161: okc_rule_groups_b rgp
5162: --okl_strm_type_b sty,
5163: --okl_strm_type_tl styt
5164: WHERE rgp.dnz_chr_id = p_khr_id
5165: AND rgp.cle_id = p_kle_id
5166: AND rgp.rgd_code = 'LALEVL'

Line 5187: okl_strm_type_b sty,

5183: styt.name stream_type
5184: FROM okc_rules_b sll,
5185: okc_rules_b slh,
5186: okc_rule_groups_b rgp,
5187: okl_strm_type_b sty,
5188: okl_strm_type_tl styt
5189: WHERE rgp.dnz_chr_id = p_khr_id
5190: AND rgp.cle_id = p_kle_id
5191: AND rgp.rgd_code = 'LALEVL'

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

5202:
5203: --Bug#3877032
5204: CURSOR c_strm_slh_ext (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
5205: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
5206: SELECT (select STYT.NAME from OKL_STRM_TYPE_B STY ,OKL_STRM_TYPE_TL STYT
5207: where STY.ID = STYT.ID AND STYT.LANGUAGE = USERENV ( 'LANG' )
5208: AND to_number(RULE.OBJECT1_ID1) = STY.ID ) STREAM_TYPE,
5209: rule.id rule_id,
5210: rgp.id rgp_id

Line 5213: --okl_strm_type_b sty, Bug 4929573

5209: rule.id rule_id,
5210: rgp.id rgp_id
5211: FROM okc_rules_b rule,
5212: okc_rule_groups_b rgp
5213: --okl_strm_type_b sty, Bug 4929573
5214: --okl_strm_type_tl styt
5215: WHERE rgp.cle_id = p_kle_id
5216: AND rgp.dnz_chr_id = p_khr_id
5217: AND rgp.rgd_code = 'LALEVL'

Line 5263: okl_strm_type_b sty,

5259: SELECT COUNT(sll.id)
5260: FROM okc_rules_b sll,
5261: okc_rules_b slh,
5262: okc_rule_groups_b rgp,
5263: okl_strm_type_b sty,
5264: okl_strm_type_tl styt
5265: WHERE rgp.dnz_chr_id = p_khr_id
5266: AND rgp.cle_id = p_kle_id
5267: AND rgp.rgd_code = 'LALEVL'

Line 6224: okl_strm_type_b sty,

6220: styt.name stream_type
6221: FROM okc_rules_b sll,
6222: okc_rules_b slh,
6223: okc_rule_groups_b rgp,
6224: okl_strm_type_b sty,
6225: okl_strm_type_tl styt
6226: WHERE rgp.dnz_chr_id = chrID
6227: AND rgp.cle_id = feeLine
6228: AND rgp.rgd_code = 'LALEVL'

Line 6247: okl_strm_type_b sty,

6243:
6244: SELECT slh.id
6245: FROM okc_rules_b slh,
6246: okc_rule_groups_b rgp,
6247: okl_strm_type_b sty,
6248: okl_strm_type_tl styt
6249: WHERE rgp.dnz_chr_id = chrID
6250: AND rgp.cle_id = feeLine
6251: AND rgp.rgd_code = 'LALEVL'

Line 6667: okl_strm_type_b sty,

6663: styt.name stream_type
6664: FROM okc_rules_b sll,
6665: okc_rules_b slh,
6666: okc_rule_groups_b rgp,
6667: okl_strm_type_b sty,
6668: okl_strm_type_tl styt
6669: WHERE rgp.dnz_chr_id = chrID
6670: AND rgp.cle_id = feeLine
6671: AND rgp.rgd_code = 'LALEVL'

Line 6690: okl_strm_type_b sty,

6686:
6687: SELECT slh.id
6688: FROM okc_rules_b slh,
6689: okc_rule_groups_b rgp,
6690: okl_strm_type_b sty,
6691: okl_strm_type_tl styt
6692: WHERE rgp.dnz_chr_id = chrID
6693: AND rgp.cle_id = feeLine
6694: AND rgp.rgd_code = 'LALEVL'

Line 7374: OKL_STRM_TYPE_B stty

7370: SELECT rgp.id,rgp.cle_id
7371: FROM OKC_RULE_GROUPS_B rgp,
7372: OKC_RULES_B crl2,
7373: okc_k_lines_b cleb,
7374: OKL_STRM_TYPE_B stty
7375: WHERE stty.id = crl2.object1_id1
7376: AND stty.stream_type_purpose = 'RENT'
7377: AND rgp.id = crl2.rgp_id
7378: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 7810: OKL_STRM_TYPE_B stty

7806: crl.object1_id1,
7807: crl.RULE_INFORMATION6
7808: FROM OKC_RULE_GROUPS_B crg,
7809: OKC_RULES_B crl,
7810: OKL_STRM_TYPE_B stty
7811: WHERE stty.id = crl.object1_id1
7812: AND stty.stream_type_purpose = 'DOWN_PAYMENT'
7813: AND crl.rgp_id = crg.id
7814: AND crg.RGD_CODE = 'LALEVL'

Line 11197: okl_strm_type_b strm

11193: FROM okc_rules_b rule,
11194: okc_rule_groups_b rgp,
11195: okc_k_lines_b line,
11196: okc_line_styles_b style,
11197: okl_strm_type_b strm
11198: WHERE rgp.dnz_chr_id = p_chr_id
11199: AND rgp.cle_id IS NOT NULL
11200: AND rgp.cle_id = line.id
11201: AND line.lse_id = style.id

Line 12259: okl_strm_type_b sty,

12255: rule.id rule_id,
12256: rgp.id rgp_id
12257: FROM okc_rules_b rule,
12258: okc_rule_groups_b rgp,
12259: okl_strm_type_b sty,
12260: okl_strm_type_tl styt
12261: WHERE NVL(rgp.cle_id, -1) = p_kle_id
12262: AND rgp.dnz_chr_id = p_khr_id
12263: AND rgp.rgd_code = 'LALEVL'