[Home] [Help]
View: AMW_GROUPS_V
Product: | AMW - Internal Controls Manager |
Description: | |
Implementation/DBA Data: |
APPS.AMW_GROUPS_V
|
View Text
SELECT GRP.PARTY_ID GROUP_ID
, GRP.PARTY_NAME GROUP_NAME
, GRP.MISSION_STATEMENT GROUP_DESCRIPTION
, GRP.EMAIL_ADDRESS GROUP_EMAIL_ADDRESS
, GRP.OBJECT_VERSION_NUMBER GROUP_OBJECT_VERSION_NUMBER
FROM HZ_PARTIES GRP
WHERE GRP.PARTY_TYPE = 'GROUP'
AND GRP.STATUS = 'A' OR GRP.PARTY_ID = -1000
Columns
Name |
GROUP_ID |
GROUP_NAME |
GROUP_DESCRIPTION |
GROUP_EMAIL_ADDRESS |
GROUP_OBJECT_VERSION_NUMBER |