APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_OPERATION_LINES

Line 97: --| OKC_OPERATION_LINES | X | | | | | |

93: --| OKS_BILL_SCH | | | | | |X |
94: --+---------------------------------+---+---+---+---+---+----------------------+
95: --| OKC_K_HEADERS_B_S | X | | | | | |
96: --+---------------------------------+---+---+---+---+---+----------------------+
97: --| OKC_OPERATION_LINES | X | | | | | |
98: --+---------------------------------+---+---+---+---+---+----------------------+
99: --| OKC_OPERATION_INSTANCES | X | | | | | |
100: --+---------------------------------+---+---+---+---+---+----------------------+
101: --| OKC_K_ITEMS_V | X | | | | | |

Line 195: From Okc_operation_lines ol

191: AND status_code = 'PROCESSED';
192:
193: Cursor check_rec_exists(P_Id Number) Is
194: Select 'X'
195: From Okc_operation_lines ol
196: ,okc_operation_instances Ins
197: Where ol.subject_chr_id = P_target_chr_id
198: And ol.object_chr_id = p_source_chr_id
199: And ol.subject_cle_id Is Null

Line 285: INSERT INTO OKC_OPERATION_LINES(

281:
282: End If;
283: CLOSE check_oper_inst_csr;
284:
285: INSERT INTO OKC_OPERATION_LINES(
286: id,
287: select_yn,
288: process_flag,
289: active_yn,

Line 340: INSERT INTO OKC_OPERATION_LINES(

336: Open check_rec_exists(l_oper_instance_id);
337: Fetch check_rec_exists into l_exists ;
338: Close check_rec_exists;
339: If l_exists is Null Then
340: INSERT INTO OKC_OPERATION_LINES(
341: id,
342: select_yn,
343: process_flag,
344: active_yn,

Line 1770: , okc_operation_lines ol

1766: SELECT object_chr_id
1767: FROM okc_operation_instances op
1768: , okc_class_operations cls
1769: , okc_subclasses_b sl
1770: , okc_operation_lines ol
1771: WHERE ol.subject_chr_id = contract_id
1772: And ol.subject_cle_id is null
1773: And op.id = ol.oie_id
1774: AND op.cop_id = cls.id

Line 5597: okc_operation_lines ol,

5593: CURSOR get_object_line_csr
5594: IS
5595: SELECT object_cle_id, OBJECT_CHR_ID
5596: FROM okc_operation_instances op,
5597: okc_operation_lines ol,
5598: okc_class_operations cls,
5599: okc_subclasses_b sl
5600: WHERE ol.oie_id = op.ID
5601: AND cls.cls_code = sl.cls_code

Line 5613: okc_operation_lines ol,

5609: )
5610: IS
5611: SELECT ol.subject_cle_id, ol.subject_chr_id
5612: FROM okc_operation_instances op,
5613: okc_operation_lines ol,
5614: okc_class_operations cls,
5615: okc_subclasses_b sl
5616: WHERE ol.oie_id = op.ID
5617: AND cls.cls_code = sl.cls_code

Line 6525: okc_operation_lines ol

6521: )
6522: IS
6523: SELECT subject_cle_id
6524: FROM okc_operation_instances op,
6525: okc_operation_lines ol
6526: WHERE ol.oie_id = op.ID
6527: AND op.cop_id = 41
6528: AND ol.subject_cle_id = p_line_id;
6529: