1. Tables and Views for SCM
  2. CSE_GROUPS_VL

CSE_GROUPS_VL

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: VIEW

Columns

Name

GROUP_ID

OBJECT_VERSION_NUMBER

RULE_ID

GROUP_NUMBER

GROUP_NAME

GROUP_DESCRIPTION

ACTIVE_END_DATE

EXTN_ATTRIBUTE_CHAR001

EXTN_ATTRIBUTE_CHAR002

EXTN_ATTRIBUTE_CHAR003

EXTN_ATTRIBUTE_CHAR004

EXTN_ATTRIBUTE_CHAR005

EXTN_ATTRIBUTE_CHAR006

EXTN_ATTRIBUTE_CHAR007

EXTN_ATTRIBUTE_CHAR008

EXTN_ATTRIBUTE_CHAR009

EXTN_ATTRIBUTE_CHAR010

EXTN_ATTRIBUTE_CHAR011

EXTN_ATTRIBUTE_CHAR012

EXTN_ATTRIBUTE_CHAR013

EXTN_ATTRIBUTE_CHAR014

EXTN_ATTRIBUTE_CHAR015

EXTN_ATTRIBUTE_CHAR016

EXTN_ATTRIBUTE_CHAR017

EXTN_ATTRIBUTE_CHAR018

EXTN_ATTRIBUTE_CHAR019

EXTN_ATTRIBUTE_CHAR020

EXTN_ATTRIBUTE_CHAR021

EXTN_ATTRIBUTE_CHAR022

EXTN_ATTRIBUTE_CHAR023

EXTN_ATTRIBUTE_CHAR024

EXTN_ATTRIBUTE_CHAR025

EXTN_ATTRIBUTE_CHAR026

EXTN_ATTRIBUTE_CHAR027

EXTN_ATTRIBUTE_CHAR028

EXTN_ATTRIBUTE_CHAR029

EXTN_ATTRIBUTE_CHAR030

EXTN_ATTRIBUTE_CHAR031

EXTN_ATTRIBUTE_CHAR032

EXTN_ATTRIBUTE_CHAR033

EXTN_ATTRIBUTE_CHAR034

EXTN_ATTRIBUTE_CHAR035

EXTN_ATTRIBUTE_CHAR036

EXTN_ATTRIBUTE_CHAR037

EXTN_ATTRIBUTE_CHAR038

EXTN_ATTRIBUTE_CHAR039

EXTN_ATTRIBUTE_CHAR040

EXTN_ATTRIBUTE_CHAR041

EXTN_ATTRIBUTE_CHAR042

EXTN_ATTRIBUTE_CHAR043

EXTN_ATTRIBUTE_CHAR044

EXTN_ATTRIBUTE_CHAR045

EXTN_ATTRIBUTE_CHAR046

EXTN_ATTRIBUTE_CHAR047

EXTN_ATTRIBUTE_CHAR048

EXTN_ATTRIBUTE_CHAR049

EXTN_ATTRIBUTE_CHAR050

EXTN_ATTRIBUTE_CHAR051

EXTN_ATTRIBUTE_CHAR052

EXTN_ATTRIBUTE_CHAR053

EXTN_ATTRIBUTE_CHAR054

EXTN_ATTRIBUTE_CHAR055

EXTN_ATTRIBUTE_CHAR056

EXTN_ATTRIBUTE_CHAR057

EXTN_ATTRIBUTE_CHAR058

EXTN_ATTRIBUTE_CHAR059

EXTN_ATTRIBUTE_CHAR060

EXTN_ATTRIBUTE_CHAR061

EXTN_ATTRIBUTE_CHAR062

EXTN_ATTRIBUTE_CHAR063

EXTN_ATTRIBUTE_CHAR064

EXTN_ATTRIBUTE_CHAR065

EXTN_ATTRIBUTE_CHAR066

EXTN_ATTRIBUTE_CHAR067

EXTN_ATTRIBUTE_CHAR068

EXTN_ATTRIBUTE_CHAR069

EXTN_ATTRIBUTE_CHAR070

EXTN_ATTRIBUTE_CHAR071

EXTN_ATTRIBUTE_CHAR072

EXTN_ATTRIBUTE_CHAR073

EXTN_ATTRIBUTE_CHAR074

EXTN_ATTRIBUTE_CHAR075

EXTN_ATTRIBUTE_CHAR076

EXTN_ATTRIBUTE_CHAR077

EXTN_ATTRIBUTE_CHAR078

EXTN_ATTRIBUTE_CHAR079

EXTN_ATTRIBUTE_CHAR080

EXTN_ATTRIBUTE_CHAR081

EXTN_ATTRIBUTE_CHAR082

EXTN_ATTRIBUTE_CHAR083

EXTN_ATTRIBUTE_CHAR084

EXTN_ATTRIBUTE_CHAR085

EXTN_ATTRIBUTE_CHAR086

EXTN_ATTRIBUTE_CHAR087

EXTN_ATTRIBUTE_CHAR088

EXTN_ATTRIBUTE_CHAR089

EXTN_ATTRIBUTE_CHAR090

EXTN_ATTRIBUTE_CHAR091

EXTN_ATTRIBUTE_CHAR092

EXTN_ATTRIBUTE_CHAR093

EXTN_ATTRIBUTE_CHAR094

EXTN_ATTRIBUTE_CHAR095

EXTN_ATTRIBUTE_CHAR096

EXTN_ATTRIBUTE_CHAR097

EXTN_ATTRIBUTE_CHAR098

EXTN_ATTRIBUTE_CHAR099

EXTN_ATTRIBUTE_CHAR100

EXTN_ATTRIBUTE_NUMBER001

EXTN_ATTRIBUTE_NUMBER002

EXTN_ATTRIBUTE_NUMBER003

EXTN_ATTRIBUTE_NUMBER004

EXTN_ATTRIBUTE_NUMBER005

EXTN_ATTRIBUTE_NUMBER006

EXTN_ATTRIBUTE_NUMBER007

EXTN_ATTRIBUTE_NUMBER008

EXTN_ATTRIBUTE_NUMBER009

EXTN_ATTRIBUTE_NUMBER010

EXTN_ATTRIBUTE_NUMBER011

EXTN_ATTRIBUTE_NUMBER012

EXTN_ATTRIBUTE_NUMBER013

EXTN_ATTRIBUTE_NUMBER014

EXTN_ATTRIBUTE_NUMBER015

EXTN_ATTRIBUTE_NUMBER016

EXTN_ATTRIBUTE_NUMBER017

EXTN_ATTRIBUTE_NUMBER018

EXTN_ATTRIBUTE_NUMBER019

EXTN_ATTRIBUTE_NUMBER020

EXTN_ATTRIBUTE_NUMBER021

EXTN_ATTRIBUTE_NUMBER022

EXTN_ATTRIBUTE_NUMBER023

EXTN_ATTRIBUTE_NUMBER024

EXTN_ATTRIBUTE_NUMBER025

EXTN_ATTRIBUTE_NUMBER026

EXTN_ATTRIBUTE_NUMBER027

EXTN_ATTRIBUTE_NUMBER028

EXTN_ATTRIBUTE_NUMBER029

EXTN_ATTRIBUTE_NUMBER030

EXTN_ATTRIBUTE_NUMBER031

EXTN_ATTRIBUTE_NUMBER032

EXTN_ATTRIBUTE_NUMBER033

EXTN_ATTRIBUTE_NUMBER034

EXTN_ATTRIBUTE_NUMBER035

EXTN_ATTRIBUTE_NUMBER036

EXTN_ATTRIBUTE_NUMBER037

EXTN_ATTRIBUTE_NUMBER038

EXTN_ATTRIBUTE_NUMBER039

EXTN_ATTRIBUTE_NUMBER040

EXTN_ATTRIBUTE_NUMBER041

EXTN_ATTRIBUTE_NUMBER042

EXTN_ATTRIBUTE_NUMBER043

EXTN_ATTRIBUTE_NUMBER044

EXTN_ATTRIBUTE_NUMBER045

EXTN_ATTRIBUTE_NUMBER046

EXTN_ATTRIBUTE_NUMBER047

EXTN_ATTRIBUTE_NUMBER048

EXTN_ATTRIBUTE_NUMBER049

EXTN_ATTRIBUTE_NUMBER050

EXTN_ATTRIBUTE_TIMESTAMP001

EXTN_ATTRIBUTE_TIMESTAMP002

EXTN_ATTRIBUTE_TIMESTAMP003

EXTN_ATTRIBUTE_TIMESTAMP004

EXTN_ATTRIBUTE_TIMESTAMP005

EXTN_ATTRIBUTE_TIMESTAMP006

EXTN_ATTRIBUTE_TIMESTAMP007

EXTN_ATTRIBUTE_TIMESTAMP008

EXTN_ATTRIBUTE_TIMESTAMP009

EXTN_ATTRIBUTE_TIMESTAMP010

EXTN_ATTRIBUTE_CLOB001

EXTN_ATTRIBUTE_CLOB002

EXTN_ATTRIBUTE_CLOB003

EXTN_ATTRIBUTE_CLOB004

EXTN_ATTRIBUTE_CLOB005

CURRENCY_CODE

CORP_CURRENCY_CODE

CURCY_CONV_RATE_TYPE

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

Query

SQL_Statement

SELECT

cgb.GROUP_ID GROUP_ID,

cgb.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

cgb.RULE_ID RULE_ID,

cgb.GROUP_NUMBER GROUP_NUMBER,

cgtl.GROUP_NAME GROUP_NAME,

cgtl.GROUP_DESCRIPTION GROUP_DESCRIPTION,

cgb.ACTIVE_END_DATE ACTIVE_END_DATE,

cgb.EXTN_ATTRIBUTE_CHAR001,

cgb.EXTN_ATTRIBUTE_CHAR002,

cgb.EXTN_ATTRIBUTE_CHAR003,

cgb.EXTN_ATTRIBUTE_CHAR004,

cgb.EXTN_ATTRIBUTE_CHAR005,

cgb.EXTN_ATTRIBUTE_CHAR006,

cgb.EXTN_ATTRIBUTE_CHAR007,

cgb.EXTN_ATTRIBUTE_CHAR008,

cgb.EXTN_ATTRIBUTE_CHAR009,

cgb.EXTN_ATTRIBUTE_CHAR010,

cgb.EXTN_ATTRIBUTE_CHAR011,

cgb.EXTN_ATTRIBUTE_CHAR012,

cgb.EXTN_ATTRIBUTE_CHAR013,

cgb.EXTN_ATTRIBUTE_CHAR014,

cgb.EXTN_ATTRIBUTE_CHAR015,

cgb.EXTN_ATTRIBUTE_CHAR016,

cgb.EXTN_ATTRIBUTE_CHAR017,

cgb.EXTN_ATTRIBUTE_CHAR018,

cgb.EXTN_ATTRIBUTE_CHAR019,

cgb.EXTN_ATTRIBUTE_CHAR020,

cgb.EXTN_ATTRIBUTE_CHAR021,

cgb.EXTN_ATTRIBUTE_CHAR022,

cgb.EXTN_ATTRIBUTE_CHAR023,

cgb.EXTN_ATTRIBUTE_CHAR024,

cgb.EXTN_ATTRIBUTE_CHAR025,

cgb.EXTN_ATTRIBUTE_CHAR026,

cgb.EXTN_ATTRIBUTE_CHAR027,

cgb.EXTN_ATTRIBUTE_CHAR028,

cgb.EXTN_ATTRIBUTE_CHAR029,

cgb.EXTN_ATTRIBUTE_CHAR030,

cgb.EXTN_ATTRIBUTE_CHAR031,

cgb.EXTN_ATTRIBUTE_CHAR032,

cgb.EXTN_ATTRIBUTE_CHAR033,

cgb.EXTN_ATTRIBUTE_CHAR034,

cgb.EXTN_ATTRIBUTE_CHAR035,

cgb.EXTN_ATTRIBUTE_CHAR036,

cgb.EXTN_ATTRIBUTE_CHAR037,

cgb.EXTN_ATTRIBUTE_CHAR038,

cgb.EXTN_ATTRIBUTE_CHAR039,

cgb.EXTN_ATTRIBUTE_CHAR040,

cgb.EXTN_ATTRIBUTE_CHAR041,

cgb.EXTN_ATTRIBUTE_CHAR042,

cgb.EXTN_ATTRIBUTE_CHAR043,

cgb.EXTN_ATTRIBUTE_CHAR044,

cgb.EXTN_ATTRIBUTE_CHAR045,

cgb.EXTN_ATTRIBUTE_CHAR046,

cgb.EXTN_ATTRIBUTE_CHAR047,

cgb.EXTN_ATTRIBUTE_CHAR048,

cgb.EXTN_ATTRIBUTE_CHAR049,

cgb.EXTN_ATTRIBUTE_CHAR050,

cgb.EXTN_ATTRIBUTE_CHAR051,

cgb.EXTN_ATTRIBUTE_CHAR052,

cgb.EXTN_ATTRIBUTE_CHAR053,

cgb.EXTN_ATTRIBUTE_CHAR054,

cgb.EXTN_ATTRIBUTE_CHAR055,

cgb.EXTN_ATTRIBUTE_CHAR056,

cgb.EXTN_ATTRIBUTE_CHAR057,

cgb.EXTN_ATTRIBUTE_CHAR058,

cgb.EXTN_ATTRIBUTE_CHAR059,

cgb.EXTN_ATTRIBUTE_CHAR060,

cgb.EXTN_ATTRIBUTE_CHAR061,

cgb.EXTN_ATTRIBUTE_CHAR062,

cgb.EXTN_ATTRIBUTE_CHAR063,

cgb.EXTN_ATTRIBUTE_CHAR064,

cgb.EXTN_ATTRIBUTE_CHAR065,

cgb.EXTN_ATTRIBUTE_CHAR066,

cgb.EXTN_ATTRIBUTE_CHAR067,

cgb.EXTN_ATTRIBUTE_CHAR068,

cgb.EXTN_ATTRIBUTE_CHAR069,

cgb.EXTN_ATTRIBUTE_CHAR070,

cgb.EXTN_ATTRIBUTE_CHAR071,

cgb.EXTN_ATTRIBUTE_CHAR072,

cgb.EXTN_ATTRIBUTE_CHAR073,

cgb.EXTN_ATTRIBUTE_CHAR074,

cgb.EXTN_ATTRIBUTE_CHAR075,

cgb.EXTN_ATTRIBUTE_CHAR076,

cgb.EXTN_ATTRIBUTE_CHAR077,

cgb.EXTN_ATTRIBUTE_CHAR078,

cgb.EXTN_ATTRIBUTE_CHAR079,

cgb.EXTN_ATTRIBUTE_CHAR080,

cgb.EXTN_ATTRIBUTE_CHAR081,

cgb.EXTN_ATTRIBUTE_CHAR082,

cgb.EXTN_ATTRIBUTE_CHAR083,

cgb.EXTN_ATTRIBUTE_CHAR084,

cgb.EXTN_ATTRIBUTE_CHAR085,

cgb.EXTN_ATTRIBUTE_CHAR086,

cgb.EXTN_ATTRIBUTE_CHAR087,

cgb.EXTN_ATTRIBUTE_CHAR088,

cgb.EXTN_ATTRIBUTE_CHAR089,

cgb.EXTN_ATTRIBUTE_CHAR090,

cgb.EXTN_ATTRIBUTE_CHAR091,

cgb.EXTN_ATTRIBUTE_CHAR092,

cgb.EXTN_ATTRIBUTE_CHAR093,

cgb.EXTN_ATTRIBUTE_CHAR094,

cgb.EXTN_ATTRIBUTE_CHAR095,

cgb.EXTN_ATTRIBUTE_CHAR096,

cgb.EXTN_ATTRIBUTE_CHAR097,

cgb.EXTN_ATTRIBUTE_CHAR098,

cgb.EXTN_ATTRIBUTE_CHAR099,

cgb.EXTN_ATTRIBUTE_CHAR100,

cgb.EXTN_ATTRIBUTE_NUMBER001,

cgb.EXTN_ATTRIBUTE_NUMBER002,

cgb.EXTN_ATTRIBUTE_NUMBER003,

cgb.EXTN_ATTRIBUTE_NUMBER004,

cgb.EXTN_ATTRIBUTE_NUMBER005,

cgb.EXTN_ATTRIBUTE_NUMBER006,

cgb.EXTN_ATTRIBUTE_NUMBER007,

cgb.EXTN_ATTRIBUTE_NUMBER008,

cgb.EXTN_ATTRIBUTE_NUMBER009,

cgb.EXTN_ATTRIBUTE_NUMBER010,

cgb.EXTN_ATTRIBUTE_NUMBER011,

cgb.EXTN_ATTRIBUTE_NUMBER012,

cgb.EXTN_ATTRIBUTE_NUMBER013,

cgb.EXTN_ATTRIBUTE_NUMBER014,

cgb.EXTN_ATTRIBUTE_NUMBER015,

cgb.EXTN_ATTRIBUTE_NUMBER016,

cgb.EXTN_ATTRIBUTE_NUMBER017,

cgb.EXTN_ATTRIBUTE_NUMBER018,

cgb.EXTN_ATTRIBUTE_NUMBER019,

cgb.EXTN_ATTRIBUTE_NUMBER020,

cgb.EXTN_ATTRIBUTE_NUMBER021,

cgb.EXTN_ATTRIBUTE_NUMBER022,

cgb.EXTN_ATTRIBUTE_NUMBER023,

cgb.EXTN_ATTRIBUTE_NUMBER024,

cgb.EXTN_ATTRIBUTE_NUMBER025,

cgb.EXTN_ATTRIBUTE_NUMBER026,

cgb.EXTN_ATTRIBUTE_NUMBER027,

cgb.EXTN_ATTRIBUTE_NUMBER028,

cgb.EXTN_ATTRIBUTE_NUMBER029,

cgb.EXTN_ATTRIBUTE_NUMBER030,

cgb.EXTN_ATTRIBUTE_NUMBER031,

cgb.EXTN_ATTRIBUTE_NUMBER032,

cgb.EXTN_ATTRIBUTE_NUMBER033,

cgb.EXTN_ATTRIBUTE_NUMBER034,

cgb.EXTN_ATTRIBUTE_NUMBER035,

cgb.EXTN_ATTRIBUTE_NUMBER036,

cgb.EXTN_ATTRIBUTE_NUMBER037,

cgb.EXTN_ATTRIBUTE_NUMBER038,

cgb.EXTN_ATTRIBUTE_NUMBER039,

cgb.EXTN_ATTRIBUTE_NUMBER040,

cgb.EXTN_ATTRIBUTE_NUMBER041,

cgb.EXTN_ATTRIBUTE_NUMBER042,

cgb.EXTN_ATTRIBUTE_NUMBER043,

cgb.EXTN_ATTRIBUTE_NUMBER044,

cgb.EXTN_ATTRIBUTE_NUMBER045,

cgb.EXTN_ATTRIBUTE_NUMBER046,

cgb.EXTN_ATTRIBUTE_NUMBER047,

cgb.EXTN_ATTRIBUTE_NUMBER048,

cgb.EXTN_ATTRIBUTE_NUMBER049,

cgb.EXTN_ATTRIBUTE_NUMBER050,

cgb.EXTN_ATTRIBUTE_TIMESTAMP001,

cgb.EXTN_ATTRIBUTE_TIMESTAMP002,

cgb.EXTN_ATTRIBUTE_TIMESTAMP003,

cgb.EXTN_ATTRIBUTE_TIMESTAMP004,

cgb.EXTN_ATTRIBUTE_TIMESTAMP005,

cgb.EXTN_ATTRIBUTE_TIMESTAMP006,

cgb.EXTN_ATTRIBUTE_TIMESTAMP007,

cgb.EXTN_ATTRIBUTE_TIMESTAMP008,

cgb.EXTN_ATTRIBUTE_TIMESTAMP009,

cgb.EXTN_ATTRIBUTE_TIMESTAMP010,

cgb.EXTN_ATTRIBUTE_CLOB001,

cgb.EXTN_ATTRIBUTE_CLOB002,

cgb.EXTN_ATTRIBUTE_CLOB003,

cgb.EXTN_ATTRIBUTE_CLOB004,

cgb.EXTN_ATTRIBUTE_CLOB005,

cgb.CURRENCY_CODE,

cgb.CORP_CURRENCY_CODE,

cgb.CURCY_CONV_RATE_TYPE,

cgb.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

cgb.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

cgb.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

cgb.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

cgb.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

cgb.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

cgb.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

cgb.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

cgb.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

cgb.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

cgb.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

cgb.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

cgb.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

cgb.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

cgb.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

cgb.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

cgb.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

cgb.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

cgb.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

cgb.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

cgb.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

cgb.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

cgb.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

cgb.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

cgb.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

cgb.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

cgb.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

cgb.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

cgb.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

cgb.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

cgb.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

cgb.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

cgb.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

cgb.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

cgb.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

cgb.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

cgb.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

cgb.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

cgb.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

cgb.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

cgb.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

cgb.CREATED_BY CREATED_BY,

cgb.CREATION_DATE CREATION_DATE,

cgb.LAST_UPDATED_BY LAST_UPDATED_BY,

cgb.LAST_UPDATE_DATE LAST_UPDATE_DATE,

cgb.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

cgb.REQUEST_ID REQUEST_ID,

cgb.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

cgb.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE

FROM

cse_groups_b cgb,

cse_groups_tl cgtl

WHERE

cgtl.GROUP_ID = cgb.GROUP_ID AND cgtl.LANGUAGE = USERENV('LANG')