SELECT DISTINCT PS.WORKORDER_TYPE CODE, L.MEANING MEANING, USERENV('LANG') LANGUAGE FROM MTH_PRODUCTION_SCHEDULES_F PS, FND_LOOKUP_VALUES L WHERE PS.WORKORDER_TYPE = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'MTH_WORKORDER_TYPE_L' AND L.SOURCE_LANG = 'US'
SELECT DISTINCT PS.WORKORDER_TYPE CODE
, L.MEANING MEANING
, USERENV('LANG') LANGUAGE
FROM MTH_PRODUCTION_SCHEDULES_F PS
, FND_LOOKUP_VALUES L
WHERE PS.WORKORDER_TYPE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'MTH_WORKORDER_TYPE_L'
AND L.SOURCE_LANG = 'US'
|
|
|