1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
| DECLARE @as_bro_id varchar(16)
select bro_orderid, bro_orderseq, bro_remarks, bro_status, bro_date_mod, bro_uid_mod, bro_order_from, bro_secnumber, bro_secdescription,
bro_ccy1, bro_set1cstnbr, bro_set1cst_portf, bro_set1cstinst, bro_setacseq, bro_setccy, bro_dealinst,
bro_cstnumber, bro_cstportf, bro_sec_expnom, bro_amount1, bro_amount2, bro_sec_actionnom, bro_sec_expprice,
bro_secprice1, bro_sec_actionprice, bro_secprice2, bro_fe1_disc, bro_fe2_disc, bro_sec_marge, bro_sec_expdate,
bro_sec_actdate, bro_sec_brok, bro_custodi, bro_sec_expamount, bro_sxcode, tds_desc1, tds_desc2, tds_cp_last,
tds_maturity, tds_cprate, tds_desc_rpt, pta_descint, eic_name, tac_code1, tac_code2, ssi1.ncs_number ncs_mid, ssi2.ncs_number ncs_isin,
ssi3.ncs_number ncs_vd, cds_namerpt, tro_descint, sro_descint, tst_trt, dfa_descint, bro_sec_inputtype
FROM dbo.tblbookorder bro,
dbo.tblsecur tds,
dbo.tblactype pta,
dbo.tblcie eic,
dbo.tbltab03 tac,
dbo.tblcodif ssi1, --ncs
dbo.tblcodif ssi2, --ncs
dbo.tblcodif ssi3, --ncs
dbo.tblcusact acs,
dbo.tbltodian cds,
dbo.tblordtype tro,
dbo.tblordstype sro,
dbo.tblordtstype tst,
dbo.tblfeedisc dfa
WHERE bro_orderid = @as_bro_id
AND tds_number =* bro_secnumber
AND pta_code = bro_dealinst
AND acs_customer =* bro_cstnumber
AND acs_secur =* bro_secnumber
AND acs_portf =* bro_cstportf
AND acs_atype =* bro_dealinst
AND acs_ccy =* bro_ccy1
AND bro_custodi = cds_number
AND eic_code = 1
AND tac_code = 10
AND ssi1.ncs_sec =* bro_secnumber
AND ssi1.ncs_code = "DIM"
AND ssi2.ncs_sec =* bro_secnumber
AND ssi2.ncs_code = "NISI"
AND ssi3.ncs_sec =* bro_secnumber
AND ssi3.ncs_code = "VD"
AND bro_ort *= tro_code
AND bro_ors *= sro_code
AND bro_ort *= tst_ort
AND bro_ors *= tst_ors
AND ((bro_fe1_disc IS NOT NULL AND bro_fe1_disc *= dfa.dfa_code)
OR (bro_fe2_disc IS NOT NULL AND bro_fe2_disc *= dfa.dfa_code)
OR (bro_fe1_disc IS NULL AND bro_fe2_disc IS NULL AND dfa.dfa_code = 0 )) |
