DBA Data[Home] [Help]

VIEW: APPS.MTH_PRODUCTION_SCHEDULES_OCV

Source

View Text - Preformatted

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'
View Text - HTML Formatted

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'