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_OPERATION_INSTANCES

Line 698: from okc_operation_instances OIE,

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

Line 726: okc_operation_instances OIE, --**

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

Line 742: okc_operation_instances OIE, --**

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

Line 776: okc_operation_instances OIE1,

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

Line 778: okc_operation_instances OIE2,

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

Line 802: okc_operation_instances OIE1,

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

Line 804: okc_operation_instances OIE2,

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

Line 852: okc_operation_instances OIE,

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

Line 865: okc_operation_instances OIE,

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

Line 899: okc_operation_instances OIE1, --**

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

Line 901: okc_operation_instances OIE2, --**

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

Line 929: okc_operation_instances OIE1, --**

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

Line 931: okc_operation_instances OIE2, --**

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

Line 985: okc_operation_instances OIE1, --**

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

Line 987: okc_operation_instances OIE2, --**

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

Line 1015: okc_operation_instances OIE1, --**

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

Line 1017: okc_operation_instances OIE2, --**

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

Line 1072: okc_operation_instances OIE1, --**

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

Line 1074: okc_operation_instances OIE2, --**

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

Line 1093: okc_operation_instances OIE1, --**

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

Line 1095: okc_operation_instances OIE2, --**

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