SELECT
b.COLOR_ID,
b.SHORT_NAME,
tl.NAME,
tl.DESCRIPTION,
tl.PROTOTYPE_LABEL,
b.PERF_SEQUENCE,
b.COLOR,
b.USER_COLOR,
b.FORECAST_COLOR,
b.USER_FORECAST_COLOR,
b.NUMERIC_EQUIVALENT,
b.USER_NUMERIC_EQUIVALENT,
b.USER_IMAGE_ID,
b.CREATED_BY,
b.CREATION_DATE,
b.LAST_UPDATED_BY,
b.LAST_UPDATE_DATE,
b.LAST_UPDATE_LOGIN
FROM
BSC_SYS_COLORS_B b,
BSC_SYS_COLORS_TL tl
WHERE
b.COLOR_ID = tl.COLOR_ID AND tl.LANGUAGE = USERENV('LANG')
SELECT
B.COLOR_ID
,
B.SHORT_NAME
,
TL.NAME
,
TL.DESCRIPTION
,
TL.PROTOTYPE_LABEL
,
B.PERF_SEQUENCE
,
B.COLOR
,
B.USER_COLOR
,
B.FORECAST_COLOR
,
B.USER_FORECAST_COLOR
,
B.NUMERIC_EQUIVALENT
,
B.USER_NUMERIC_EQUIVALENT
,
B.USER_IMAGE_ID
,
B.CREATED_BY
,
B.CREATION_DATE
,
B.LAST_UPDATED_BY
,
B.LAST_UPDATE_DATE
,
B.LAST_UPDATE_LOGIN
FROM
BSC_SYS_COLORS_B B
,
BSC_SYS_COLORS_TL TL
WHERE
B.COLOR_ID = TL.COLOR_ID
AND TL.LANGUAGE = USERENV('LANG')
|
|
|