VIEW: APPS.AS_SALESGROUP_SUB_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')