VIEW: APPS.XTR_COMPANY_LIMITS_EXCL_FX_V

Source

View Text - Preformatted

SELECT a.COMPANY_CODE,a.LIMIT_CODE,a.NAME LIMIT_CODE_NAME, b.LIMIT_TYPE,b.NAME LIMIT_TYPE_NAME,b.FX_INVEST_FUND_TYPE from XTR_COMPANY_LIMITS a, XTR_LIMIT_TYPES b where a.AUTHORISED = 'Y' and a.LIMIT_TYPE = b.LIMIT_TYPE and b.FX_INVEST_FUND_TYPE IN('F','I')

View Text - HTML Formatted

SELECT A.COMPANY_CODE
, A.LIMIT_CODE
, A.NAME LIMIT_CODE_NAME
, B.LIMIT_TYPE
, B.NAME LIMIT_TYPE_NAME
, B.FX_INVEST_FUND_TYPE
FROM XTR_COMPANY_LIMITS A
, XTR_LIMIT_TYPES B
WHERE A.AUTHORISED = 'Y'
AND A.LIMIT_TYPE = B.LIMIT_TYPE
AND B.FX_INVEST_FUND_TYPE IN('F'
, 'I')