VIEW: APPS.XTR_BIS_LIMIT_OVERVIEW_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'