Hello everyone! I am facing a weird issue that I can't really comprehend. I have a view criteria in my view object. But the query that its being executed its different resulting in error. I am using ADF Oracle JDeveloper 12.2.1.4. Here are some screenshots and code snippets. This is my view criteria.
As you can see in the where clause it says CmCaseNumberNQ2. And this is the query that is actually executed (I am posting only the last part because its too big) AND ( ( ( EXISTS (
SELECT
1
FROM
cm_case cmcasenq1,
cm_case_hco cmcasehco1nq1,
gn_court_cof gncourtcofnq1,
gn_legal_process gnlegalprocessnq1,
gn_at_kk gnatkknq1,
moj_sc.sc_hr_court_office schrcourtofficenq1,
cmr_mvdept cmrmvdeptnq1,
cmr_case_object cmrcaseobjectnq1,
cmr_mventway cmrmventwaynq1,
cm_mvdoc_lines cmmvdoclines1nq1,
cm_mvdoc cmmvdocnq1,
moj_sc.sc_hr_court_office schrcourtofficejoinwithhcoidq1,
cmr_mvdept cmrmvdeptforcascurrmvdidnq1,
cm_case cmcaseothernq1,
cm_mvdoc_lines cmmvdoclinesforcasoutmvlidnq1,
cm_jud_mns_bill cmjudmnsbilliforonnq1,
cm_bill cmbilliforonnq1
WHERE
( cmcasehco1nq1.cm_cas_ccr_id = gncourtcofnq1.gn_ccr_id (+)
AND cmcasehco1nq1.cm_cas_lpr_id = gnlegalprocessnq1.gn_lpr_id (+)
AND cmcasehco1nq1.cm_cas_service_id = gnatkknq1.gn_atk_id (+)
AND cmcasehco1nq1.cm_cas_service_id = schrcourtofficenq1.sc_hco_id (+)
AND cmcasehco1nq1.cm_cas_mvd_id = cmrmvdeptnq1.cmr_mvd_id (+)
AND cmcasehco1nq1.cm_cas_cob_id = cmrcaseobjectnq1.cmr_cob_id (+)
AND cmcasehco1nq1.cm_cas_mve_id = cmrmventwaynq1.cmr_mve_id (+)
AND cmcasehco1nq1.cm_cas_mvl_id = cmmvdoclines1nq1.cm_mvl_id (+)
AND cmmvdoclines1nq1.cm_mvl_mvo_id = cmmvdocnq1.cm_mvo_id (+)
AND cmcasenq1.cm_cas_hco_id = schrcourtofficejoinwithhcoidq1.sc_hco_id (+)
AND cmcasenq1.cm_cas_id = cmcasehco1nq1.cm_cho_cas_id
AND cmcasenq1.cm_cas_curr_mvd_id = cmrmvdeptforcascurrmvdidnq1.cmr_mvd_id (+)
AND cmcasenq1.cm_cas_other_cas_id = cmcaseothernq1.cm_cas_id (+)
AND cmcasenq1.cm_cas_out_mvl_id = cmmvdoclinesforcasoutmvlidnq1.cm_mvl_id (+)
AND cmcasehco1nq1.cm_cho_jub_id = cmjudmnsbilliforonnq1.cm_jub_id (+)
AND cmjudmnsbilliforonnq1.cm_jub_bil_id = cmbilliforonnq1.cm_bil_id (+) )
AND ( ( ( cmcasehco1nq1.cm_cho_hco_id = :inhcoid ) ) )
AND ( ( ( EXISTS (
SELECT
1
FROM
cm_case_number cmcasenumbernq2,
gn_court_cof_book gncourtcofbooknq2,
cmr_mvdept_book cmrmvdeptbook1nq2,
cmr_mventway cmrmventwaynq2,
sc_hr_court_office schrcourtofficenq2
WHERE
cmcasenumbernq2.cm_cnm_ccb_id = gncourtcofbooknq2.gn_ccb_id (+)
AND cmcasenumbernq2.cm_cnm_mvb_id = cmrmvdeptbook1nq2.cmr_mvb_id (+)
AND cmcasenumbernq2.cm_cnm_mve_id = cmrmventwaynq2.cmr_mve_id (+)
AND cmcasenumbernq2.cm_cnm_hco_id = schrcourtofficenq2.sc_hco_id (+)
AND ( ( ( upper(_**cmcasenumbernq1**_.cm_cnm_booknr) = upper(:incmcnmbooknr) ) ) )
AND ( cmcasenq1.cm_cas_id = _**cmcasenumbernq1**_.cm_cnm_cas_id )
) ) ) )
AND ( cmdktcase.cm_dka_cas_id = cmcasenq1.cm_cas_id )
) ) ) ) As you can see it appears a CmCaseNumberNQ1? What is that? Its resulting in error Error Msg = ORA-00904: "CMCASENUMBERNQ1"."CM_CNM_CAS_ID": invalid identifier