请大家帮我看看Oracle建立视图的语句

我写的视图语句是这样的
create or replace view j_customer_view as
select C.CUSTOMER_ID,C.CUSTOMER_NAME,C.PARENT_CUSTOMER_ID,C.TRADE_NAME,(select name from J_REGION B where C.PROV_REGION_CODE=B.REGION_CODE) AS NAME1,
(select name from J_REGION B where C.CITY_REGION_CODE=B.REGION_CODE) AS NAME2,
(select name from J_REGION B where C.SUB_CITY_REGION_CODE=B.REGION_CODE) AS NAME3,C.CUSTOMER_ADDRESS,
  C.POSTMAIL,C.ORG_ALIAS,C.ORG_ENGLISH_NAME,C.ORG_DESC,C.ORG_TYPE,C.WEB_SITE,C.EMAIL,C.ORG_KIND,
  C.SOURCE_FLAG,C.REGISTERED_MARK,(select U.LOGINNAME from J_USER U where U.USERID=C.CREATE_EMPL_ID ),C.CREATE_EMPL_ID,C.STATUS,C.COLL_EMPL,
  (select U1.LOGINNAME from J_USER U1 where U1.USERID=C.AUDIT_EMPL_ID ),C.AUDIT_EMPL_ID,C.AUDIT_TIME,
  C.CREATE_TIME,C.INT_ORG_ID
    from J_INT_ORG C where C.AUDIT_EMPL_ID is not null  and C.AUDIT_TIME is not null order by C.INT_ORG_ID;

产生的错误是：ORA-00998 必须使用列别名命名此表达式
上述语句中产生错误的是：
(select U.LOGINNAME from J_USER U where U.USERID=C.CREATE_EMPL_ID )和
(select U1.LOGINNAME from J_USER U1 where U1.USERID=C.AUDIT_EMPL_ID )
因为我必须从J_USER中取得LOGINNAME，而连接条件就是U.USERID=C.CREATE_EMPL_ID
C表是下面出现的。我不知怎么改了，大家帮忙看看，谢谢！

已解决，忘了最基本的了，呵呵