[Home] [Help]
View: AS_SALESGROUP_SUB_V
Product: | AS - Sales Foundation |
Description: | This view shows all the first level sub-groups from JTF resource manager |
Implementation/DBA Data: |
APPS.AS_SALESGROUP_SUB_V
|
View Text
SELECT NULL SALESFORCE_ID
, JGD.GROUP_ID SALES_GROUP_ID
, JGD.PARENT_GROUP_ID PARENT_GROUP_ID
, JGD.START_DATE_ACTIVE START_DATE_ACTIVE
, JGD.END_DATE_ACTIVE END_DATE_ACTIVE
, JGT.GROUP_NAME GROUP_NAME
FROM JTF_RS_GROUPS_DENORM JGD
, JTF_RS_GROUP_USAGES JGU
, JTF_RS_GROUPS_TL JGT
WHERE JGU.USAGE = 'SALES'
AND JGU.GROUP_ID = JGD.GROUP_ID
AND JGD.IMMEDIATE_PARENT_FLAG ='Y'
AND JGT.GROUP_ID = JGD.GROUP_ID
AND JGT.LANGUAGE = USERENV('LANG')
Columns
Name |
SALESFORCE_ID |
SALES_GROUP_ID |
PARENT_GROUP_ID |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
GROUP_NAME |