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_STRY_CALL_CO_PUB dependencies on OKC_K_HEADERS_B

Line 184: ,okc_k_headers_b okh

180: CURSOR l_khr_csr(cp_case_number IN VARCHAR2) IS SELECT ico.object_id
181: , okh.contract_number
182: FROM iex_cases_all_b ica
183: ,iex_case_objects ico
184: ,okc_k_headers_b okh
185: WHERE ica.case_number = cp_case_number
186: AND ica.cas_id = ico.cas_id
187: AND ico.object_id = okh.id;
188:

Line 197: FROM okc_k_headers_b prog,

193: ,lease.id contract_id
194: ,rgp.dnz_chr_id
195: ,lease.contract_number contract_number
196: ,rgp.rgd_code
197: FROM okc_k_headers_b prog,
198: okc_k_headers_b lease,
199: okl_k_headers khr,
200: okc_rule_groups_b rgp
201: WHERE khr.id = lease.id

Line 198: okc_k_headers_b lease,

194: ,rgp.dnz_chr_id
195: ,lease.contract_number contract_number
196: ,rgp.rgd_code
197: FROM okc_k_headers_b prog,
198: okc_k_headers_b lease,
199: okl_k_headers khr,
200: okc_rule_groups_b rgp
201: WHERE khr.id = lease.id
202: AND khr.khr_id = prog.id

Line 591: ,okc_k_headers_b okh

587: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
588: , okh.contract_number
589: FROM iex_delinquencies_all ida
590: ,iex_case_objects ico
591: ,okc_k_headers_b okh
592: WHERE ida.delinquency_id = cp_delinquency_id
593: AND ida.case_id = ico.cas_id
594: AND ico.object_id = okh.id;
595:

Line 603: FROM okc_k_headers_b prog,

599: ,lease.id contract_id
600: ,rgp.dnz_chr_id
601: ,lease.contract_number contract_number
602: ,rgp.rgd_code
603: FROM okc_k_headers_b prog,
604: okc_k_headers_b lease,
605: okl_k_headers khr,
606: okc_rule_groups_b rgp
607: WHERE khr.id = lease.id

Line 604: okc_k_headers_b lease,

600: ,rgp.dnz_chr_id
601: ,lease.contract_number contract_number
602: ,rgp.rgd_code
603: FROM okc_k_headers_b prog,
604: okc_k_headers_b lease,
605: okl_k_headers khr,
606: okc_rule_groups_b rgp
607: WHERE khr.id = lease.id
608: AND khr.khr_id = prog.id

Line 707: ,okc_k_headers_b okh

703: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
704: , okh.contract_number
705: FROM iex_delinquencies_all ida
706: ,iex_case_objects ico
707: ,okc_k_headers_b okh
708: WHERE ida.delinquency_id = cp_delinquency_id
709: AND ida.case_id = ico.cas_id
710: AND ico.object_id = okh.id;
711:

Line 719: FROM okc_k_headers_b prog,

715: ,lease.id contract_id
716: ,rgp.dnz_chr_id
717: ,lease.contract_number contract_number
718: ,rgp.rgd_code
719: FROM okc_k_headers_b prog,
720: okc_k_headers_b lease,
721: okl_k_headers khr,
722: okc_rule_groups_b rgp
723: WHERE khr.id = lease.id

Line 720: okc_k_headers_b lease,

716: ,rgp.dnz_chr_id
717: ,lease.contract_number contract_number
718: ,rgp.rgd_code
719: FROM okc_k_headers_b prog,
720: okc_k_headers_b lease,
721: okl_k_headers khr,
722: okc_rule_groups_b rgp
723: WHERE khr.id = lease.id
724: AND khr.khr_id = prog.id

Line 807: FROM okc_k_headers_b

803: l_days_after_ven_approval NUMBER;
804:
805: /* CURSOR l_khr_csr(p_contract_id IN NUMBER)
806: IS SELECT contract_number
807: FROM okc_k_headers_b
808: WHERE id = p_contract_id;
809: */
810:
811: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS

Line 815: ,okc_k_headers_b okh

811: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS
812: SELECT ico.object_id, okh.contract_number
813: FROM iex_delinquencies_all ida
814: ,iex_case_objects ico
815: ,okc_k_headers_b okh
816: WHERE ida.delinquency_id = cp_delinquency_id
817: AND ida.case_id = ico.cas_id
818: AND ico.object_id = okh.id;
819:

Line 827: FROM okc_k_headers_b prog,

823: ,lease.id contract_id
824: ,rgp.dnz_chr_id
825: ,lease.contract_number contract_number
826: ,rgp.rgd_code
827: FROM okc_k_headers_b prog,
828: okc_k_headers_b lease,
829: okl_k_headers khr,
830: okc_rule_groups_b rgp
831: WHERE khr.id = lease.id

Line 828: okc_k_headers_b lease,

824: ,rgp.dnz_chr_id
825: ,lease.contract_number contract_number
826: ,rgp.rgd_code
827: FROM okc_k_headers_b prog,
828: okc_k_headers_b lease,
829: okl_k_headers khr,
830: okc_rule_groups_b rgp
831: WHERE khr.id = lease.id
832: AND khr.khr_id = prog.id

Line 947: ,okc_k_headers_b okh

943: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
944: , okh.contract_number
945: FROM iex_delinquencies_all ida
946: ,iex_case_objects ico
947: ,okc_k_headers_b okh
948: WHERE ida.delinquency_id = cp_delinquency_id
949: AND ida.case_id = ico.cas_id
950: AND ico.object_id = okh.id;
951:

Line 959: FROM okc_k_headers_b prog,

955: ,lease.id contract_id
956: ,rgp.dnz_chr_id
957: ,lease.contract_number contract_number
958: ,rgp.rgd_code
959: FROM okc_k_headers_b prog,
960: okc_k_headers_b lease,
961: okl_k_headers khr,
962: okc_rule_groups_b rgp
963: WHERE khr.id = lease.id

Line 960: okc_k_headers_b lease,

956: ,rgp.dnz_chr_id
957: ,lease.contract_number contract_number
958: ,rgp.rgd_code
959: FROM okc_k_headers_b prog,
960: okc_k_headers_b lease,
961: okl_k_headers khr,
962: okc_rule_groups_b rgp
963: WHERE khr.id = lease.id
964: AND khr.khr_id = prog.id

Line 1044: ,okc_k_headers_b okh

1040: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
1041: , okh.contract_number
1042: FROM iex_delinquencies_all ida
1043: ,iex_case_objects ico
1044: ,okc_k_headers_b okh
1045: WHERE ida.delinquency_id = cp_delinquency_id
1046: AND ida.case_id = ico.cas_id
1047: AND ico.object_id = okh.id;
1048:

Line 1056: FROM okc_k_headers_b prog,

1052: ,lease.id contract_id
1053: ,rgp.dnz_chr_id
1054: ,lease.contract_number contract_number
1055: ,rgp.rgd_code
1056: FROM okc_k_headers_b prog,
1057: okc_k_headers_b lease,
1058: okl_k_headers khr,
1059: okc_rule_groups_b rgp
1060: WHERE khr.id = lease.id

Line 1057: okc_k_headers_b lease,

1053: ,rgp.dnz_chr_id
1054: ,lease.contract_number contract_number
1055: ,rgp.rgd_code
1056: FROM okc_k_headers_b prog,
1057: okc_k_headers_b lease,
1058: okl_k_headers khr,
1059: okc_rule_groups_b rgp
1060: WHERE khr.id = lease.id
1061: AND khr.khr_id = prog.id

Line 1137: ,okc_k_headers_b okh

1133: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
1134: , okh.contract_number
1135: FROM iex_delinquencies_all ida
1136: ,iex_case_objects ico
1137: ,okc_k_headers_b okh
1138: WHERE ida.delinquency_id = cp_delinquency_id
1139: AND ida.case_id = ico.cas_id
1140: AND ico.object_id = okh.id;
1141:

Line 1149: FROM okc_k_headers_b prog,

1145: ,lease.id contract_id
1146: ,rgp.dnz_chr_id
1147: ,lease.contract_number contract_number
1148: ,rgp.rgd_code
1149: FROM okc_k_headers_b prog,
1150: okc_k_headers_b lease,
1151: okl_k_headers khr,
1152: okc_rule_groups_b rgp
1153: WHERE khr.id = lease.id

Line 1150: okc_k_headers_b lease,

1146: ,rgp.dnz_chr_id
1147: ,lease.contract_number contract_number
1148: ,rgp.rgd_code
1149: FROM okc_k_headers_b prog,
1150: okc_k_headers_b lease,
1151: okl_k_headers khr,
1152: okc_rule_groups_b rgp
1153: WHERE khr.id = lease.id
1154: AND khr.khr_id = prog.id

Line 1232: ,okc_k_headers_b okh

1228: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS SELECT ico.object_id
1229: , okh.contract_number
1230: FROM iex_delinquencies_all ida
1231: ,iex_case_objects ico
1232: ,okc_k_headers_b okh
1233: WHERE ida.delinquency_id = cp_delinquency_id
1234: AND ida.case_id = ico.cas_id
1235: AND ico.object_id = okh.id;
1236:

Line 1244: FROM okc_k_headers_b prog,

1240: ,lease.id contract_id
1241: ,rgp.dnz_chr_id
1242: ,lease.contract_number contract_number
1243: ,rgp.rgd_code
1244: FROM okc_k_headers_b prog,
1245: okc_k_headers_b lease,
1246: okl_k_headers khr,
1247: okc_rule_groups_b rgp
1248: WHERE khr.id = lease.id

Line 1245: okc_k_headers_b lease,

1241: ,rgp.dnz_chr_id
1242: ,lease.contract_number contract_number
1243: ,rgp.rgd_code
1244: FROM okc_k_headers_b prog,
1245: okc_k_headers_b lease,
1246: okl_k_headers khr,
1247: okc_rule_groups_b rgp
1248: WHERE khr.id = lease.id
1249: AND khr.khr_id = prog.id

Line 1329: FROM okc_k_headers_b

1325: l_days_after_ven_approval NUMBER;
1326:
1327: /* CURSOR l_khr_csr(p_contract_id IN NUMBER)
1328: IS SELECT contract_number
1329: FROM okc_k_headers_b
1330: WHERE id = p_contract_id;
1331: */
1332:
1333: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS

Line 1337: ,okc_k_headers_b okh

1333: CURSOR l_khr_csr(cp_delinquency_id IN NUMBER) IS
1334: SELECT ico.object_id, okh.contract_number
1335: FROM iex_delinquencies_all ida
1336: ,iex_case_objects ico
1337: ,okc_k_headers_b okh
1338: WHERE ida.delinquency_id = cp_delinquency_id
1339: AND ida.case_id = ico.cas_id
1340: AND ico.object_id = okh.id;
1341:

Line 1349: FROM okc_k_headers_b prog,

1345: ,lease.id contract_id
1346: ,rgp.dnz_chr_id
1347: ,lease.contract_number contract_number
1348: ,rgp.rgd_code
1349: FROM okc_k_headers_b prog,
1350: okc_k_headers_b lease,
1351: okl_k_headers khr,
1352: okc_rule_groups_b rgp
1353: WHERE khr.id = lease.id

Line 1350: okc_k_headers_b lease,

1346: ,rgp.dnz_chr_id
1347: ,lease.contract_number contract_number
1348: ,rgp.rgd_code
1349: FROM okc_k_headers_b prog,
1350: okc_k_headers_b lease,
1351: okl_k_headers khr,
1352: okc_rule_groups_b rgp
1353: WHERE khr.id = lease.id
1354: AND khr.khr_id = prog.id