VIEW: APPS.XTR_DISC_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.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'

View Text - HTML Formatted

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'