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_CLASS_OPERATIONS

Line 68: okc_class_operations_v oco

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
71: AND oie.cop_id = oco.id AND opn_code = ''MASS_CHANGE'')
72: AND oas.sts_code = okh.sts_code

Line 108: okc_class_operations_v oco

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
111: AND oie.cop_id = oco.id AND opn_code = ''MASS_CHANGE'')
112: AND oas.sts_code = okh.sts_code

Line 257: ,okc_class_operations co

253: AND not exists(
254: select ol.object_chr_id
255: from okc_operation_lines ol
256: ,okc_operation_instances oi
257: ,okc_class_operations co
258: WHERE ol.object_chr_id = okh.id
259: AND ol.process_flag = ''P''
260: AND ol.ACTIVE_YN = ''Y''
261: AND oi.id = ol.oie_id

Line 275: ,okc_class_operations co

271: ' AND not exists(
272: select ol.object_chr_id
273: from okc_operation_lines ol
274: ,okc_operation_instances oi
275: ,okc_class_operations co
276: WHERE ol.object_chr_id = okh.id
277: AND ol.process_flag = ''P''
278: AND ol.ACTIVE_YN = ''Y''
279: AND oi.id = ol.oie_id

Line 299: ,okc_class_operations co

295: AND not exists(
296: select ol.object_chr_id
297: from okc_operation_lines ol
298: ,okc_operation_instances oi
299: ,okc_class_operations co
300: WHERE ol.object_chr_id = okh.id
301: AND ol.process_flag = ''P''
302: AND ol.ACTIVE_YN = ''Y''
303: AND oi.id = ol.oie_id

Line 322: ,okc_class_operations co

318: AND not exists(
319: select ol.object_chr_id
320: from okc_operation_lines ol
321: ,okc_operation_instances oi
322: ,okc_class_operations co
323: WHERE ol.object_chr_id = okh.id
324: AND ol.process_flag = ''P''
325: AND ol.ACTIVE_YN = ''Y''
326: AND oi.id = ol.oie_id

Line 1393: ,okc_class_operations co

1389: AND not exists(
1390: select ol.object_chr_id
1391: from okc_operation_lines ol
1392: ,okc_operation_instances oi
1393: ,okc_class_operations co
1394: WHERE ol.object_chr_id = okh.id
1395: AND ol.process_flag = ''P''
1396: AND ol.ACTIVE_YN = ''Y''
1397: AND oi.id = ol.oie_id

Line 1412: ,okc_class_operations co

1408: ' AND not exists(
1409: select ol.object_chr_id
1410: from okc_operation_lines ol
1411: ,okc_operation_instances oi
1412: ,okc_class_operations co
1413: WHERE ol.object_chr_id = okh.id
1414: AND ol.process_flag = ''P''
1415: AND ol.ACTIVE_YN = ''Y''
1416: AND oi.id = ol.oie_id

Line 1438: ,okc_class_operations co

1434: AND not exists(
1435: select ol.object_chr_id
1436: from okc_operation_lines ol
1437: ,okc_operation_instances oi
1438: ,okc_class_operations co
1439: WHERE ol.object_chr_id = okh.id
1440: AND ol.process_flag = ''P''
1441: AND ol.ACTIVE_YN = ''Y''
1442: AND oi.id = ol.oie_id

Line 1462: ,okc_class_operations co

1458: AND not exists(
1459: select ol.object_chr_id
1460: from okc_operation_lines ol
1461: ,okc_operation_instances oi
1462: ,okc_class_operations co
1463: WHERE ol.object_chr_id = okh.id
1464: AND ol.process_flag = ''P''
1465: AND ol.ACTIVE_YN = ''Y''
1466: AND oi.id = ol.oie_id

Line 2500: ,okc_class_operations co

2496: AND not exists(
2497: select ol.object_chr_id
2498: from okc_operation_lines ol
2499: ,okc_operation_instances oi
2500: ,okc_class_operations co
2501: WHERE ol.object_chr_id = okh.id
2502: AND ol.process_flag = ''P''
2503: AND ol.ACTIVE_YN = ''Y''
2504: AND oi.id = ol.oie_id

Line 2522: ,okc_class_operations co

2518: AND not exists(
2519: select ol.object_chr_id
2520: from okc_operation_lines ol
2521: ,okc_operation_instances oi
2522: ,okc_class_operations co
2523: WHERE ol.object_chr_id = okh.id
2524: AND ol.process_flag = ''P''
2525: AND ol.ACTIVE_YN = ''Y''
2526: AND oi.id = ol.oie_id

Line 2547: ,okc_class_operations co

2543: AND not exists(
2544: select ol.object_chr_id
2545: from okc_operation_lines ol
2546: ,okc_operation_instances oi
2547: ,okc_class_operations co
2548: WHERE ol.object_chr_id = okh.id
2549: AND ol.process_flag = ''P''
2550: AND ol.ACTIVE_YN = ''Y''
2551: AND oi.id = ol.oie_id

Line 2573: ,okc_class_operations co

2569: AND not exists(
2570: select ol.object_chr_id
2571: from okc_operation_lines ol
2572: ,okc_operation_instances oi
2573: ,okc_class_operations co
2574: WHERE ol.object_chr_id = okh.id
2575: AND ol.process_flag = ''P''
2576: AND ol.ACTIVE_YN = ''Y''
2577: AND oi.id = ol.oie_id

Line 3832: ,okc_class_operations co

3828: AND not exists(
3829: select ol.object_chr_id
3830: from okc_operation_lines ol
3831: ,okc_operation_instances oi
3832: ,okc_class_operations co
3833: WHERE ol.object_chr_id = okh.id
3834: AND ol.process_flag = ''P''
3835: AND ol.ACTIVE_YN = ''Y''
3836: AND oi.id = ol.oie_id

Line 3851: ,okc_class_operations co

3847: ' AND not exists(
3848: select ol.object_chr_id
3849: from okc_operation_lines ol
3850: ,okc_operation_instances oi
3851: ,okc_class_operations co
3852: WHERE ol.object_chr_id = okh.id
3853: AND ol.process_flag = ''P''
3854: AND ol.ACTIVE_YN = ''Y''
3855: AND oi.id = ol.oie_id

Line 3876: ,okc_class_operations co

3872: AND not exists(
3873: select ol.object_chr_id
3874: from okc_operation_lines ol
3875: ,okc_operation_instances oi
3876: ,okc_class_operations co
3877: WHERE ol.object_chr_id = okh.id
3878: AND ol.process_flag = ''P''
3879: AND ol.ACTIVE_YN = ''Y''
3880: AND oi.id = ol.oie_id

Line 3900: ,okc_class_operations co

3896: AND not exists(
3897: select ol.object_chr_id
3898: from okc_operation_lines ol
3899: ,okc_operation_instances oi
3900: ,okc_class_operations co
3901: WHERE ol.object_chr_id = okh.id
3902: AND ol.process_flag = ''P''
3903: AND ol.ACTIVE_YN = ''Y''
3904: AND oi.id = ol.oie_id

Line 4964: ,okc_class_operations co

4960: AND not exists(
4961: select ol.object_chr_id
4962: from okc_operation_lines ol
4963: ,okc_operation_instances oi
4964: ,okc_class_operations co
4965: WHERE ol.object_chr_id = okh.id
4966: AND ol.process_flag = ''P''
4967: AND ol.ACTIVE_YN = ''Y''
4968: AND oi.id = ol.oie_id

Line 4986: ,okc_class_operations co

4982: ' AND not exists(
4983: select ol.object_chr_id
4984: from okc_operation_lines ol
4985: ,okc_operation_instances oi
4986: ,okc_class_operations co
4987: WHERE ol.object_chr_id = okh.id
4988: AND ol.process_flag = ''P''
4989: AND ol.ACTIVE_YN = ''Y''
4990: AND oi.id = ol.oie_id

Line 5014: ,okc_class_operations co

5010: AND not exists(
5011: select ol.object_chr_id
5012: from okc_operation_lines ol
5013: ,okc_operation_instances oi
5014: ,okc_class_operations co
5015: WHERE ol.object_chr_id = okh.id
5016: AND ol.process_flag = ''P''
5017: AND ol.ACTIVE_YN = ''Y''
5018: AND oi.id = ol.oie_id

Line 5042: ,okc_class_operations co

5038: AND not exists(
5039: select ol.object_chr_id
5040: from okc_operation_lines ol
5041: ,okc_operation_instances oi
5042: ,okc_class_operations co
5043: WHERE ol.object_chr_id = okh.id
5044: AND ol.process_flag = ''P''
5045: AND ol.ACTIVE_YN = ''Y''
5046: AND oi.id = ol.oie_id

Line 12561: SELECT ID from OKC_CLASS_OPERATIONS_V

12557: -------------------------------------------------------------------------
12558: ---Find the Class Operation ID to be used
12559: --------------------------------------------------------------------------
12560: CURSOR class_operations is
12561: SELECT ID from OKC_CLASS_OPERATIONS_V
12562: WHERE OPN_CODE = 'MASS_CHANGE' and CLS_CODE = 'SERVICE';
12563:
12564: BEGIN
12565: --dbms_output.put_line('Inside ..');

Line 13887: SELECT count(*) cnt FROM okc_class_operations_v

13883:
13884: PROCEDURE Create_Mschg_Class_Operation
13885: IS
13886: CURSOR Check_class_opn IS
13887: SELECT count(*) cnt FROM okc_class_operations_v
13888: WHERE opn_code = 'MASS_CHANGE'
13889: AND cls_code = 'SERVICE';
13890: CURSOR Get_max_id IS
13891: SELECT nvl(max(id),0) + 1 from okc_class_operations_v;

Line 13891: SELECT nvl(max(id),0) + 1 from okc_class_operations_v;

13887: SELECT count(*) cnt FROM okc_class_operations_v
13888: WHERE opn_code = 'MASS_CHANGE'
13889: AND cls_code = 'SERVICE';
13890: CURSOR Get_max_id IS
13891: SELECT nvl(max(id),0) + 1 from okc_class_operations_v;
13892:
13893: l_opn_id Number;
13894: l_count Number := 0;
13895: BEGIN

Line 13908: INSERT INTO okc_class_operations(

13904: OPEN Get_max_id;
13905: FETCH Get_max_id INTO l_opn_id;
13906: CLOSE Get_max_id;
13907:
13908: INSERT INTO okc_class_operations(
13909: ID
13910: ,OPN_CODE
13911: ,CLS_CODE
13912: ,SEARCH_FUNCTION_ID