[Home] [Help]
View: ASFV_SALES_GROUPS_DENORM
Product: | AS - Sales Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT ASGD.SALES_GROUP_ID
, ASGD.PARENT_SALES_GROUP_ID
, '_LA:ASGD.IMMEDIATE_PARENT_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_DF:AS:AS_SALES_GROUPS:ASGD'
, GRP.NAME
, PARENT_GRP.NAME
, ASGD.LAST_UPDATE_DATE
, ASGD.LAST_UPDATED_BY
, ASGD.CREATION_DATE
, ASGD.CREATED_BY
FROM AS_SALES_GROUPS GRP
, AS_SALES_GROUPS PARENT_GRP
, AS_SALES_GROUPS_DENORM ASGD
WHERE ASGD.SALES_GROUP_ID = GRP.SALES_GROUP_ID AND ASGD.PARENT_SALES_GROUP_ID = PARENT_GRP.SALES_GROUP_ID WITH READ ONLY
Columns
Name |
SALES_GROUP_ID |
PARENT_SALES_GROUP_ID |
"_LA:IMMEDIATE_PARENT_FLAG" |
"_DF" |
SALES_GROUP_NAME |
PARENT_SALES_GROUP_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |