Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V |
SELECT MI.DEAL_NUMBER
, MI.DEAL_TYPE
, DT.USER_DEAL_TYPE
, MI.TRANSACTION_NUMBER
, MI.LIMIT_CODE
, MI.AMOUNT
, MI.HCE_AMOUNT
, MI.PRODUCT_TYPE
, MI.COMPANY_CODE
, PA.SHORT_NAME
, MI.LIMIT_PARTY
, MI.AMOUNT_DATE
, MI.DEALER_CODE
, MI.COUNTRY_CODE
, FT.TERRITORY_SHORT_NAME
, MI.DEAL_SUBTYPE
, ST.USER_DEAL_SUBTYPE
, MI.PORTFOLIO_CODE
, MI.STATUS_CODE
, MI.CURRENCY
, MI.UTILISED_AMOUNT
, MI.HCE_UTILISED_AMOUNT
, MI.CROSS_REF_TO_OTHER_PARTY
, MI.LIMIT_TYPE
, MI.CURRENCY_COMBINATION
, MI.CONTRA_CCY
, MI.TRANSACTION_RATE
, MI.AMOUNT_INDIC
, MI.ACCOUNT_NO
FROM XTR_MIRROR_DDA_LIMIT_ROW MI
, XTR_DEAL_TYPES DT
, XTR_DEAL_SUBTYPES ST
, XTR_PARTIES_V PA
, FND_TERRITORIES_VL FT
WHERE MI.COMPANY_CODE = PA.PARTY_CODE
AND DT.DEAL_TYPE = MI.DEAL_TYPE
AND ST.DEAL_TYPE = MI.DEAL_TYPE
AND ST.DEAL_SUBTYPE = MI.DEAL_SUBTYPE
AND FT.TERRITORY_CODE (+) = MI.COUNTRY_CODE
AND (MI.AMOUNT_DATE>=TRUNC(SYSDATE) OR MI.DEAL_TYPE IN ('ONC'
, 'CA'
, 'IG'
, 'STOCK'))
AND MI.DEAL_TYPE <> 'EXP'