SELECT PS.WORKORDER_PK_KEY CODE, PS.WORKORDER_NAME MEANING, USERENV('LANG') LANGUAGE FROM MTH_PRODUCTION_SCHEDULES_F PS, MTH_PRODUCTION_SEGMENTS_F PSG WHERE PS.WORKORDER_PK_KEY = PSG.WORKORDER_FK_KEY
View Text - HTML Formatted
SELECT PS.WORKORDER_PK_KEY CODE , PS.WORKORDER_NAME MEANING , USERENV('LANG') LANGUAGE FROM MTH_PRODUCTION_SCHEDULES_F PS , MTH_PRODUCTION_SEGMENTS_F PSG WHERE PS.WORKORDER_PK_KEY = PSG.WORKORDER_FK_KEY