View: WF_ROLES_OLD

View Text

SELECT /* $HEADER: AFREGVW.LDT 115.3 2002/06/17 18:39:12 SSUNG NOSHIP $ */ NAME
, DISPLAY_NAME
, DESCRIPTION
, NOTIFICATION_PREFERENCE
, LANGUAGE
, TERRITORY
, EMAIL_ADDRESS
, FAX
, ORIG_SYSTEM
, ORIG_SYSTEM_ID
, STATUS
, EXPIRATION_DATE
FROM WF_USERS UNION ALL SELECT 'POS'||':'||POS.POSITION_ID
, POS.NAME
, POS.NAME
, 'QUERY'
, FNDL.NLS_LANGUAGE
, FNDT.NLS_TERRITORY
, NULL
, NULL
, 'POS'
, POS.POSITION_ID
, 'ACTIVE'
, TO_DATE(NULL)
FROM FND_TERRITORIES FNDT
, FND_LANGUAGES FNDL
, HR_LOCATIONS_ALL HRL
, PER_POSITIONS POS
WHERE POS.LOCATION_ID = HRL.LOCATION_ID(+)
AND HRL.COUNTRY = FNDT.TERRITORY_CODE(+)
AND FNDT.NLS_TERRITORY = FNDL.NLS_TERRITORY(+) UNION ALL SELECT 'ENG_LIST'||':'||EEAL.APPROVAL_LIST_ID
, EEAL.APPROVAL_LIST_NAME
, EEAL.DESCRIPTION
, 'QUERY'
, FNDL.NLS_LANGUAGE
, FNDL.NLS_TERRITORY
, NULL
, ''
, 'ENG_LIST'
, EEAL.APPROVAL_LIST_ID
, 'ACTIVE'
, TO_DATE(NULL)
FROM FND_LANGUAGES FNDL
, ENG_ECN_APPROVAL_LISTS EEAL
WHERE FNDL.INSTALLED_FLAG = 'B' UNION ALL SELECT 'FND_RESP'||R.APPLICATION_ID||':'||R.RESPONSIBILITY_ID
, R.RESPONSIBILITY_NAME
, R.DESCRIPTION
, 'QUERY'
, FNDL.NLS_LANGUAGE
, FNDL.NLS_TERRITORY
, NULL
, NULL
, 'FND_RESP'||R.APPLICATION_ID
, R.RESPONSIBILITY_ID
, 'ACTIVE'
, TO_DATE(NULL)
FROM FND_LANGUAGES FNDL
, FND_RESPONSIBILITY_TL R
WHERE R.LANGUAGE = USERENV('LANG')
AND FNDL.INSTALLED_FLAG = 'B' UNION ALL SELECT GBX.NAME
, GBX.DISPLAY_NAME
, GBX.DESCRIPTION
, 'QUERY'
, FNDL.NLS_LANGUAGE
, FNDL.NLS_TERRITORY
, NULL
, NULL
, 'GBX'
, GBX.GROUPBOX_ID
, 'ACTIVE'
, TO_DATE(NULL)
FROM GHR_GROUPBOXES GBX
, FND_LANGUAGES FNDL
WHERE FNDL.INSTALLED_FLAG = 'B' UNION ALL /* ADDED FOR AMV SEE BUG 1409680 FOR HISTORY */ SELECT 'AMV_CHN'||':'||CHB.CHANNEL_ID
, CHT.CHANNEL_NAME
, CHT.CHANNEL_NAME
, 'MAILHTML'
, FNDL.NLS_LANGUAGE
, FNDL.NLS_TERRITORY
, NULL
, NULL
, 'AMV_CHN'
, CHB.CHANNEL_ID
, CHB.STATUS
, TO_DATE(NULL)
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') UNION ALL /* ADDED FOR AMV SEE BUG 1409680 FOR HISTORY */ SELECT 'AMV_APPR'
, 'AMV'
, 'AMV'
, 'MAILHTML'
, FNDL.NLS_LANGUAGE
, FNDL.NLS_TERRITORY
, NULL
, NULL
, 'AMV_APPR'
, 520
, 'ACTIVE'
, TO_DATE(NULL)
FROM FND_LANGUAGES FNDL
WHERE FNDL.INSTALLED_FLAG = 'B' UNION ALL /* ADDED AS BUG 1391687 */ SELECT 'HZ_GROUP:'||TO_CHAR(P.PARTY_ID)
, P.PARTY_NAME
, P.MISSION_STATEMENT
, 'MAILTEXT'
, L.NLS_LANGUAGE
, T.NLS_TERRITORY
, P.EMAIL_ADDRESS
, NULL
, 'HZ_GROUP'
, P.PARTY_ID
, DECODE(P.STATUS
, 'I'
, 'INACTIVE'
, 'ACTIVE')
, TO_DATE(NULL)
FROM HZ_PARTIES P
, FND_LANGUAGES L
, FND_TERRITORIES T
WHERE PARTY_TYPE = 'GROUP'
AND P.LANGUAGE_NAME = L.LANGUAGE_CODE(+)
AND P.COUNTRY = T.TERRITORY_CODE(+)

Columns