View: XTR_DISC_LIMIT_OVERVIEW_V

Product:	XTR - Treasury
Description:	Limit amount versus limit utilization amounts for all limit areas, where user access to company information is enforced.
Implementation/DBA Data:	APPS.XTR_DISC_LIMIT_OVERVIEW_V

View Text

SELECT LI.LIMIT_TYPE
, LI.LIMIT_PARTY
, LI.COUNTRY
, FT.TERRITORY_SHORT_NAME
, LI.LIMIT_CODE
, LI.COMPANY
, PA.FULL_NAME
, LI.LIMIT_GROUP
, LI.CURRENCY
, LI.LIMIT_AMT
, LI.UTILISED
, LI.AVAILABLE
, LI.EFFECTIVE_DATE
, PA1.FULL_NAME CPARTY_NAME
FROM XTR_LIMIT_OVERVIEW_V LI
, XTR_PARTY_INFO PA
, FND_TERRITORIES_VL FT
, XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC
, XTR_PARTY_INFO PA1
WHERE LI.COMPANY = PA.PARTY_CODE
AND LI.LIMIT_PARTY = PA1.PARTY_CODE(+)
AND LI.COUNTRY = FT.TERRITORY_CODE (+)
AND LI.COMPANY <> 'N/A'
AND LI.COMPANY=XCA.PARTY_CODE
AND XCA.DEALER_CODE=XDC.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y'
AND XDC.USER_ID=FND_GLOBAL.USER_ID 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
, NULL CPARTY_NAME
FROM XTR_LIMIT_OVERVIEW_V LI
, FND_TERRITORIES_VL FT
WHERE LI.COUNTRY = FT.TERRITORY_CODE (+)
AND LI.COMPANY = 'N/A'

Columns