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_OPERATION_INSTANCES

Line 655: from okc_operation_instances OIE,

651: l_renewed varchar2(1):= 'N';
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

Line 683: okc_operation_instances OIE, --**

679: select distinct contract_number, contract_number_modifier,
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 --**

Line 699: okc_operation_instances OIE, --**

695: select contract_number, contract_number_modifier,
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

Line 733: okc_operation_instances OIE1,

729: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
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

Line 735: okc_operation_instances OIE2,

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
739: and OLI1.oie_id = OIE1.id

Line 759: okc_operation_instances OIE1,

755: okc_k_lines_b CLE,
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

Line 761: okc_operation_instances OIE2,

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
765: and OLI1.oie_id = OIE1.id

Line 809: okc_operation_instances OIE,

805: cursor c1 is
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

Line 822: okc_operation_instances OIE,

818: cursor c2 is
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

Line 856: okc_operation_instances OIE1, --**

852: FROM okc_k_headers_b CHR,
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

Line 858: okc_operation_instances OIE2, --**

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 --**
862: and OIE1.cop_id = COP1.id --**

Line 886: okc_operation_instances OIE1, --**

882: okc_k_lines_b CLE,
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

Line 888: okc_operation_instances OIE2, --**

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 --**
892: and OIE1.cop_id = COP1.id --**

Line 942: okc_operation_instances OIE1, --**

938: FROM okc_k_headers_b CHR,
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

Line 944: okc_operation_instances OIE2, --**

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 --**
948: and OIE1.cop_id = COP1.id --**

Line 972: okc_operation_instances OIE1, --**

968: okc_k_lines_b CLE,
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

Line 974: okc_operation_instances OIE2, --**

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
978: and OLI1.oie_id = OIE1.id --**

Line 1029: okc_operation_instances OIE1, --**

1025: cursor C1 is
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

Line 1031: okc_operation_instances OIE2, --**

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 --**
1035: and OIE1.cop_id = COP1.id --**

Line 1050: okc_operation_instances OIE1, --**

1046: Cursor C2 is
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

Line 1052: okc_operation_instances OIE2, --**

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 --**
1056: and OIE1.cop_id = COP1.id --**