Product: | AS - Sales Foundation |
---|---|
Description: | This view shows the sales group hierarchy information |
Implementation/DBA Data: | APPS.AS_SALES_GRP_DENORM_V |
SELECT GD.GROUP_ID
, GD.PARENT_GROUP_ID
, GD.LAST_UPDATE_DATE
, GD.LAST_UPDATED_BY
, GD.CREATION_DATE
, GD.CREATED_BY
, GD.LAST_UPDATE_LOGIN
, GD.IMMEDIATE_PARENT_FLAG
, GD.START_DATE_ACTIVE
, GD.END_DATE_ACTIVE
, GD.ATTRIBUTE_CATEGORY
, GD.ATTRIBUTE1
, GD.ATTRIBUTE2
, GD.ATTRIBUTE3
, GD.ATTRIBUTE4
, GD.ATTRIBUTE5
, GD.ATTRIBUTE6
, GD.ATTRIBUTE7
, GD.ATTRIBUTE8
, GD.ATTRIBUTE9
, GD.ATTRIBUTE10
, GD.ATTRIBUTE11
, GD.ATTRIBUTE12
, GD.ATTRIBUTE13
, GD.ATTRIBUTE14
, GD.ATTRIBUTE15
FROM JTF_RS_GROUPS_DENORM GD
, JTF_RS_GROUP_USAGES U
WHERE U.USAGE = 'SALES'
AND GD.GROUP_ID = U.GROUP_ID