<?query --
SELECT
T1.Q_001_F_000RRef,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58884RRef ELSE CAST(NULL AS BINARY(16)) END,
T1.Q_001_F_003RRef,
T1.Q_001_F_004RRef,
T1.Q_001_F_006_,
T1.Q_001_F_013RRef,
T1.Q_001_F_016_,
T1.Q_001_F_017RRef,
T1.Q_001_F_018_,
T1.Q_001_F_019RRef,
(CAST(T1.Q_001_F_006_ AS NUMERIC(24, 3)) * CAST(T1.Q_001_F_016_ AS NUMERIC(13, 2))),
T10.Fld59047RRef,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58907 ELSE CAST(NULL AS NUMERIC(7, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49673RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58944RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T15._Fld58802RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld59006RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49705RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58876RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58956RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58955RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58909RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T16._Fld58988RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58918RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58910RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58938RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58937RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58940RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58882RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58883RRef ELSE CAST(NULL AS BINARY(16)) END,
T1.Q_001_F_036_,
(T1.Q_001_F_039_ * 1.0),
T1.Q_001_F_040RRef,
(CAST(T1.Q_001_F_006_ AS NUMERIC(24, 3)) * CAST(T1.Q_001_F_039_ AS NUMERIC(13, 2))),
T1.Q_001_F_041_,
T1.Q_001_F_042_,
CASE WHEN T1.Q_001_F_030_TYPE = 0x08 AND T1.Q_001_F_030_RTRef = 0x000002F0 THEN T17._Fld7939RRef WHEN T1.Q_001_F_030_TYPE = 0x08 AND T1.Q_001_F_030_RTRef = 0x000002EF THEN T18._Fld7741RRef WHEN T1.Q_001_F_030_TYPE = 0x08 AND T1.Q_001_F_030_RTRef = 0x000002E6 THEN T19._Fld6931RRef ELSE CAST(NULL AS BINARY(16)) END,
@P1,
T1.Q_001_F_043RRef,
T1.Q_001_F_045_,
CASE WHEN (CASE WHEN T1.Q_001_F_019RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F) THEN T1.Q_001_F_019RRef ELSE T1.Q_001_F_019RRef END,
CASE WHEN (CASE WHEN T1.Q_001_F_019RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F) THEN T20._Description ELSE CAST(NULL AS NVARCHAR(10)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_019RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F) THEN 0.0 ELSE -1.0 END,
CASE WHEN CASE WHEN T1.Q_001_F_019RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F THEN T20._Description ELSE CAST(NULL AS NVARCHAR(10)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_017RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F) THEN T1.Q_001_F_017RRef ELSE T1.Q_001_F_017RRef END,
CASE WHEN (CASE WHEN T1.Q_001_F_017RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F) THEN T21._Description ELSE CAST(NULL AS NVARCHAR(10)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_017RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F) THEN 0.0 ELSE -1.0 END,
CASE WHEN CASE WHEN T1.Q_001_F_017RRef IS NOT NULL THEN 0x0000002F END = 0x0000002F THEN T21._Description ELSE CAST(NULL AS NVARCHAR(10)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49673RRef ELSE CAST(NULL AS BINARY(16)) END,
T22._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T23._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58876RRef ELSE CAST(NULL AS BINARY(16)) END,
T24._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T25._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
T1.Q_001_F_043RRef,
T26._Description,
T26._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58909RRef ELSE CAST(NULL AS BINARY(16)) END,
T27._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T16._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T28._EnumOrder ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58937RRef ELSE CAST(NULL AS BINARY(16)) END,
T29._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T30._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58938RRef ELSE CAST(NULL AS BINARY(16)) END,
T31._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T32._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58918RRef ELSE CAST(NULL AS BINARY(16)) END,
T33._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T34._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116) THEN T1.Q_001_F_003RRef ELSE T1.Q_001_F_003RRef END,
CASE WHEN (CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116) THEN T14._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116) THEN 5.0 ELSE -1.0 END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49663 ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58890 ELSE CAST(NULL AS NUMERIC(10, 1)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58891 ELSE CAST(NULL AS NUMERIC(10, 1)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58904 ELSE CAST(NULL AS DATETIME) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58897RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58897RRef ELSE CAST(NULL AS BINARY(16)) END,
T35._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T36._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld63397RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld63397RRef ELSE CAST(NULL AS BINARY(16)) END,
T37._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T38._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49727RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49727RRef ELSE CAST(NULL AS BINARY(16)) END,
T39._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T40._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58878RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58878RRef ELSE CAST(NULL AS BINARY(16)) END,
T41._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T42._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58879RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58879RRef ELSE CAST(NULL AS BINARY(16)) END,
T43._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T44._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58948RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58948RRef ELSE CAST(NULL AS BINARY(16)) END,
T45._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T46._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49691RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49691RRef ELSE CAST(NULL AS BINARY(16)) END,
T47._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T48._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58924RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58924RRef ELSE CAST(NULL AS BINARY(16)) END,
T49._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T50._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58930RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58930RRef ELSE CAST(NULL AS BINARY(16)) END,
T51._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T52._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58950RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T53._EnumOrder ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58896 ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58951RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58951RRef ELSE CAST(NULL AS BINARY(16)) END,
T54._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T55._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58905RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T56._EnumOrder ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58942RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58942RRef ELSE CAST(NULL AS BINARY(16)) END,
T57._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T58._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49706RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49706RRef ELSE CAST(NULL AS BINARY(16)) END,
T59._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T60._Description ELSE CAST(NULL AS NVARCHAR(150)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T61._Fld58812 ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58947RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58947RRef ELSE CAST(NULL AS BINARY(16)) END,
T62._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T63._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58957RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T64._EnumOrder ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49721RRef ELSE CAST(NULL AS BINARY(16)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49721RRef ELSE CAST(NULL AS BINARY(16)) END,
T65._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T66._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58944RRef ELSE CAST(NULL AS BINARY(16)) END,
T67._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T68._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58884RRef ELSE CAST(NULL AS BINARY(16)) END,
T69._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T70._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_013RRef IS NOT NULL THEN 0x0000021D END = 0x0000021D) THEN T1.Q_001_F_013RRef ELSE T1.Q_001_F_013RRef END,
CASE WHEN (CASE WHEN T1.Q_001_F_013RRef IS NOT NULL THEN 0x0000021D END = 0x0000021D) THEN T71._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_013RRef IS NOT NULL THEN 0x0000021D END = 0x0000021D) THEN 15.0 ELSE -1.0 END,
CASE WHEN CASE WHEN T1.Q_001_F_013RRef IS NOT NULL THEN 0x0000021D END = 0x0000021D THEN T71._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58883RRef ELSE CAST(NULL AS BINARY(16)) END,
T72._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T73._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld59006RRef ELSE CAST(NULL AS BINARY(16)) END,
T74._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T75._Description ELSE CAST(NULL AS NVARCHAR(25)) END,
T76._EnumOrder,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58955RRef ELSE CAST(NULL AS BINARY(16)) END,
T77._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T78._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58956RRef ELSE CAST(NULL AS BINARY(16)) END,
T79._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T80._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58882RRef ELSE CAST(NULL AS BINARY(16)) END,
T81._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T82._Description ELSE CAST(NULL AS NVARCHAR(60)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58940RRef ELSE CAST(NULL AS BINARY(16)) END,
T83._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T84._Description ELSE CAST(NULL AS NVARCHAR(50)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T85._EnumOrder ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49705RRef ELSE CAST(NULL AS BINARY(16)) END,
T86._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T87._Description ELSE CAST(NULL AS NVARCHAR(100)) END,
T88._Description,
T88._Fld59007,
T88._Description,
CASE WHEN (CASE WHEN T1.Q_001_F_004RRef IS NOT NULL THEN 0x00000276 END = 0x00000276) THEN T1.Q_001_F_004RRef ELSE T1.Q_001_F_004RRef END,
CASE WHEN (CASE WHEN T1.Q_001_F_004RRef IS NOT NULL THEN 0x00000276 END = 0x00000276) THEN T89._Description ELSE CAST(NULL AS NVARCHAR(150)) END,
CASE WHEN (CASE WHEN T1.Q_001_F_004RRef IS NOT NULL THEN 0x00000276 END = 0x00000276) THEN 24.0 ELSE -1.0 END,
CASE WHEN CASE WHEN T1.Q_001_F_004RRef IS NOT NULL THEN 0x00000276 END = 0x00000276 THEN T89._Fld58858 ELSE CAST(NULL AS NUMERIC(10, 0)) END,
CASE WHEN CASE WHEN T1.Q_001_F_004RRef IS NOT NULL THEN 0x00000276 END = 0x00000276 THEN T89._Description ELSE CAST(NULL AS NVARCHAR(150)) END,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58910RRef ELSE CAST(NULL AS BINARY(16)) END,
T90._Description,
CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T91._Description ELSE CAST(NULL AS NVARCHAR(25)) END
FROM (SELECT
T2._Q_001_F_001RRef AS Q_001_F_000RRef,
T3._Fld58884RRef AS Q_001_F_001RRef,
T2._Q_001_F_002RRef AS Q_001_F_002RRef,
T2._Q_001_F_000RRef AS Q_001_F_003RRef,
T2._Q_001_F_003RRef AS Q_001_F_004RRef,
T2._Q_001_F_004RRef AS Q_001_F_005RRef,
T2._Q_001_F_005 AS Q_001_F_006_,
T2._Q_001_F_006 AS Q_001_F_007_,
T2._Q_001_F_007 AS Q_001_F_008_,
T2._Q_001_F_008 AS Q_001_F_009_,
T2._Q_001_F_009 AS Q_001_F_010_,
T2._Q_001_F_010 AS Q_001_F_011_,
T2._Q_001_F_011RRef AS Q_001_F_012RRef,
T2._Q_001_F_012RRef AS Q_001_F_013RRef,
CASE WHEN T2._Q_001_F_019_TYPE = 0x03 THEN T2._Q_001_F_019_N END AS Q_001_F_014_,
T2._Q_001_F_020_TYPE AS Q_001_F_015_TYPE,
T2._Q_001_F_020_L AS Q_001_F_015_L,
T2._Q_001_F_020_N AS Q_001_F_015_N,
T2._Q_001_F_020_T AS Q_001_F_015_T,
T2._Q_001_F_020_S AS Q_001_F_015_S,
T2._Q_001_F_020_B AS Q_001_F_015_B,
T2._Q_001_F_020_RTRef AS Q_001_F_015_RTRef,
T2._Q_001_F_020_RRRef AS Q_001_F_015_RRRef,
T2._Q_001_F_021 AS Q_001_F_016_,
T2._Q_001_F_022RRef AS Q_001_F_017RRef,
T2._Q_001_F_023 AS Q_001_F_018_,
T2._Q_001_F_024RRef AS Q_001_F_019RRef,
CAST(NULL AS BINARY(16)) AS Q_001_F_020RRef,
CAST(0.0 AS NUMERIC(10, 2)) AS Q_001_F_021_,
CAST(0.0 AS NUMERIC(7, 0)) AS Q_001_F_022_,
0.0 AS Q_001_F_023_,
0.0 AS Q_001_F_024_,
CAST(0.0 AS NUMERIC(10, 2)) AS Q_001_F_025_,
CAST(0.0 AS NUMERIC(12, 0)) AS Q_001_F_026_,
CAST(NULL AS BINARY(16)) AS Q_001_F_027RRef,
CAST(NULL AS BINARY(16)) AS Q_001_F_028RRef,
CAST(NULL AS BINARY(16)) AS Q_001_F_029RRef,
T2._Q_001_F_013_TYPE AS Q_001_F_030_TYPE,
T2._Q_001_F_013_RTRef AS Q_001_F_030_RTRef,
T2._Q_001_F_013_RRRef AS Q_001_F_030_RRRef,
CASE WHEN T2._Q_001_F_019_TYPE = 0x03 THEN T2._Q_001_F_019_N END AS Q_001_F_031_,
CASE WHEN T2._Q_001_F_020_TYPE = 0x03 THEN T2._Q_001_F_020_N END AS Q_001_F_032_,
T2._Q_001_F_025_TYPE AS Q_001_F_033_TYPE,
T2._Q_001_F_025_L AS Q_001_F_033_L,
T2._Q_001_F_025_N AS Q_001_F_033_N,
T2._Q_001_F_025_T AS Q_001_F_033_T,
T2._Q_001_F_025_S AS Q_001_F_033_S,
T2._Q_001_F_025_B AS Q_001_F_033_B,
T2._Q_001_F_025_RTRef AS Q_001_F_033_RTRef,
T2._Q_001_F_025_RRRef AS Q_001_F_033_RRRef,
T2._Q_001_F_026_TYPE AS Q_001_F_034_TYPE,
T2._Q_001_F_026_L AS Q_001_F_034_L,
T2._Q_001_F_026_N AS Q_001_F_034_N,
T2._Q_001_F_026_T AS Q_001_F_034_T,
T2._Q_001_F_026_S AS Q_001_F_034_S,
T2._Q_001_F_026_B AS Q_001_F_034_B,
T2._Q_001_F_026_RTRef AS Q_001_F_034_RTRef,
T2._Q_001_F_026_RRRef AS Q_001_F_034_RRRef,
T2._Q_001_F_027_TYPE AS Q_001_F_035_TYPE,
T2._Q_001_F_027_L AS Q_001_F_035_L,
T2._Q_001_F_027_N AS Q_001_F_035_N,
T2._Q_001_F_027_T AS Q_001_F_035_T,
T2._Q_001_F_027_S AS Q_001_F_035_S,
T2._Q_001_F_027_B AS Q_001_F_035_B,
T2._Q_001_F_027_RTRef AS Q_001_F_035_RTRef,
T2._Q_001_F_027_RRRef AS Q_001_F_035_RRRef,
T2._Q_001_F_014 AS Q_001_F_036_,
T2._Q_001_F_015 AS Q_001_F_037_,
T2._Q_001_F_016 AS Q_001_F_038_,
T2._Q_001_F_028 AS Q_001_F_039_,
T2._Q_001_F_029RRef AS Q_001_F_040RRef,
T2._Q_001_F_017 AS Q_001_F_041_,
T2._Q_001_F_018 AS Q_001_F_042_,
T2._Q_001_F_030RRef AS Q_001_F_043RRef,
@P2 AS Q_001_F_044_,
T2._Q_001_F_031 AS Q_001_F_045_
FROM #tt13 T2 WITH(NOLOCK)
LEFT OUTER JOIN dbo._Reference278X1 T3
ON (T2._Q_001_F_000RRef = T3._IDRRef) AND (T3._Fld2118 = @P3)
UNION ALL SELECT
T6._Fld58880RRef AS Fld58880RRef,
T6._Fld58884RRef AS Fld58884RRef,
T6._Fld58879RRef AS Fld58879RRef,
T4._Q_001_F_000RRef AS Q_001_F_000RRef,
T5._Q_001_F_001RRef AS Q_001_F_001RRef,
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(29, 3)),
CAST(0.0 AS NUMERIC(7, 0)),
CAST(0.0 AS NUMERIC(7, 0)),
CAST(0.0 AS NUMERIC(7, 0)),
CAST(0.0 AS NUMERIC(10, 6)),
CAST(0.0 AS NUMERIC(15, 3)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
0.0,
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(15, 2)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(15, 2)),
CAST(NULL AS BINARY(16)),
T4._Q_001_F_001RRef AS Q_001_F_001RRef,
T4._Q_001_F_002 AS Q_001_F_002_,
T4._Q_001_F_003 AS Q_001_F_003_,
T4._Q_001_F_004 AS Q_001_F_004_,
T4._Q_001_F_005 AS Q_001_F_005_,
T4._Q_001_F_006 AS Q_001_F_006_,
T4._Q_001_F_007 AS Q_001_F_007_,
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
0.0,
0.0,
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(27, 3)),
CAST(0.0 AS NUMERIC(27, 3)),
CAST(0.0 AS NUMERIC(28, 3)),
CAST(NULL AS NUMERIC(15, 2)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS NUMERIC(15, 2)),
CAST(NULL AS NUMERIC(21, 2)),
T7._Q_001_F_003RRef AS Q_001_F_003RRef,
CAST(@P4 AS NVARCHAR(23)),
CAST(0.0 AS NUMERIC(15, 3))
FROM #tt16 T4 WITH(NOLOCK)
LEFT OUTER JOIN #tt20 T5 WITH(NOLOCK)
ON (T4._Q_001_F_000RRef = T5._Q_001_F_000RRef)
LEFT OUTER JOIN dbo._Reference278X1 T6
ON (T4._Q_001_F_000RRef = T6._IDRRef) AND (T6._Fld2118 = @P5)
LEFT OUTER JOIN #tt3 T7 WITH(NOLOCK)
ON (T6._Fld58884RRef = T7._Q_001_F_000RRef)
WHERE ((T7._Q_001_F_003RRef IN (@P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14, @P15, @P16, @P17, @P18, @P19, @P20, @P21, @P22, @P23, @P24, @P25, @P26, @P27, @P28, @P29)))
UNION ALL SELECT
T8._Q_001_F_001RRef AS Q_001_F_001RRef,
T8._Q_001_F_002RRef AS Q_001_F_002RRef,
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS NUMERIC(29, 3)),
CAST(NULL AS NUMERIC(7, 0)),
CAST(NULL AS NUMERIC(7, 0)),
CAST(NULL AS NUMERIC(7, 0)),
CAST(NULL AS NUMERIC(10, 6)),
CAST(NULL AS NUMERIC(15, 3)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
0.0,
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(15, 2)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(15, 2)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(10, 2)),
CAST(0.0 AS NUMERIC(7, 0)),
0.0,
0.0,
CAST(0.0 AS NUMERIC(10, 2)),
CAST(0.0 AS NUMERIC(12, 0)),
T8._Q_001_F_000RRef AS Q_001_F_000RRef,
T8._Q_001_F_003RRef AS Q_001_F_003RRef,
T8._Q_001_F_004RRef AS Q_001_F_004RRef,
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
0.0,
0.0,
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS BINARY(1)),
CAST(NULL AS NUMERIC(38,8)),
CAST(NULL AS DATETIME),
CAST(NULL AS NVARCHAR),
CAST(NULL AS VARBINARY),
CAST(NULL AS BINARY(4)),
CAST(NULL AS BINARY(16)),
CAST(0.0 AS NUMERIC(27, 3)),
CAST(0.0 AS NUMERIC(27, 3)),
CAST(0.0 AS NUMERIC(28, 3)),
CAST(NULL AS NUMERIC(15, 2)),
CAST(NULL AS BINARY(16)),
CAST(NULL AS NUMERIC(15, 2)),
CAST(NULL AS NUMERIC(21, 2)),
T9._Fld59014RRef AS Fld59014RRef,
CAST(@P30 AS NVARCHAR(23)),
CAST(0.0 AS NUMERIC(15, 3))
FROM #tt19 T8 WITH(NOLOCK)
LEFT OUTER JOIN dbo._Reference541X1 T9
ON (T8._Q_001_F_002RRef = T9._IDRRef) AND (T9._Fld2118 = @P31)
WHERE ((T9._Fld59014RRef IN (@P32, @P33, @P34, @P35, @P36, @P37, @P38, @P39, @P40, @P41, @P42, @P43, @P44, @P45, @P46, @P47, @P48, @P49, @P50, @P51, @P52, @P53, @P54, @P55)))) T1
LEFT OUTER JOIN (SELECT
T13._Fld59045RRef AS Fld59045RRef,
T13._Fld59046RRef AS Fld59046RRef,
T13._Fld59047RRef AS Fld59047RRef
FROM (SELECT
T12._Fld59045RRef AS Fld59045RRef,
T12._Fld59046RRef AS Fld59046RRef,
MAX(T12._Period) AS MAXPERIOD_
FROM dbo._InfoRg59044X1 T12
GROUP BY T12._Fld59045RRef,
T12._Fld59046RRef) T11
INNER JOIN dbo._InfoRg59044X1 T13
ON T11.Fld59045RRef = T13._Fld59045RRef AND T11.Fld59046RRef = T13._Fld59046RRef AND T11.MAXPERIOD_ = T13._Period) T10
ON ((T1.Q_001_F_003RRef = T10.Fld59045RRef) AND (T1.Q_001_F_002RRef = T10.Fld59046RRef))
LEFT OUTER JOIN dbo._Reference278X1 T14
ON (T1.Q_001_F_003RRef = T14._IDRRef) AND (T14._Fld2118 = @P56)
LEFT OUTER JOIN dbo._Reference58745X1 T15
ON T14._Fld58873RRef = T15._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T16
ON T14._Fld58909RRef = T16._IDRRef
LEFT OUTER JOIN dbo._Document752X1 T17
ON (T1.Q_001_F_030_TYPE = 0x08 AND T1.Q_001_F_030_RTRef = 0x000002F0 AND T1.Q_001_F_030_RRRef = T17._IDRRef) AND (T17._Fld2118 = @P57)
LEFT OUTER JOIN dbo._Document751 T18
ON (T1.Q_001_F_030_TYPE = 0x08 AND T1.Q_001_F_030_RTRef = 0x000002EF AND T1.Q_001_F_030_RRRef = T18._IDRRef) AND (T18._Fld2118 = @P58)
LEFT OUTER JOIN dbo._Document742 T19
ON (T1.Q_001_F_030_TYPE = 0x08 AND T1.Q_001_F_030_RTRef = 0x000002E6 AND T1.Q_001_F_030_RRRef = T19._IDRRef) AND (T19._Fld2118 = @P59)
LEFT OUTER JOIN dbo._Reference47 T20
ON (T1.Q_001_F_019RRef = T20._IDRRef) AND (T20._Fld2118 = @P60)
LEFT OUTER JOIN dbo._Reference47 T21
ON (T1.Q_001_F_017RRef = T21._IDRRef) AND (T21._Fld2118 = @P61)
LEFT OUTER JOIN dbo._Reference84X1 T22
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49673RRef ELSE CAST(NULL AS BINARY(16)) END = T22._IDRRef) AND (T22._Fld2118 = @P62)
LEFT OUTER JOIN dbo._Reference84X1 T23
ON (T14._Fld49673RRef = T23._IDRRef) AND (T23._Fld2118 = @P63)
LEFT OUTER JOIN dbo._Reference58735X1 T24
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58876RRef ELSE CAST(NULL AS BINARY(16)) END = T24._IDRRef
LEFT OUTER JOIN dbo._Reference58735X1 T25
ON T14._Fld58876RRef = T25._IDRRef
LEFT OUTER JOIN dbo._Reference250X1 T26
ON (T1.Q_001_F_043RRef = T26._IDRRef) AND (T26._Fld2118 = @P64)
LEFT OUTER JOIN dbo._Reference58740X1 T27
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58909RRef ELSE CAST(NULL AS BINARY(16)) END = T27._IDRRef
LEFT OUTER JOIN dbo._Enum58987X1 T28
ON T16._Fld58988RRef = T28._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T29
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58937RRef ELSE CAST(NULL AS BINARY(16)) END = T29._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T30
ON T14._Fld58937RRef = T30._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T31
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58938RRef ELSE CAST(NULL AS BINARY(16)) END = T31._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T32
ON T14._Fld58938RRef = T32._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T33
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58918RRef ELSE CAST(NULL AS BINARY(16)) END = T33._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T34
ON T14._Fld58918RRef = T34._IDRRef
LEFT OUTER JOIN dbo._Reference58733X1 T35
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58897RRef ELSE CAST(NULL AS BINARY(16)) END = T35._IDRRef
LEFT OUTER JOIN dbo._Reference58733X1 T36
ON T14._Fld58897RRef = T36._IDRRef
LEFT OUTER JOIN dbo._Reference626 T37
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld63397RRef ELSE CAST(NULL AS BINARY(16)) END = T37._IDRRef) AND (T37._Fld2118 = @P65)
LEFT OUTER JOIN dbo._Reference626 T38
ON (T14._Fld63397RRef = T38._IDRRef) AND (T38._Fld2118 = @P66)
LEFT OUTER JOIN dbo._Reference234X1 T39
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49727RRef ELSE CAST(NULL AS BINARY(16)) END = T39._IDRRef) AND (T39._Fld2118 = @P67)
LEFT OUTER JOIN dbo._Reference234X1 T40
ON (T14._Fld49727RRef = T40._IDRRef) AND (T40._Fld2118 = @P68)
LEFT OUTER JOIN dbo._Reference234X1 T41
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58878RRef ELSE CAST(NULL AS BINARY(16)) END = T41._IDRRef) AND (T41._Fld2118 = @P69)
LEFT OUTER JOIN dbo._Reference234X1 T42
ON (T14._Fld58878RRef = T42._IDRRef) AND (T42._Fld2118 = @P70)
LEFT OUTER JOIN dbo._Reference234X1 T43
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58879RRef ELSE CAST(NULL AS BINARY(16)) END = T43._IDRRef) AND (T43._Fld2118 = @P71)
LEFT OUTER JOIN dbo._Reference234X1 T44
ON (T14._Fld58879RRef = T44._IDRRef) AND (T44._Fld2118 = @P72)
LEFT OUTER JOIN dbo._Reference58867X1 T45
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58948RRef ELSE CAST(NULL AS BINARY(16)) END = T45._IDRRef
LEFT OUTER JOIN dbo._Reference58867X1 T46
ON T14._Fld58948RRef = T46._IDRRef
LEFT OUTER JOIN dbo._Reference250X1 T47
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49691RRef ELSE CAST(NULL AS BINARY(16)) END = T47._IDRRef) AND (T47._Fld2118 = @P73)
LEFT OUTER JOIN dbo._Reference250X1 T48
ON (T14._Fld49691RRef = T48._IDRRef) AND (T48._Fld2118 = @P74)
LEFT OUTER JOIN dbo._Reference58740X1 T49
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58924RRef ELSE CAST(NULL AS BINARY(16)) END = T49._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T50
ON T14._Fld58924RRef = T50._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T51
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58930RRef ELSE CAST(NULL AS BINARY(16)) END = T51._IDRRef
LEFT OUTER JOIN dbo._Reference58740X1 T52
ON T14._Fld58930RRef = T52._IDRRef
LEFT OUTER JOIN dbo._Enum59210X1 T53
ON T14._Fld58950RRef = T53._IDRRef
LEFT OUTER JOIN dbo._Reference58869X1 T54
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58951RRef ELSE CAST(NULL AS BINARY(16)) END = T54._IDRRef
LEFT OUTER JOIN dbo._Reference58869X1 T55
ON T14._Fld58951RRef = T55._IDRRef
LEFT OUTER JOIN dbo._Enum58762X1 T56
ON T14._Fld58905RRef = T56._IDRRef
LEFT OUTER JOIN dbo._Reference58872X1 T57
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58942RRef ELSE CAST(NULL AS BINARY(16)) END = T57._IDRRef
LEFT OUTER JOIN dbo._Reference58872X1 T58
ON T14._Fld58942RRef = T58._IDRRef
LEFT OUTER JOIN dbo._Reference281 T59
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49706RRef ELSE CAST(NULL AS BINARY(16)) END = T59._IDRRef) AND (T59._Fld2118 = @P75)
LEFT OUTER JOIN dbo._Reference281 T60
ON (T14._Fld49706RRef = T60._IDRRef) AND (T60._Fld2118 = @P76)
LEFT OUTER JOIN dbo._Reference58747X1 T61
ON T14._Fld58874RRef = T61._IDRRef
LEFT OUTER JOIN dbo._Reference58748X1 T62
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58947RRef ELSE CAST(NULL AS BINARY(16)) END = T62._IDRRef
LEFT OUTER JOIN dbo._Reference58748X1 T63
ON T14._Fld58947RRef = T63._IDRRef
LEFT OUTER JOIN dbo._Enum58764X1 T64
ON T14._Fld58957RRef = T64._IDRRef
LEFT OUTER JOIN dbo._Reference633 T65
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49721RRef ELSE CAST(NULL AS BINARY(16)) END = T65._IDRRef) AND (T65._Fld2118 = @P77)
LEFT OUTER JOIN dbo._Reference633 T66
ON (T14._Fld49721RRef = T66._IDRRef) AND (T66._Fld2118 = @P78)
LEFT OUTER JOIN dbo._Reference626 T67
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58944RRef ELSE CAST(NULL AS BINARY(16)) END = T67._IDRRef) AND (T67._Fld2118 = @P79)
LEFT OUTER JOIN dbo._Reference626 T68
ON (T14._Fld58944RRef = T68._IDRRef) AND (T68._Fld2118 = @P80)
LEFT OUTER JOIN dbo._Reference541X1 T69
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58884RRef ELSE CAST(NULL AS BINARY(16)) END = T69._IDRRef) AND (T69._Fld2118 = @P81)
LEFT OUTER JOIN dbo._Reference541X1 T70
ON (T14._Fld58884RRef = T70._IDRRef) AND (T70._Fld2118 = @P82)
LEFT OUTER JOIN dbo._Reference541X1 T71
ON (T1.Q_001_F_013RRef = T71._IDRRef) AND (T71._Fld2118 = @P83)
LEFT OUTER JOIN dbo._Reference42X1 T72
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58883RRef ELSE CAST(NULL AS BINARY(16)) END = T72._IDRRef) AND (T72._Fld2118 = @P84)
LEFT OUTER JOIN dbo._Reference42X1 T73
ON (T14._Fld58883RRef = T73._IDRRef) AND (T73._Fld2118 = @P85)
LEFT OUTER JOIN dbo._Reference58990X1 T74
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld59006RRef ELSE CAST(NULL AS BINARY(16)) END = T74._IDRRef
LEFT OUTER JOIN dbo._Reference58990X1 T75
ON T14._Fld59006RRef = T75._IDRRef
LEFT OUTER JOIN dbo._Enum59043X1 T76
ON T10.Fld59047RRef = T76._IDRRef
LEFT OUTER JOIN dbo._Reference58744X1 T77
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58955RRef ELSE CAST(NULL AS BINARY(16)) END = T77._IDRRef
LEFT OUTER JOIN dbo._Reference58744X1 T78
ON T14._Fld58955RRef = T78._IDRRef
LEFT OUTER JOIN dbo._Reference58870X1 T79
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58956RRef ELSE CAST(NULL AS BINARY(16)) END = T79._IDRRef
LEFT OUTER JOIN dbo._Reference58870X1 T80
ON T14._Fld58956RRef = T80._IDRRef
LEFT OUTER JOIN dbo._Reference537 T81
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58882RRef ELSE CAST(NULL AS BINARY(16)) END = T81._IDRRef) AND (T81._Fld2118 = @P86)
LEFT OUTER JOIN dbo._Reference537 T82
ON (T14._Fld58882RRef = T82._IDRRef) AND (T82._Fld2118 = @P87)
LEFT OUTER JOIN dbo._Reference58871X1 T83
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58940RRef ELSE CAST(NULL AS BINARY(16)) END = T83._IDRRef
LEFT OUTER JOIN dbo._Reference58871X1 T84
ON T14._Fld58940RRef = T84._IDRRef
LEFT OUTER JOIN dbo._Enum58760X1 T85
ON T15._Fld58802RRef = T85._IDRRef
LEFT OUTER JOIN dbo._Reference569X1 T86
ON (CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld49705RRef ELSE CAST(NULL AS BINARY(16)) END = T86._IDRRef) AND (T86._Fld2118 = @P88)
LEFT OUTER JOIN dbo._Reference569X1 T87
ON (T14._Fld49705RRef = T87._IDRRef) AND (T87._Fld2118 = @P89)
LEFT OUTER JOIN dbo._Reference343X1 T88
ON (T1.Q_001_F_000RRef = T88._IDRRef) AND (T88._Fld2118 = @P90)
LEFT OUTER JOIN dbo._Reference630X1 T89
ON (T1.Q_001_F_004RRef = T89._IDRRef) AND (T89._Fld2118 = @P91)
LEFT OUTER JOIN dbo._Reference58741X1 T90
ON CASE WHEN CASE WHEN T1.Q_001_F_003RRef IS NOT NULL THEN 0x00000116 END = 0x00000116 THEN T14._Fld58910RRef ELSE CAST(NULL AS BINARY(16)) END = T90._IDRRef
LEFT OUTER JOIN dbo._Reference58741X1 T91
ON T14._Fld58910RRef = T91._IDRRef
--?>