<![CDATA[
SELECT T.LNKS_NAME,
I.LNK_NAME,
I.LNK_ID,
T.LEVEL_NAME,
T.L1_VENDOR_CNAME,
I.IF_CAPACITY,
I.MEMO,
T.L1_CITY_NAME,
I.SLOT_NUM,
I.IF_TYPE,
I.IF_IP || ' ' || I.IF_NO as L1,
I.IF_IP,
I.IF_NO,
T.L1_ID,
T.L1_CITY_ID,
T.L1_NE,
T.L1_IF_IP_MASK,
I.IF_STATUS,
T.L2_CITY_NAME,
T.L2_SLOT_NUM,
T.L2_IF_IP || ' ' || T.L2_IF_NO as L2,
T.L2_IF_IP,
T.L2_IF_NO,
T.L2_IF_IP_MASK,
T.L2_NE,
T.L2_CITY_ID
FROM CONFIG.CCD_LINKS_INFO_V T,
CONFIG.CCD_INTERFACE_T I
WHERE T.LNK_NAME = I.LNK_NAME
AND T.l1_NE = I.NE
AND T.L1_ID < T.L2_ID
AND #city_id# IN (L1_CITY_ID, T.L2_CITY_ID)
and t.lnk_level=#link_level#
order by I.LNK_NAME desc
]]>
SELECT T.LNKS_NAME,
I.LNK_NAME,
I.LNK_ID,
T.LEVEL_NAME,
T.L1_VENDOR_CNAME,
I.IF_CAPACITY,
I.MEMO,
T.L1_CITY_NAME,
I.SLOT_NUM,
I.IF_TYPE,
I.IF_IP || ' ' || I.IF_NO as L1,
I.IF_IP,
I.IF_NO,
T.L1_ID,
T.L1_CITY_ID,
T.L1_NE,
T.L1_IF_IP_MASK,
I.IF_STATUS,
T.L2_CITY_NAME,
T.L2_SLOT_NUM,
T.L2_IF_IP || ' ' || T.L2_IF_NO as L2,
T.L2_IF_IP,
T.L2_IF_NO,
T.L2_IF_IP_MASK,
T.L2_NE,
T.L2_CITY_ID
FROM CONFIG.CCD_LINKS_INFO_V T,
CONFIG.CCD_INTERFACE_T I
WHERE T.LNK_NAME = I.LNK_NAME
AND T.l1_NE = I.NE
AND T.L1_ID < T.L2_ID
AND #city_id# IN (L1_CITY_ID, T.L2_CITY_ID)
and t.lnk_level=#link_level#
order by I.LNK_NAME desc
]]>