DBA Data[Home] [Help]

VIEW: APPS.XTR_ACCOUNT_MANAGERS_V

Source

View Text - Preformatted

SELECT distinct p.account_manager, dc.dealer_user_name from xtr_parties_v p, xtr_dealer_codes dc where p.account_manager = dc.dealer_code
View Text - HTML Formatted

SELECT DISTINCT P.ACCOUNT_MANAGER
, DC.DEALER_USER_NAME
FROM XTR_PARTIES_V P
, XTR_DEALER_CODES DC
WHERE P.ACCOUNT_MANAGER = DC.DEALER_CODE