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.OKC_TERMINATE_PVT dependencies on OKX_INCIDENT_STATUSES_V

Line 319: FROM okx_incident_statuses_v xis,

315: --SR check done in OKS_BILL_REC_PUB
316: /*
317: CURSOR cur_service_requests is
318: SELECT 'x'
319: FROM okx_incident_statuses_v xis,
320: okc_k_lines_b cle
321: WHERE cle.id = xis.contract_service_id
322: and cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
323: and xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests

Line 1157: FROM okx_incident_statuses_v xis,

1153: FROM okc_statuses_v sts
1154: WHERE sts.code = p_code;
1155: CURSOR cur_service_requests is
1156: SELECT 'x'
1157: FROM okx_incident_statuses_v xis,
1158: okc_k_lines_b cle
1159: WHERE cle.id = xis.contract_service_id
1160: --san below cle.id condition added as we just want to check SRs againt this line only.
1161: and cle.id=p_terminate_in_parameters_rec.p_cle_id --bug 1325866