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
| SELECT FOND.ID_FUNDS as 'FOND',
ANNEE_FOND.ID_YEAR AS 'ANNEE',
INVEST.ID_INVESTMENT AS 'INVEST',
LISTING.ID_LISTING AS 'LISTING',
EXPOSURE.ID_EXPOSURE AS 'EXPOSURE',
EXPOTYPE.ID_EXPOSURE_TYPE AS 'EXPO TYPE',
DERIV.ID_DERIVATIVES AS 'DERIV',
DERIVTYPE.ID_DERIVATIVES_TYPE AS 'DERIV TYPE',
UNDER.ID_UNDERLYING AS 'UNDER',
UNDERTYPE.ID_UNDERLYING_TYPE AS 'UNDER TYPE',
SHORT.ID_SHORT_LONG AS 'SHORT',
SHORTTYPE.ID_SHORT_LONG_TYPE AS 'SHORT TYPE',
PUT.ID_PUT_CALL AS 'PUT CALL',
PUTTYPE.ID_PUT_CALL_TYPE AS 'PUT CALL TYPE'
FROM
(((((((((((((COM_USER.FUNDS AS FOND LEFT JOIN COM_USER.FUNDS_YEAR AS ANNEE_FOND ON FOND.ID_FUNDS = ANNEE_FOND.ID_FUNDS)
LEFT JOIN COM_USER.INVESTMENT AS INVEST ON ANNEE_FOND.ID_YEAR = INVEST.ID_YEAR)
LEFT JOIN COM_USER.LISTING_STATUS AS LISTING ON INVEST.ID_INVESTMENT = LISTING.ID_INVESTMENT)
LEFT JOIN COM_USER.EXPOSURE AS EXPOSURE ON LISTING.ID_LISTING = EXPOSURE.ID_LISTING)
LEFT JOIN COM_USER.EXPOSURE_TYPE AS EXPOTYPE ON EXPOSURE.ID_EXPOSURE_TYPE = EXPOTYPE.ID_EXPOSURE_TYPE)
LEFT JOIN COM_USER.DERIVATIVES AS DERIV ON EXPOSURE.ID_EXPOSURE = DERIV.ID_EXPOSURE)
LEFT JOIN COM_USER.DERIVATIVES_TYPE AS DERIVTYPE
ON (EXPOTYPE.ID_EXPOSURE_TYPE = DERIVTYPE.ID_EXPOSURE_TYPE
AND DERIV.ID_DERIVATIVES_TYPE = DERIVTYPE.ID_DERIVATIVES_TYPE))
LEFT JOIN COM_USER.UNDERLYING AS UNDER ON DERIV.ID_DERIVATIVES = UNDER.ID_DERIVATIVES)
LEFT JOIN COM_USER.UNDERLYING_TYPE AS UNDERTYPE ON UNDERTYPE.ID_UNDERLYING_TYPE = UNDER.ID_UNDERLYING_TYPE)
LEFT JOIN COM_USER.SHORT_LONG AS SHORT ON UNDER.ID_UNDERLYING = SHORT.ID_UNDERLYING)
LEFT JOIN COM_USER.SHORT_LONG_TYPE AS SHORTTYPE
ON (SHORT.ID_SHORT_LONG_TYPE = SHORTTYPE.ID_SHORT_LONG_TYPE
AND SHORTTYPE.ID_UNDERLYING_TYPE = UNDERTYPE.ID_UNDERLYING_TYPE))
LEFT JOIN COM_USER.PUT_CALL_TYPE AS PUTTYPE
ON SHORTTYPE.ID_SHORT_LONG_TYPE = PUTTYPE.ID_SHORT_LONG_TYPE))
LEFT JOIN COM_USER.PUT_CALL AS PUT
ON (SHORT.ID_SHORT_LONG = PUT.ID_SHORT_LONG
AND PUTTYPE.ID_PUT_CALL_TYPE = PUT.ID_PUT_CALL_TYPE)
WHERE FOND.ID_FUNDS = @NUM_FOND
AND FOND.ID_FUNDS = ANNEE_FOND.ID_FUNDS
AND ANNEE_FOND.ID_YEAR = (SELECT ID_YEAR
FROM COM_USER.FUNDS_YEAR
WHERE ID_FUNDS = @NUM_FOND
AND ANNEE = @NUM_ANNEE) |
Partager