[Home] [Help]
View: PAY_COST_ALLOCATION_KEYFLE_KFV
View Text
SELECT ROWID
, COST_ALLOCATION_KEYFLEX_ID
, ID_FLEX_NUM
, (DECODE(ID_FLEX_NUM
, 101
, SEGMENT12
, NULL))
, (DECODE(ID_FLEX_NUM
, 101
, RPAD(NVL(SEGMENT12
, ' ')
, 60)
, NULL))
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PAY_COST_ALLOCATION_KEYFLEX
Columns
Name |
ROW_ID |
COST_ALLOCATION_KEYFLEX_ID |
ID_FLEX_NUM |
CONCATENATED_SEGMENTS |
PADDED_CONCATENATED_SEGMENTS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
SUMMARY_FLAG |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |