APPS.OKS_MASSCHANGE_PVT dependencies on OKC_MASSCHANGE_REQ_DTLS_V

Line 7041: okc_masschange_req_dtls_v mrd

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
7045: AND ole.id = mrd.ole_id

Line 12743: SELECT id from okc_masschange_req_dtls_v

12739: l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12740: l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12741:
12742: CURSOR Get_line_req(p_oie_id IN Number) IS
12743: SELECT id from okc_masschange_req_dtls_v
12744: WHERE oie_id = p_oie_id;
12745: BEGIN
12746: --dbms_output.put_line('Inside ..');
12747:

Line 12849: -- SELECT ID from OKC_MASSCHANGE_REQ_DTLS_V

12845: -- l_omrv_tbl_in OKC_OPER_INST_PUB.oiev_tbl_type;
12846: -- l_omrv_tbl_out OKC_OPER_INST_PUB.oiev_tbl_type;
12847:
12848: -- CURSOR omrv_id is
12849: -- SELECT ID from OKC_MASSCHANGE_REQ_DTLS_V
12850: -- WHERE oie_id = p_oie_rec.oie_id;
12851: -- */
12852:
12853: BEGIN

Line 13124: from OKC_OPERATION_LINES_V ole, OKC_MASSCHANGE_REQ_DTLS_V omr

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