View: XTR_BIS_LIMIT_OVERVIEW_V

Product:	XTR - Treasury
Description:	This view shows the limit and utilization amount information for counterparty, sovereign, global, currency, group, and settlement limits.
Implementation/DBA Data:	APPS.XTR_BIS_LIMIT_OVERVIEW_V

View Text

SELECT LI.LIMIT_TYPE
, LI.LIMIT_PARTY
, LI.COUNTRY
, FT.TERRITORY_SHORT_NAME
, LI.LIMIT_CODE
, LI.COMPANY
, PA.SHORT_NAME
, LI.LIMIT_GROUP
, LI.CURRENCY
, LI.LIMIT_AMT
, LI.UTILISED
, LI.AVAILABLE
, LI.EFFECTIVE_DATE
FROM XTR_LIMIT_OVERVIEW_V LI
, XTR_PARTIES_V PA
, FND_TERRITORIES_VL FT
WHERE LI.COMPANY = PA.PARTY_CODE
AND LI.COUNTRY = FT.TERRITORY_CODE (+)
AND LI.COMPANY <> 'N/A' UNION ALL SELECT LI.LIMIT_TYPE
, LI.LIMIT_PARTY
, LI.COUNTRY
, FT.TERRITORY_SHORT_NAME
, LI.LIMIT_CODE
, LI.COMPANY
, NULL
, LI.LIMIT_GROUP
, LI.CURRENCY
, LI.LIMIT_AMT
, LI.UTILISED
, LI.AVAILABLE
, LI.EFFECTIVE_DATE
FROM XTR_LIMIT_OVERVIEW_V LI
, FND_TERRITORIES_VL FT
WHERE LI.COUNTRY = FT.TERRITORY_CODE (+)
AND LI.COMPANY = 'N/A'

Columns