View: XTR_LINKED_TRANSACTIONS_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	APPS.XTR_LINKED_TRANSACTIONS_V

View Text

SELECT A.DEAL_LINKING_CODE
, A.DEAL_NUMBER DEAL_NUM
, A.TRANSACTION_NUMBER TRANS_NUM
, A.CPARTY_CODE
, A.CLIENT_CODE
, A.COMPANY_CODE
, A.DEAL_TYPE
, DT.USER_DEAL_TYPE
, A.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, A.PRODUCT_TYPE
, A.DEAL_DATE
, A.CURRENCY CURRENCY_BUY
, ' ' CURRENCY_SELL
, A.UPDATED_BY
, A.UPDATED_ON
FROM XTR_ROLLOVER_TRANSACTIONS_V A
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
WHERE A.DEAL_TYPE = 'ONC'
AND A.STATUS_CODE <> 'CANCELLED'
AND A.DEAL_LINKING_CODE IS NOT NULL
AND A.DEAL_TYPE = DT.DEAL_TYPE
AND (A.DEAL_TYPE = ST.DEAL_TYPE
AND A.DEAL_SUBTYPE = ST.DEAL_SUBTYPE) UNION ALL SELECT B.DEAL_LINKING_CODE
, B.DEAL_NO DEAL_NUM
, B.TRANSACTION_NO TRANS_NUM
, B.CPARTY_CODE
, B.CLIENT_CODE
, B.COMPANY_CODE
, B.DEAL_TYPE
, DT1.USER_DEAL_TYPE
, B.DEAL_SUBTYPE
, ST1.USER_DEAL_SUBTYPE
, B.PRODUCT_TYPE
, B.DEAL_DATE
, NVL(B.CURRENCY_BUY
, B.CURRENCY) CURRENCY_BUY
, B.CURRENCY_SELL
, B.UPDATED_BY
, B.UPDATED_ON
FROM XTR_DEALS_V B
, XTR_DEAL_TYPES DT1
, XTR_DEAL_SUBTYPES ST1
WHERE B.DEAL_TYPE NOT IN('ONC'
, 'CMF')
AND B.STATUS_CODE <> 'CANCELLED'
AND B.DEAL_LINKING_CODE IS NOT NULL
AND B.DEAL_TYPE = DT1.DEAL_TYPE
AND (B.DEAL_TYPE = ST1.DEAL_TYPE
AND B.DEAL_SUBTYPE = ST1.DEAL_SUBTYPE) UNION ALL SELECT B.DEAL_LINK_CODE
, 0 DEAL_NUM
, B.TRANSACTION_NUMBER TRANS_NUM
, B.THIRDPARTY_CODE
, ' ' CLIENT_CODE
, B.COMPANY_CODE
, B.DEAL_TYPE
, DT1.USER_DEAL_TYPE
, B.DEAL_SUBTYPE
, ST1.USER_DEAL_SUBTYPE
, ' ' PRODUCT_TYPE
, B.VALUE_DATE
, B.CURRENCY CURRENCY_BUY
, ' ' CURRENCY_SELL
, B.UPDATED_BY
, B.UPDATED_ON
FROM XTR_EXPOSURE_TRANSACTIONS_V B
, XTR_DEAL_TYPES DT1
, XTR_DEAL_SUBTYPES ST1
WHERE B.STATUS_CODE <> 'CANCELLED'
AND B.DEAL_LINK_CODE IS NOT NULL
AND B.DEAL_TYPE = DT1.DEAL_TYPE
AND (B.DEAL_TYPE = ST1.DEAL_TYPE
AND B.DEAL_SUBTYPE = ST1.DEAL_SUBTYPE) UNION ALL SELECT G.DEAL_LINKING_CODE
, G.DEAL_NUMBER
, G.TRANSACTION_NUMBER
, G.PARTY_CODE
, TO_CHAR(NULL) CLIENT_CODE
, G.COMPANY_CODE
, G.DEAL_TYPE
, DT1.USER_DEAL_TYPE
, DECODE(SIGN(G.BALANCE_OUT)
, -1
, 'FUND'
, 'INVEST') DEAL_SUBTYPE
, ST1.USER_DEAL_SUBTYPE
, G.PRODUCT_TYPE
, G.TRANSFER_DATE
, G.CURRENCY CURRENCY_BUY
, TO_CHAR(NULL) CURRENCY_SELL
, G.UPDATED_BY
, G.UPDATED_ON
FROM XTR_INTERGROUP_TRANSFERS G
, XTR_DEAL_TYPES DT1
, XTR_DEAL_SUBTYPES ST1
WHERE G.DEAL_LINKING_CODE IS NOT NULL
AND G.DEAL_TYPE = DT1.DEAL_TYPE
AND (G.DEAL_TYPE = ST1.DEAL_TYPE
AND DECODE(SIGN(G.BALANCE_OUT)
, -1
, 'FUND'
, 'INVEST') = ST1.DEAL_SUBTYPE)

Columns