香港盏记燕窝地址

九龙
地址 慈云山毓华街23号慈云山中心5楼549铺
电话 +852 2322 9068
营业时间 每日：早上11时至晚上8时30分

地址 九龙湾伟业街33号德福广场2期341-343铺
电话 +852 2757 3862
营业时间 每日：早上11时至晚上8时30分

地址 蓝田启田道63号启田商场2楼217铺
电话 +852 2346 6615
营业时间 每日：早上11时至晚上8时30分

地址 乐富地铁站LOF6铺
电话 +852 2338 7369
营业时间 每日：早上11时至晚上8时30分

地址 乐富联合道乐富中心1期2楼S31A铺
电话 +852 2336 4877
营业时间 每日：早上11时至晚上8时30分

地址 深水埗钦州街37K号西九龙中心2楼202铺
电话 +852 2708 1769
营业时间 每日：早上11时至晚上8时30分

地址 旺角弥敦道688号旺角中心1期GS1铺
电话 +852 2398 2777
营业时间 每日：早上11时至晚上8时30分

地址 秀茂坪秀茂坪邨秀茂坪商场2楼219铺
电话 +852 2354 8777
营业时间 每日：早上11时至晚上8时30分

地址 钻石山龙蟠街3号荷里活广场3楼320铺
电话 +852 2110 9288
营业时间 每日：早上11时至晚上8时30分

香港岛
地址 上环干诺道西38号达隆中心地铺
电话 +852 2155 4050
营业时间 每日：早上11时至晚上8时30分

地址 铜锣湾轩尼诗道505号电业城12楼
电话 +852 2573 3251
营业时间 每日：早上11时至晚上8时30分

地址 香港仔利港中心地下G23铺
电话 +852 2873 3339
营业时间 每日：早上11时至晚上8时30分

地址 鰂鱼涌康山道1号康怡广场北座2楼天桥F37铺
电话 +852 2569 2678
营业时间 每日：早上11时至晚上8时30分








































select mv.fund_account as fund_account,
mv.total_debit as total_debit,
mv.color_value,
(case when mv.margin_value > mc.max_exposure then mc.max_exposure
when mv.margin_value <= mc.max_exposure then mv.margin_value
end) as margin_value
from
(select cash.fund_account,
cash.total_debit,
marginvalue.margin_value,
risk.color_value
from
(select a.fund_account,
(current_balance + unfrozen_balance - frozen_balance + correct_balance
- nvl(business_frozen_balance,0) + nvl(business_unfrozen_balance,0)) as total_debit
from hs_fund.fund a, hs_fund.fundreal b
where a.fund_account = b.fund_account(+)
) cash,
(select c.fund_account,
--c.exchange_type,
--c.stock_code,
--c.stock_amount +nvl( d.stockreal_amount,0) as t_amount,

--g.asset_price,
sum(nvl((c.stock_amount +nvl( d.stockreal_amount,0))*g.asset_price*nvl(f.clientmargin_ratio,e.margin_ratio),0)) as margin_value
--nvl(f.clientmargin_ratio,e.margin_ratio) as margin_ratio
from (select fund_account,
stock_code,
exchange_type,
(current_amount - frozen_amount + unfrozen_amount + correct_amount) as stock_amount
from hs_secuhk.stock
) c,
(select fund_account,
exchange_type,
stock_code,
(nvl(real_unfrozen_amount,0) - nvl(business_frozen_amount,0)) as stockreal_amount
from hs_secuhk.stockreal
) d,
(select stock_code,
margin_ratio
from hs_secuhk.marginratio
) e,
(select fund_account,
stock_code,
margin_ratio as clientmargin_ratio
from hs_secuhk.clientmarginratio
) f,
(select stock_code,
exchange_type,
asset_price
from hs_secuhk.price
) g
where c.fund_account = d.fund_account(+)
and c.exchange_type = d.exchange_type(+)
and c.stock_code = d.stock_code(+)
and e.stock_code = c.stock_code(+)
and c.fund_account = f.fund_account(+)
and c.stock_code = f.stock_code(+)
and c.stock_code = g.stock_code
group by c.fund_account
) marginvalue,
(select color_value,
control_value
from hs_secuhk.riskcontrol
where risk_id = 0
) risk,
(select fund_account from hs_fund.fundaccount where asset_prop = 'M'
) client
where cash.fund_account = marginvalue.fund_account
and cash.fund_account = client.fund_account
order by cash.fund_account) mv,
(select fund_account,
max_exposure
from hs_secuhk.margincontract
) mc
where mv.fund_account = mc.fund_account