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_LINES

Line 725: okc_operation_lines OLI,

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

Line 741: okc_operation_lines OLI,

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

Line 774: okc_operation_lines OLI1,

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

Line 775: okc_operation_lines OLI2,

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

Line 800: okc_operation_lines OLI1,

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

Line 801: okc_operation_lines OLI2,

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

Line 851: okc_operation_lines OLI,

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

Line 864: okc_operation_lines OLI,

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

Line 897: okc_operation_lines OLI1,

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

Line 898: okc_operation_lines OLI2,

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

Line 927: okc_operation_lines OLI1,

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

Line 928: okc_operation_lines OLI2,

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

Line 983: okc_operation_lines OLI1,

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

Line 984: okc_operation_lines OLI2,

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

Line 1013: okc_operation_lines OLI1,

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

Line 1014: okc_operation_lines OLI2,

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

Line 1070: from okc_operation_lines OLI1,

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

Line 1071: okc_operation_lines OLI2,

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

Line 1091: from okc_operation_lines OLI1,

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

Line 1092: okc_operation_lines OLI2,

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