SELECT ROWID, SUPER_GROUP_ID, ID_FLEX_NUM,
(DECODE(ID_FLEX_NUM,
50139, SEGMENT1, NULL)),
(DECODE(ID_FLEX_NUM,
50139, RPAD(NVL(SEGMENT1, ' '), 30), NULL)),
SUPER_GROUP_NAME, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, DESCRIPTION, ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
FROM FA_SUPER_GROUPS
SELECT ROWID
, SUPER_GROUP_ID
, ID_FLEX_NUM
,
(DECODE(ID_FLEX_NUM
,
50139
, SEGMENT1
, NULL))
,
(DECODE(ID_FLEX_NUM
,
50139
, RPAD(NVL(SEGMENT1
, ' ')
, 30)
, NULL))
,
SUPER_GROUP_NAME
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, DESCRIPTION
, ENABLED_FLAG
, SUMMARY_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM FA_SUPER_GROUPS
|
|
|