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_SETUP_UTIL_PUB dependencies on OKC_CLASS_OPERATIONS

Line 4676: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c

4672: x_msg_data OUT NOCOPY VARCHAR2) IS
4673:
4674: CURSOR cur_has_lines_been_renewed_h IS -- header
4675: SELECT 1
4676: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c
4677: where a.object_chr_id= p_chr_id and
4678: c.id=b.cop_id and
4679: c.opn_code in('RENEWAL', 'REN_CON') and
4680: a.oie_id=b.id and

Line 4688: okc_class_operations c,

4684: CURSOR cur_has_lines_been_renewed_l IS -- topline
4685: SELECT subject_cle_id
4686: FROM okc_operation_lines a,
4687: okc_operation_instances b,
4688: okc_class_operations c,
4689: okc_k_lines_b d
4690: where a.object_cle_id = d.id and
4691: d.cle_id = p_cle_id and -- should be a top line id
4692: a.object_chr_id = p_chr_id and

Line 4702: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c

4698:
4699:
4700: CURSOR cur_has_lines_been_renewed_s IS -- Subline
4701: SELECT subject_chr_id
4702: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c
4703: where a.object_cle_id= p_cle_id and -- subline id
4704: c.id=b.cop_id and
4705: c.opn_code in('RENEWAL', 'REN_CON') and
4706: a.oie_id=b.id and