create or replace  view VW_BA_QSCX as
select
BAH000,
ZYCS00,
BRXM00,
BRXB00,
CYRQ00,
(select BMMC00 from BM_BMBM00 B where B.BMBH00 = CYKB00 and rownum = 1) CYKBMC,
ZYYSMC,
QSRQ00
from BA_BRZYXX;