VIEW: APPS.XTR_BIS_MIRROR_DDA_LIMIT_ROW_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'