The select e.S N, e.F ACTORY, f. NAME as FAB_NAME, e.E QP_ID, e.S ERIALNO, e.c. with our fabrication: NAME, e.L OCATION, e.S ITE,
E.D EPT,, dc NAME as DEPT_NAME, e.O WNER, e. YPE, e.E QP_TYPE, e.c. with our fabrication: URRENT_STATE, s.d. escr as STATE_NAME, e.U SAGE, e.S OP_DOC_NO,
NVL ((select the 'Y' from EPM_MAINTAIN_SET_EQP_DETAIL where eqp_id=e.E QP_ID and rownumE.M AINTAIN_SUB_GROUP
The from EPM_EQP_INFO E
Left the join epm_factory_setting on e.f f actory=f.s n
Left the join epm_department_setting d on e.D EPT=d.S N and E.F ACTORY=d.F ACTORY_SN
Left the join epm_eqp_state s on e.c. with our fabrication: urrent_state=s.s n
Left the join epm_eqp_class c on e.e qp_class=Arthur c. lass_sn where c.a. llow_repair='Y' and e.F ACTORY_SITE_SN='1' and E.s tatus='1' order by e.e qp_id;


The select a.E QP_ID, b. * from EPM_EQP_INFO a
Left the join EPM_EQP_ATTR b on a.E QP_ID=b.E QP_ID;
How to add the following two sentences above? To solve the

CodePudding user response:

The select e.S N, e.F ACTORY, f. NAME as FAB_NAME, e.E QP_ID, e.S ERIALNO, e.c. with our fabrication: NAME, e.L OCATION, e.S ITE,
E.D EPT,, dc NAME as DEPT_NAME, e.O WNER, e. YPE, e.E QP_TYPE, e.c. with our fabrication: URRENT_STATE, s.d. escr as STATE_NAME, e.U SAGE, e.S OP_DOC_NO,
NVL ((select the 'Y' from EPM_MAINTAIN_SET_EQP_DETAIL where eqp_id=e.E QP_ID and rownumE.M AINTAIN_SUB_GROUP,
*
EQP_ID, B.The from EPM_EQP_INFO E
Left the join EPM_EQP_ATTR b on E.E QP_ID=b.E QP_ID
Left the join epm_factory_setting on e.f f actory=f.s n
Left the join epm_department_setting d on e.D EPT=d.S N and E.F ACTORY=d.F ACTORY_SN
Left the join epm_eqp_state s on e.c. with our fabrication: urrent_state=s.s n
Left the join epm_eqp_class c on e.e qp_class=Arthur c. lass_sn where c.a. llow_repair='Y' and e.F ACTORY_SITE_SN='1' and E.s tatus='1' order by e.e qp_id;


=