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_OPERATION_INSTANCES

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

4663: x_msg_data OUT NOCOPY VARCHAR2) IS
4664:
4665: CURSOR cur_has_lines_been_renewed_h IS -- header
4666: SELECT 1
4667: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c
4668: where a.object_chr_id= p_chr_id and
4669: c.id=b.cop_id and
4670: c.opn_code in('RENEWAL', 'REN_CON') and
4671: a.oie_id=b.id and

Line 4678: okc_operation_instances b,

4674:
4675: CURSOR cur_has_lines_been_renewed_l IS -- topline
4676: SELECT subject_cle_id
4677: FROM okc_operation_lines a,
4678: okc_operation_instances b,
4679: okc_class_operations c,
4680: okc_k_lines_b d
4681: where a.object_cle_id = d.id and
4682: d.cle_id = p_cle_id and -- should be a top line id

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

4689:
4690:
4691: CURSOR cur_has_lines_been_renewed_s IS -- Subline
4692: SELECT subject_chr_id
4693: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c
4694: where a.object_cle_id= p_cle_id and -- subline id
4695: c.id=b.cop_id and
4696: c.opn_code in('RENEWAL', 'REN_CON') and
4697: a.oie_id=b.id and