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_FND_RESP_ROLES

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.WF_FND_RESP_ROLES

View Text

SELECT 'FND_RESP'||R.APPLICATION_ID||':'||R.RESPONSIBILITY_ID
, RTL.RESPONSIBILITY_NAME
, RTL.DESCRIPTION
, 'QUERY'
, NULL
, NULL
, NULL
, NULL
, 'FND_RESP'||R.APPLICATION_ID
, R.RESPONSIBILITY_ID
, R.START_DATE
, DECODE(SUBSTR(TO_CHAR(NVL(R.END_DATE
, SYSDATE+1)-SYSDATE)
, 1
, 1)
, '-'
, 'INACTIVE'
, 'ACTIVE')
, R.END_DATE
, NULL
, 'N'
, 2
FROM FND_RESPONSIBILITY R
, FND_RESPONSIBILITY_TL RTL
, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG = 'B'
AND RTL.LANGUAGE = L.LANGUAGE_CODE
AND R.APPLICATION_ID = RTL.APPLICATION_ID
AND R.RESPONSIBILITY_ID = RTL.RESPONSIBILITY_ID

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