eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: WF_AMV_CHN_ROLES

Product:	FND - Application Object Library
Description:	Bulk Sync Directory Service Role View for Orig System AMV_CHN
Implementation/DBA Data:	APPS.WF_AMV_CHN_ROLES

View Text

SELECT 'AMV_CHN'||':'||CHB.CHANNEL_ID
, CHT.CHANNEL_NAME
, CHT.CHANNEL_NAME
, 'QUERY'
, FNDL.NLS_LANGUAGE
, FNDL.NLS_TERRITORY
, NULL
, NULL
, 'AMV_CHN'
, CHB.CHANNEL_ID
, TO_DATE(NULL)
, CHB.STATUS
, TO_DATE(NULL)
, NULL
, 'N'
, 6
FROM FND_LANGUAGES FNDL
, AMV_C_CHANNELS_B CHB
, AMV_C_CHANNELS_TL CHT
WHERE CHB.CHANNEL_ID = CHT.CHANNEL_ID
AND CHT.LANGUAGE = FNDL.LANGUAGE_CODE
AND FNDL.LANGUAGE_CODE = USERENV('LANG')

Columns

Name
NAME
DISPLAY_NAME
DESCRIPTION
NOTIFICATION_PREFERENCE
LANGUAGE
TERRITORY
EMAIL_ADDRESS
FAX
ORIG_SYSTEM
ORIG_SYSTEM_ID
START_DATE
STATUS
EXPIRATION_DATE
SECURITY_GROUP_ID
USER_FLAG
PARTITION_ID