SELECT B.rowid row_id, B.res_type_id, B.RES_TYPE_CODE, B.ENABLED_FLAG, B.last_update_date, B.last_updated_by, B.creation_date, B.created_by, B.last_update_login, T.name, T.description from PA_RES_TYPES_TL T, PA_RES_TYPES_B B WHERE B.res_type_id = T.res_type_id and T.language = userenv('LANG')
SELECT B.ROWID ROW_ID
, B.RES_TYPE_ID
, B.RES_TYPE_CODE
, B.ENABLED_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.NAME
, T.DESCRIPTION
FROM PA_RES_TYPES_TL T
, PA_RES_TYPES_B B
WHERE B.RES_TYPE_ID = T.RES_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
|
|
|