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