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_LINES

Line 682: okc_operation_lines OLI,

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

Line 698: okc_operation_lines OLI,

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

Line 731: okc_operation_lines OLI1,

727: CURSOR C1 IS
728: SELECT distinct contract_number, contract_number_modifier,
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,

Line 732: okc_operation_lines OLI2,

728: SELECT distinct contract_number, contract_number_modifier,
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

Line 757: okc_operation_lines OLI1,

753: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contracts
754: FROM okc_k_headers_b CHR,
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,

Line 758: okc_operation_lines OLI2,

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

Line 808: okc_operation_lines OLI,

804: --
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

Line 821: okc_operation_lines OLI,

817:
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

Line 854: okc_operation_lines OLI1,

850: CURSOR c1 IS
851: SELECT distinct 'Y'
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, --**

Line 855: okc_operation_lines OLI2,

851: SELECT distinct 'Y'
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 --**

Line 884: okc_operation_lines OLI1,

880: SELECT distinct 'Y'
881: FROM okc_k_headers_b CHR,
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, --**

Line 885: okc_operation_lines OLI2,

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

Line 940: okc_operation_lines OLI1,

936: CURSOR c1 IS
937: SELECT distinct 'Y'
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, --**

Line 941: okc_operation_lines OLI2,

937: SELECT distinct 'Y'
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 --**

Line 970: okc_operation_lines OLI1,

966: SELECT distinct 'Y'
967: FROM okc_k_headers_b CHR,
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, --**

Line 971: okc_operation_lines OLI2,

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

Line 1027: from okc_operation_lines OLI1,

1023: --** Additional check added as we are only interested in 'Renewal and Renewal Consolidation'
1024:
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, --**

Line 1028: okc_operation_lines OLI2,

1024:
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 --**

Line 1048: from okc_operation_lines OLI1,

1044:
1045: -- Line Level Check added as part of LLC
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, --**

Line 1049: okc_operation_lines OLI2,

1045: -- Line Level Check added as part of LLC
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 --**