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

Line 699: okc_class_operations COP

695: begin
696: select 'Y'
697: into l_renewed
698: from okc_operation_instances OIE,
699: okc_class_operations COP
700: where OIE.cop_id=COP.id
701: and COP.opn_code in ('RENEWAL', 'REN_CON')
702: and target_chr_id = l_chr_id
703: and rownum = 1;

Line 727: okc_class_operations COP --**

723: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
724: from okc_k_headers_b CHR,
725: okc_operation_lines OLI,
726: okc_operation_instances OIE, --**
727: okc_class_operations COP --**
728: where OLI.subject_chr_id = l_chr_id
729: and OLI.object_chr_id = chr.id
730: and OLI.oie_id = OIE.id --**
731: and OIE.cop_id = COP.id --**

Line 743: okc_class_operations COP --**

739: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
740: from okc_k_headers_b CHR,
741: okc_operation_lines OLI,
742: okc_operation_instances OIE, --**
743: okc_class_operations COP --**
744: where OLI.subject_chr_id = l_chr_id
745: and OLI.subject_cle_id = p_cle_id
746: and OLI.object_chr_id = chr.id
747: and OLI.oie_id = OIE.id --**

Line 777: okc_class_operations COP1,

773: FROM okc_k_headers_b CHR,
774: okc_operation_lines OLI1,
775: okc_operation_lines OLI2,
776: okc_operation_instances OIE1,
777: okc_class_operations COP1,
778: okc_operation_instances OIE2,
779: okc_class_operations COP2
780: WHERE CHR.id = OLI1.subject_chr_id
781: and OLI1.object_chr_id = OLI2.object_chr_id

Line 779: okc_class_operations COP2

775: okc_operation_lines OLI2,
776: okc_operation_instances OIE1,
777: okc_class_operations COP1,
778: okc_operation_instances OIE2,
779: okc_class_operations COP2
780: WHERE CHR.id = OLI1.subject_chr_id
781: and OLI1.object_chr_id = OLI2.object_chr_id
782: and OLI1.oie_id = OIE1.id
783: and OIE1.cop_id = COP1.id

Line 803: okc_class_operations COP1,

799: okc_statuses_b STE,
800: okc_operation_lines OLI1,
801: okc_operation_lines OLI2,
802: okc_operation_instances OIE1,
803: okc_class_operations COP1,
804: okc_operation_instances OIE2,
805: okc_class_operations COP2
806: WHERE CHR.id = OLI1.subject_chr_id
807: and OLI1.object_chr_id = OLI2.object_chr_id

Line 805: okc_class_operations COP2

801: okc_operation_lines OLI2,
802: okc_operation_instances OIE1,
803: okc_class_operations COP1,
804: okc_operation_instances OIE2,
805: okc_class_operations COP2
806: WHERE CHR.id = OLI1.subject_chr_id
807: and OLI1.object_chr_id = OLI2.object_chr_id
808: and OLI1.oie_id = OIE1.id
809: and OIE1.cop_id = COP1.id

Line 853: okc_class_operations COP

849: select distinct 'Y'
850: from OKC_K_HEADERS_B CHR,
851: okc_operation_lines OLI,
852: okc_operation_instances OIE,
853: okc_class_operations COP
854: where chr.id = oli.object_chr_id
855: and OLI.oie_id = OIE.id
856: and OIE.cop_id = COP.id
857: and COP.opn_code in ('RENEWAL', 'REN_CON')

Line 866: okc_class_operations COP

862: select distinct 'Y'
863: from OKC_K_LINES_B CLE,
864: okc_operation_lines OLI,
865: okc_operation_instances OIE,
866: okc_class_operations COP
867: where cle.id = oli.object_cle_id
868: and OLI.oie_id = OIE.id
869: and OIE.cop_id = COP.id
870: and COP.opn_code in ('RENEWAL', 'REN_CON')

Line 900: okc_class_operations COP1, --**

896: okc_statuses_b STS,
897: okc_operation_lines OLI1,
898: okc_operation_lines OLI2,
899: okc_operation_instances OIE1, --**
900: okc_class_operations COP1, --**
901: okc_operation_instances OIE2, --**
902: okc_class_operations COP2 --**
903: WHERE CHR.id = OLI1.subject_chr_id
904: and OLI1.oie_id = OIE1.id --**

Line 902: okc_class_operations COP2 --**

898: okc_operation_lines OLI2,
899: okc_operation_instances OIE1, --**
900: okc_class_operations COP1, --**
901: okc_operation_instances OIE2, --**
902: okc_class_operations COP2 --**
903: WHERE CHR.id = OLI1.subject_chr_id
904: and OLI1.oie_id = OIE1.id --**
905: and OIE1.cop_id = COP1.id --**
906: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 930: okc_class_operations COP1, --**

926: okc_statuses_b STS,
927: okc_operation_lines OLI1,
928: okc_operation_lines OLI2,
929: okc_operation_instances OIE1, --**
930: okc_class_operations COP1, --**
931: okc_operation_instances OIE2, --**
932: okc_class_operations COP2 --**
933: WHERE CHR.id = OLI1.subject_chr_id
934: and OLI1.oie_id = OIE1.id --**

Line 932: okc_class_operations COP2 --**

928: okc_operation_lines OLI2,
929: okc_operation_instances OIE1, --**
930: okc_class_operations COP1, --**
931: okc_operation_instances OIE2, --**
932: okc_class_operations COP2 --**
933: WHERE CHR.id = OLI1.subject_chr_id
934: and OLI1.oie_id = OIE1.id --**
935: and OIE1.cop_id = COP1.id --**
936: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 986: okc_class_operations COP1, --**

982: okc_statuses_b STS,
983: okc_operation_lines OLI1,
984: okc_operation_lines OLI2,
985: okc_operation_instances OIE1, --**
986: okc_class_operations COP1, --**
987: okc_operation_instances OIE2, --**
988: okc_class_operations COP2 --**
989: WHERE CHR.id = OLI1.subject_chr_id
990: and OLI1.oie_id = OIE1.id --**

Line 988: okc_class_operations COP2 --**

984: okc_operation_lines OLI2,
985: okc_operation_instances OIE1, --**
986: okc_class_operations COP1, --**
987: okc_operation_instances OIE2, --**
988: okc_class_operations COP2 --**
989: WHERE CHR.id = OLI1.subject_chr_id
990: and OLI1.oie_id = OIE1.id --**
991: and OIE1.cop_id = COP1.id --**
992: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 1016: okc_class_operations COP1, --**

1012: okc_statuses_b STS,
1013: okc_operation_lines OLI1,
1014: okc_operation_lines OLI2,
1015: okc_operation_instances OIE1, --**
1016: okc_class_operations COP1, --**
1017: okc_operation_instances OIE2, --**
1018: okc_class_operations COP2 --**
1019: WHERE CHR.id = OLI1.subject_chr_id
1020: and CHR.id = CLE.dnz_chr_id

Line 1018: okc_class_operations COP2 --**

1014: okc_operation_lines OLI2,
1015: okc_operation_instances OIE1, --**
1016: okc_class_operations COP1, --**
1017: okc_operation_instances OIE2, --**
1018: okc_class_operations COP2 --**
1019: WHERE CHR.id = OLI1.subject_chr_id
1020: and CHR.id = CLE.dnz_chr_id
1021: and OLI1.oie_id = OIE1.id --**
1022: and OIE1.cop_id = COP1.id --**

Line 1073: okc_class_operations COP1, --**

1069: select distinct 'Y'
1070: from okc_operation_lines OLI1,
1071: okc_operation_lines OLI2,
1072: okc_operation_instances OIE1, --**
1073: okc_class_operations COP1, --**
1074: okc_operation_instances OIE2, --**
1075: okc_class_operations COP2 --**
1076: where OLI1.object_chr_id = OLI2.object_chr_id
1077: and OLI1.oie_id = OIE1.id --**

Line 1075: okc_class_operations COP2 --**

1071: okc_operation_lines OLI2,
1072: okc_operation_instances OIE1, --**
1073: okc_class_operations COP1, --**
1074: okc_operation_instances OIE2, --**
1075: okc_class_operations COP2 --**
1076: where OLI1.object_chr_id = OLI2.object_chr_id
1077: and OLI1.oie_id = OIE1.id --**
1078: and OIE1.cop_id = COP1.id --**
1079: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 1094: okc_class_operations COP1, --**

1090: select distinct 'Y'
1091: from okc_operation_lines OLI1,
1092: okc_operation_lines OLI2,
1093: okc_operation_instances OIE1, --**
1094: okc_class_operations COP1, --**
1095: okc_operation_instances OIE2, --**
1096: okc_class_operations COP2 --**
1097: where OLI1.object_chr_id = OLI2.object_chr_id
1098: and OLI1.oie_id = OIE1.id --**

Line 1096: okc_class_operations COP2 --**

1092: okc_operation_lines OLI2,
1093: okc_operation_instances OIE1, --**
1094: okc_class_operations COP1, --**
1095: okc_operation_instances OIE2, --**
1096: okc_class_operations COP2 --**
1097: where OLI1.object_chr_id = OLI2.object_chr_id
1098: and OLI1.oie_id = OIE1.id --**
1099: and OIE1.cop_id = COP1.id --**
1100: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**