SELECT STA.STY_ID STY_ID ,STA.CAT_ID CAT_ID ,STA.SEQUENCE_NUMBER SEQUENCE_NUMBER ,STA.STREAM_ALLC_TYPE STREAM_ALLC_TYPE ,STY.NAME NAME ,STY.DESCRIPTION DESCRIPTION FROM OKL_STRM_TYP_ALLOCS STA,OKL_STRM_TYPE_TL STY WHERE STY.ID = STA.STY_ID AND STY.LANGUAGE = USERENV ('LANG')
SELECT STA.STY_ID STY_ID
, STA.CAT_ID CAT_ID
, STA.SEQUENCE_NUMBER SEQUENCE_NUMBER
, STA.STREAM_ALLC_TYPE STREAM_ALLC_TYPE
, STY.NAME NAME
, STY.DESCRIPTION DESCRIPTION
FROM OKL_STRM_TYP_ALLOCS STA
, OKL_STRM_TYPE_TL STY
WHERE STY.ID = STA.STY_ID
AND STY.LANGUAGE = USERENV ('LANG')
|
|
|