View: XTR_COMPANY_LIMITS_EXCL_FX_V

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

View Text

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')

Columns