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_CONTRACT_INFO dependencies on OKC_RULES_V

Line 1249: FROM okc_rules_v orv1, okc_rule_groups_b org1

1245:
1246: -- get advanced rent
1247: CURSOR advance_rent_csr IS
1248: SELECT SUM(nvl(orv1.rule_information6,0))
1249: FROM okc_rules_v orv1, okc_rule_groups_b org1
1250: WHERE org1.dnz_chr_id = p_contract_id
1251: AND org1.id = orv1.rgp_id
1252: AND orv1.rule_information_category = 'SLL'
1253: AND EXISTS

Line 1254: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm

1250: WHERE org1.dnz_chr_id = p_contract_id
1251: AND org1.id = orv1.rgp_id
1252: AND orv1.rule_information_category = 'SLL'
1253: AND EXISTS
1254: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm
1255: WHERE okhdr.id = org1.dnz_chr_id AND org1.rgd_code = 'LAEVEL'
1256: AND org1.id = orv.rgp_id AND orv.rule_information_category ='SLH'
1257: AND jtot_object1_code ='OKL_STRMTYP' AND object1_id1 = stm.id1
1258: AND object1_id2 = stm.id2 AND stm.name ='RENT');

Line 1263: FROM okc_rules_v orv1, okc_rule_groups_b org1

1259:
1260: -- get security deposit
1261: CURSOR security_deposit_csr IS
1262: SELECT SUM(nvl(orv1.rule_information6,0))
1263: FROM okc_rules_v orv1, okc_rule_groups_b org1
1264: WHERE org1.dnz_chr_id = p_contract_id
1265: AND org1.id = orv1.rgp_id
1266: AND orv1.rule_information_category = 'SLL'
1267: AND EXISTS

Line 1268: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm

1264: WHERE org1.dnz_chr_id = p_contract_id
1265: AND org1.id = orv1.rgp_id
1266: AND orv1.rule_information_category = 'SLL'
1267: AND EXISTS
1268: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm
1269: WHERE okhdr.id = org1.dnz_chr_id AND org1.rgd_code = 'LAEVEL'
1270: AND org1.id = orv.rgp_id AND orv.rule_information_category ='SLH'
1271: AND jtot_object1_code ='OKL_STRMTYP' AND object1_id1 = stm.id1
1272: AND object1_id2 = stm.id2 AND stm.name ='SECURITY DEPOSIT');

Line 1277: FROM okc_rules_v orv1, okc_rule_groups_b org1

1273:
1274: -- get interest type
1275: CURSOR Interest_type_csr IS
1276: SELECT SUM(nvl(orv1.rule_information6,0))
1277: FROM okc_rules_v orv1, okc_rule_groups_b org1
1278: WHERE org1.dnz_chr_id = p_contract_id
1279: AND org1.id = orv1.rgp_id
1280: AND orv1.rule_information_category = 'SLL'
1281: AND EXISTS

Line 1282: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm

1278: WHERE org1.dnz_chr_id = p_contract_id
1279: AND org1.id = orv1.rgp_id
1280: AND orv1.rule_information_category = 'SLL'
1281: AND EXISTS
1282: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm
1283: WHERE okhdr.id = org1.dnz_chr_id AND org1.rgd_code = 'LAEVEL'
1284: AND org1.id = orv.rgp_id AND orv.rule_information_category ='SLH'
1285: AND jtot_object1_code ='OKL_STRMTYP' AND object1_id1 = stm.id1
1286: AND object1_id2 = stm.id2 AND stm.name ='SECURITY DEPOSIT');