Order Types.sql

-- SQL Query Obtain Order Types
SELECT
	LOOKUP_CODE
  , MEANING
  , DESCRIPTION
FROM
	fusion.FND_LOOKUP_VALUES_TL
WHERE
	lookup_type LIKE 'ORA_DOO_ORDER_TYPES'
	AND language   = userenv('LANG')
ORDER BY
	lookup_code
;