View: BIL_DIMV_SALES_GROUPS

Product:	BIL - Sales Intelligence
Description:	Sales groups view
Implementation/DBA Data:	APPS.BIL_DIMV_SALES_GROUPS

View Text

SELECT JRGB.GROUP_ID SALES_GROUP_ID
, JRGB.GROUP_NUMBER GROUP_NUMBER
, JRGT.GROUP_NAME NAME
, JRGT.GROUP_DESC DESCRIPTION
, 'Y' ENABLED_FLAG
, JRGB.START_DATE_ACTIVE START_DATE_ACTIVE
, JRGB.END_DATE_ACTIVE END_DATE_ACTIVE
, JRGB.EXCLUSIVE_FLAG EXCLUSIVE_FLAG
, TO_CHAR(JRGB.GROUP_ID) ID
, JRGT.GROUP_NAME VALUE
FROM JTF_RS_GROUPS_B JRGB
, JTF_RS_GROUPS_TL JRGT
, JTF_RS_GROUP_USAGES JRGU
WHERE JRGU.GROUP_ID = JRGB.GROUP_ID
AND JRGU.USAGE = 'SALES'
AND JRGT.GROUP_ID = JRGB.GROUP_ID
AND JRGT.LANGUAGE = USERENV('LANG')
AND (SYSDATE BETWEEN JRGB.START_DATE_ACTIVE
AND NVL(JRGB.END_DATE_ACTIVE
, SYSDATE)) UNION ALL (SELECT JRGB.GROUP_ID SALES_GROUP_ID
, JRGB.GROUP_NUMBER GROUP_NUMBER
, JRGT.GROUP_NAME NAME
, JRGT.GROUP_DESC DESCRIPTION
, 'N' ENABLED_FLAG
, JRGB.START_DATE_ACTIVE START_DATE_ACTIVE
, JRGB.END_DATE_ACTIVE END_DATE_ACTIVE
, JRGB.EXCLUSIVE_FLAG EXCLUSIVE_FLAG
, TO_CHAR(JRGB.GROUP_ID) ID
, JRGT.GROUP_NAME VALUE
FROM JTF_RS_GROUPS_B JRGB
, JTF_RS_GROUPS_TL JRGT
, JTF_RS_GROUP_USAGES JRGU
WHERE JRGU.GROUP_ID = JRGB.GROUP_ID
AND JRGU.USAGE = 'SALES'
AND JRGT.GROUP_ID = JRGB.GROUP_ID
AND JRGT.LANGUAGE = USERENV('LANG')
AND (SYSDATE NOT BETWEEN JRGB.START_DATE_ACTIVE
AND NVL(JRGB.END_DATE_ACTIVE
, SYSDATE)) ) UNION (SELECT TO_NUMBER(FL.LOOKUP_CODE) SALES_GROUP_ID
, FL.LOOKUP_CODE GROUP_NUMBER
, SUBSTR(FL.MEANING
, 1
, 60) NAME
, FL.DESCRIPTION DESCRIPTION
, FL.ENABLED_FLAG ENABLED_FLAG
, FL.START_DATE_ACTIVE START_DATE_ACTIVE
, FL.END_DATE_ACTIVE END_DATE_ACTIVE
, 'N' EXCLUSIVE_FLAG
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY

Columns