[Home] [Help]
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
Name |
LIMIT_TYPE |
CPARTY |
COUNTRY |
COUNTRY_NAME |
LIMIT_CODE |
COMPANY |
COMPANY_NAME |
LIMIT_GROUP |
CURR |
LIMIT_AMOUNT |
UTILIZED |
AVAILABLE |
EFFECTIVE_DATE |