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_MASSCHANGE_PVT dependencies on OKC_OPERATION_INSTANCES_V

Line 66: FROM okc_operation_instances_v oie,

62: AND okh.datetime_cancelled IS NULL -- Added as part of LLC
63: AND okh.date_terminated is NULL
64: AND okh.id not in(
65: SELECT ole.subject_chr_id
66: FROM okc_operation_instances_v oie,
67: okc_operation_lines_v ole,
68: okc_class_operations_v oco
69: WHERE oie.id = ole.oie_id
70: AND oie.id = :p_ctr_rec_oie_id

Line 106: FROM okc_operation_instances_v oie,

102: l_where:=' WHERE okh.scs_code in (''SERVICE'',''SUBSCRIPTION'',''WARRANTY'')
103: AND okh.datetime_cancelled IS NULL -- Added as part of LLC
104: AND okh.date_terminated is NULL
105: AND okh.id not in ( SELECT ole.subject_chr_id
106: FROM okc_operation_instances_v oie,
107: okc_operation_lines_v ole,
108: okc_class_operations_v oco
109: WHERE oie.id = ole.oie_id
110: AND oie.id = :p_ctr_rec_oie_id

Line 6765: FROM okc_operation_instances_v oie,

6761: p_check_yn IN VARCHAR2 ) IS
6762:
6763: CURSOR get_oie_name IS
6764: SELECT name, usr.user_name
6765: FROM okc_operation_instances_v oie,
6766: fnd_user usr
6767: WHERE id = p_oie_id
6768: AND oie.last_updated_by = usr.user_id;
6769: l_errbuf VARCHAR2(200);

Line 6921: FROM okc_operation_instances_v oie,

6917: oie.object1_id1 update_level_value,
6918: omr.ATTRIBUTE_NAME attribute,
6919: omr.OLD_VALUE old_value,
6920: omr.NEW_VALUE new_value
6921: FROM okc_operation_instances_v oie,
6922: okc_masschange_req_dtls omr
6923: WHERE oie.id = omr.oie_id
6924: AND oie.id = p_oie_id;
6925: