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.OKS_CHANGE_STATUS_PVT dependencies on OKC_K_LINES_V

Line 1250: from okc_k_lines_v L, okc_statuses_v ls

1246: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_new_sts_code,l_signed)
1247: ,l_expired)
1248: ,p_new_sts_code) code, L.lse_id,
1249: L.object_version_number
1250: from okc_k_lines_v L, okc_statuses_v ls
1251: where L.dnz_chr_id = p_id
1252: and ls.code = L.sts_code
1253: and ls.ste_code in (l_old_type,'SIGNED')
1254: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE

Line 1264: from okc_k_lines_v L, okc_statuses_v ls

1260: decode(sign(months_between(L.start_date-1,sysdate)),-1,p_new_sts_code,l_signed)
1261: ,l_expired)
1262: ,p_new_sts_code) code, L.lse_id,
1263: L.object_version_number
1264: from okc_k_lines_v L, okc_statuses_v ls
1265: where L.dnz_chr_id = p_id
1266: and ls.code = L.sts_code
1267: and ls.ste_code in (l_type,l_old_type)
1268: and NVL(L.term_cancel_source,'MANUAL') NOT IN ('IBTRANSFER', 'IBRETURN', 'IBTERMINATE', 'IBREPLACE'); --To ignore lines/sublines due to IBTRANSFER, IBRETURN, IBTERMINATE, IBREPLACE