VIEW: APPS.BIL_DIMV_SALES_GROUPS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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