[Home] [Help]
63: AND okh.date_terminated is NULL
64: AND okh.id not in(
65: SELECT ole.subject_chr_id
66: FROM okc_operation_instances_v oie,
67: okc_operation_lines_v ole,
68: okc_class_operations_v oco
69: WHERE oie.id = ole.oie_id
70: AND oie.id = :p_ctr_rec_oie_id
71: AND oie.cop_id = oco.id AND opn_code = ''MASS_CHANGE'')
103: AND okh.datetime_cancelled IS NULL -- Added as part of LLC
104: AND okh.date_terminated is NULL
105: AND okh.id not in ( SELECT ole.subject_chr_id
106: FROM okc_operation_instances_v oie,
107: okc_operation_lines_v ole,
108: okc_class_operations_v oco
109: WHERE oie.id = ole.oie_id
110: AND oie.id = :p_ctr_rec_oie_id
111: AND oie.cop_id = oco.id AND opn_code = ''MASS_CHANGE'')
155: mod.qa_check_yn,
156: org.name ,
157: okh.billed_at_source';
158:
159: l_from :=' FROM okc_k_headers_v okh,okc_operation_lines_v ole ,oks_mschg_operations_dtls mod, hr_operating_units org';
160: l_where:=' WHERE ole.select_yn = ''Y''
161: AND ole.process_flag IN (''A'',''E'')
162: AND okh.id = ole.subject_chr_id
163: AND ole.oie_id = :p_ctr_rec_oie_id
7036: mrd.old_value,
7037: okh.billed_at_source
7038:
7039: FROM okc_k_headers_v okh,
7040: okc_operation_lines_v ole,
7041: okc_masschange_req_dtls_v mrd
7042: WHERE ole.select_yn = 'Y'
7043: AND ole.process_flag is NULL
7044: AND okh.id = ole.subject_chr_id
13120: l_omrv_tbl_in OKC_OPER_INST_PUB.mrdv_tbl_type; --OPERATION LINES
13121:
13122: CURSOR Get_opn_lines IS
13123: SELECT ole.id ole_id,omr.id omr_id
13124: from OKC_OPERATION_LINES_V ole, OKC_MASSCHANGE_REQ_DTLS_V omr
13125: where ole.id = omr.ole_id
13126: AND omr.oie_id IS NULL
13127: AND ole.oie_id = p_oie_id;
13128: ------------------------------------------------------------------