xianlu1

电信数字交换机用户数据联机下载入磁带程序

SELECT B.PHONE_NBR,B.ROW_NBR,B.PAIR_NBR,D.DISH_SEQ,R2.CUST_NME,R2.CUST_SUB_NME,R3.DETIAL
FROM HRB_TB_HX_DBT_FRAME B,
     HRB_TB_HX_MAIN_POLE C,
     HRB_TB_HX_DISTRIBUTION D,
     hrb_tb_subscr_phone r1,
     hrb_tb_sl_cust r2,
     hrb_tb_sl_addr r3
WHERE B.CITY_CDE='01'
      AND B.BC_ID IN ('P08','P19') 
      AND B.STATUS ='SZ'
      AND C.LAST_EQUIP=B.ROW_NBR
      AND C.LAST_EQUIP_CDE IS NULL
      AND C.LAST_EQUIP_SEQ=B.PAIR_NBR
      AND C.PHONE_NBR=B.PHONE_NBR
      AND C.MP_STATUS=B.STATUS
      AND D.PHONE_NBR=B.PHONE_NBR
      AND D.CITY_CDE=C.CITY_CDE
      AND D.BC_ID=C.BC_ID
      AND D.CCP_ID=C.CCP_ID
      AND R1.PHONE_NBR=B.PHONE_NBR
      AND R1.CUST_NBR=R2.CUST_NBR
      AND R1.ADDR_NBR=R3.ADDR_NBR
      ORDER BY B.BC_ID,B.ROW_NBR,B.PAIR_NBR