[Home] [Help]
View: XTR_VALIDATE_TRANSACTIONS_V
Product: | XTR - Treasury |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 'TRANS' VALIDATE_TYPE
, A.DEAL_NUMBER DEAL_NUM
, A.TRANSACTION_NUMBER TRANS_NUM
, A.CPARTY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, A.DEAL_DATE
, A.DUAL_AUTHORISATION_BY
, A.DUAL_AUTHORISATION_ON FROM XTR_ROLLOVER_TRANSACTIONS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.DEAL_TYPE IN('ONC'
, 'CMF') AND A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE) UNION ALL SELECT 'DEAL' VALIDATE_TYPE
, A.DEAL_NO DEAL_NUM
, A.TRANSACTION_NO TRANS_NUM
, A.CPARTY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, A.DEAL_DATE
, A.DUAL_AUTHORISATION_BY
, A.DUAL_AUTHORISATION_ON FROM XTR_DEALS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.DEAL_TYPE NOT IN('ONC'
, 'CMF') AND A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE) UNION ALL SELECT 'SETTLE' VALIDATE_TYPE
, A.DEAL_NO DEAL_NUM
, A.TRANSACTION_NO TRANS_NUM
, A.CPARTY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, A.DEAL_DATE
, A.SETTLE_DUAL_AUTHORISATION_BY
, A.SETTLE_DUAL_AUTHORISATION_ON FROM XTR_DEALS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST WHERE A.DEAL_TYPE NOT IN('ONC'
, 'CMF') AND A.DUAL_AUTHORISATION_BY IS NOT NULL AND A.SETTLE_DATE IS NOT NULL AND A.DEAL_TYPE = DT.DEAL_TYPE AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE)
Columns
Name |
VALIDATE_TYPE |
DEAL_NUM |
TRANS_NUM |
CPARTY_CODE |
DEAL_TYPE |
USER_DEAL_TYPE |
DEAL_SUBTYPE |
USER_DEAL_SUBTYPE |
PRODUCT_TYPE |
DEAL_DATE |
DUAL_AUTHORISATION_BY |
DUAL_AUTHORISATION_ON |