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 1766: , okc_operation_lines ol

1762: SELECT object_chr_id
1763: FROM okc_operation_instances op
1764: , okc_class_operations cls
1765: , okc_subclasses_b sl
1766: , okc_operation_lines ol
1767: WHERE ol.subject_chr_id = contract_id
1768: And ol.subject_cle_id is null
1769: And op.id = ol.oie_id
1770: AND op.cop_id = cls.id

Line 5580: okc_operation_lines ol,

5576: CURSOR get_object_line_csr
5577: IS
5578: SELECT object_cle_id, OBJECT_CHR_ID
5579: FROM okc_operation_instances op,
5580: okc_operation_lines ol,
5581: okc_class_operations cls,
5582: okc_subclasses_b sl
5583: WHERE ol.oie_id = op.ID
5584: AND cls.cls_code = sl.cls_code

Line 5596: okc_operation_lines ol,

5592: )
5593: IS
5594: SELECT ol.subject_cle_id, ol.subject_chr_id
5595: FROM okc_operation_instances op,
5596: okc_operation_lines ol,
5597: okc_class_operations cls,
5598: okc_subclasses_b sl
5599: WHERE ol.oie_id = op.ID
5600: AND cls.cls_code = sl.cls_code

Line 6508: okc_operation_lines ol

6504: )
6505: IS
6506: SELECT subject_cle_id
6507: FROM okc_operation_instances op,
6508: okc_operation_lines ol
6509: WHERE ol.oie_id = op.ID
6510: AND op.cop_id = 41
6511: AND ol.subject_cle_id = p_line_id;
6512: