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.

[Home] [Help]

APPS.OKS_CHANGE_STATUS_PVT dependencies on OKC_CLASS_OPERATIONS

Line 656: okc_class_operations COP

652: begin
653: select 'Y'
654: into l_renewed
655: from okc_operation_instances OIE,
656: okc_class_operations COP
657: where OIE.cop_id=COP.id
658: and COP.opn_code in ('RENEWAL', 'REN_CON')
659: and target_chr_id = l_chr_id
660: and rownum = 1;

Line 684: okc_class_operations COP --**

680: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
681: from okc_k_headers_b CHR,
682: okc_operation_lines OLI,
683: okc_operation_instances OIE, --**
684: okc_class_operations COP --**
685: where OLI.subject_chr_id = l_chr_id
686: and OLI.object_chr_id = chr.id
687: and OLI.oie_id = OIE.id --**
688: and OIE.cop_id = COP.id --**

Line 700: okc_class_operations COP --**

696: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
697: from okc_k_headers_b CHR,
698: okc_operation_lines OLI,
699: okc_operation_instances OIE, --**
700: okc_class_operations COP --**
701: where OLI.subject_chr_id = l_chr_id
702: and OLI.subject_cle_id = p_cle_id
703: and OLI.object_chr_id = chr.id
704: and OLI.oie_id = OIE.id --**

Line 734: okc_class_operations COP1,

730: FROM okc_k_headers_b CHR,
731: okc_operation_lines OLI1,
732: okc_operation_lines OLI2,
733: okc_operation_instances OIE1,
734: okc_class_operations COP1,
735: okc_operation_instances OIE2,
736: okc_class_operations COP2
737: WHERE CHR.id = OLI1.subject_chr_id
738: and OLI1.object_chr_id = OLI2.object_chr_id

Line 736: okc_class_operations COP2

732: okc_operation_lines OLI2,
733: okc_operation_instances OIE1,
734: okc_class_operations COP1,
735: okc_operation_instances OIE2,
736: okc_class_operations COP2
737: WHERE CHR.id = OLI1.subject_chr_id
738: and OLI1.object_chr_id = OLI2.object_chr_id
739: and OLI1.oie_id = OIE1.id
740: and OIE1.cop_id = COP1.id

Line 760: okc_class_operations COP1,

756: okc_statuses_b STE,
757: okc_operation_lines OLI1,
758: okc_operation_lines OLI2,
759: okc_operation_instances OIE1,
760: okc_class_operations COP1,
761: okc_operation_instances OIE2,
762: okc_class_operations COP2
763: WHERE CHR.id = OLI1.subject_chr_id
764: and OLI1.object_chr_id = OLI2.object_chr_id

Line 762: okc_class_operations COP2

758: okc_operation_lines OLI2,
759: okc_operation_instances OIE1,
760: okc_class_operations COP1,
761: okc_operation_instances OIE2,
762: okc_class_operations COP2
763: WHERE CHR.id = OLI1.subject_chr_id
764: and OLI1.object_chr_id = OLI2.object_chr_id
765: and OLI1.oie_id = OIE1.id
766: and OIE1.cop_id = COP1.id

Line 810: okc_class_operations COP

806: select distinct 'Y'
807: from OKC_K_HEADERS_B CHR,
808: okc_operation_lines OLI,
809: okc_operation_instances OIE,
810: okc_class_operations COP
811: where chr.id = oli.object_chr_id
812: and OLI.oie_id = OIE.id
813: and OIE.cop_id = COP.id
814: and COP.opn_code in ('RENEWAL', 'REN_CON')

Line 823: okc_class_operations COP

819: select distinct 'Y'
820: from OKC_K_LINES_B CLE,
821: okc_operation_lines OLI,
822: okc_operation_instances OIE,
823: okc_class_operations COP
824: where cle.id = oli.object_cle_id
825: and OLI.oie_id = OIE.id
826: and OIE.cop_id = COP.id
827: and COP.opn_code in ('RENEWAL', 'REN_CON')

Line 857: okc_class_operations COP1, --**

853: okc_statuses_b STS,
854: okc_operation_lines OLI1,
855: okc_operation_lines OLI2,
856: okc_operation_instances OIE1, --**
857: okc_class_operations COP1, --**
858: okc_operation_instances OIE2, --**
859: okc_class_operations COP2 --**
860: WHERE CHR.id = OLI1.subject_chr_id
861: and OLI1.oie_id = OIE1.id --**

Line 859: okc_class_operations COP2 --**

855: okc_operation_lines OLI2,
856: okc_operation_instances OIE1, --**
857: okc_class_operations COP1, --**
858: okc_operation_instances OIE2, --**
859: okc_class_operations COP2 --**
860: WHERE CHR.id = OLI1.subject_chr_id
861: and OLI1.oie_id = OIE1.id --**
862: and OIE1.cop_id = COP1.id --**
863: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 887: okc_class_operations COP1, --**

883: okc_statuses_b STS,
884: okc_operation_lines OLI1,
885: okc_operation_lines OLI2,
886: okc_operation_instances OIE1, --**
887: okc_class_operations COP1, --**
888: okc_operation_instances OIE2, --**
889: okc_class_operations COP2 --**
890: WHERE CHR.id = OLI1.subject_chr_id
891: and OLI1.oie_id = OIE1.id --**

Line 889: okc_class_operations COP2 --**

885: okc_operation_lines OLI2,
886: okc_operation_instances OIE1, --**
887: okc_class_operations COP1, --**
888: okc_operation_instances OIE2, --**
889: okc_class_operations COP2 --**
890: WHERE CHR.id = OLI1.subject_chr_id
891: and OLI1.oie_id = OIE1.id --**
892: and OIE1.cop_id = COP1.id --**
893: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 943: okc_class_operations COP1, --**

939: okc_statuses_b STS,
940: okc_operation_lines OLI1,
941: okc_operation_lines OLI2,
942: okc_operation_instances OIE1, --**
943: okc_class_operations COP1, --**
944: okc_operation_instances OIE2, --**
945: okc_class_operations COP2 --**
946: WHERE CHR.id = OLI1.subject_chr_id
947: and OLI1.oie_id = OIE1.id --**

Line 945: okc_class_operations COP2 --**

941: okc_operation_lines OLI2,
942: okc_operation_instances OIE1, --**
943: okc_class_operations COP1, --**
944: okc_operation_instances OIE2, --**
945: okc_class_operations COP2 --**
946: WHERE CHR.id = OLI1.subject_chr_id
947: and OLI1.oie_id = OIE1.id --**
948: and OIE1.cop_id = COP1.id --**
949: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 973: okc_class_operations COP1, --**

969: okc_statuses_b STS,
970: okc_operation_lines OLI1,
971: okc_operation_lines OLI2,
972: okc_operation_instances OIE1, --**
973: okc_class_operations COP1, --**
974: okc_operation_instances OIE2, --**
975: okc_class_operations COP2 --**
976: WHERE CHR.id = OLI1.subject_chr_id
977: and CHR.id = CLE.dnz_chr_id

Line 975: okc_class_operations COP2 --**

971: okc_operation_lines OLI2,
972: okc_operation_instances OIE1, --**
973: okc_class_operations COP1, --**
974: okc_operation_instances OIE2, --**
975: okc_class_operations COP2 --**
976: WHERE CHR.id = OLI1.subject_chr_id
977: and CHR.id = CLE.dnz_chr_id
978: and OLI1.oie_id = OIE1.id --**
979: and OIE1.cop_id = COP1.id --**

Line 1030: okc_class_operations COP1, --**

1026: select distinct 'Y'
1027: from okc_operation_lines OLI1,
1028: okc_operation_lines OLI2,
1029: okc_operation_instances OIE1, --**
1030: okc_class_operations COP1, --**
1031: okc_operation_instances OIE2, --**
1032: okc_class_operations COP2 --**
1033: where OLI1.object_chr_id = OLI2.object_chr_id
1034: and OLI1.oie_id = OIE1.id --**

Line 1032: okc_class_operations COP2 --**

1028: okc_operation_lines OLI2,
1029: okc_operation_instances OIE1, --**
1030: okc_class_operations COP1, --**
1031: okc_operation_instances OIE2, --**
1032: okc_class_operations COP2 --**
1033: where OLI1.object_chr_id = OLI2.object_chr_id
1034: and OLI1.oie_id = OIE1.id --**
1035: and OIE1.cop_id = COP1.id --**
1036: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**

Line 1051: okc_class_operations COP1, --**

1047: select distinct 'Y'
1048: from okc_operation_lines OLI1,
1049: okc_operation_lines OLI2,
1050: okc_operation_instances OIE1, --**
1051: okc_class_operations COP1, --**
1052: okc_operation_instances OIE2, --**
1053: okc_class_operations COP2 --**
1054: where OLI1.object_chr_id = OLI2.object_chr_id
1055: and OLI1.oie_id = OIE1.id --**

Line 1053: okc_class_operations COP2 --**

1049: okc_operation_lines OLI2,
1050: okc_operation_instances OIE1, --**
1051: okc_class_operations COP1, --**
1052: okc_operation_instances OIE2, --**
1053: okc_class_operations COP2 --**
1054: where OLI1.object_chr_id = OLI2.object_chr_id
1055: and OLI1.oie_id = OIE1.id --**
1056: and OIE1.cop_id = COP1.id --**
1057: and COP1.opn_code in ('RENEWAL', 'REN_CON') --**