View: GMF_ORDER_TYPES_V

Product:	GMF - Process Manufacturing Financials
Description:	View for the value set , GMF_ORDER_TYPES
Implementation/DBA Data:	APPS.GMF_ORDER_TYPES_V

View Text

SELECT T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, T.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, T.LANGUAGE LANGUAGE
, A.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
FROM OE_TRANSACTION_TYPES_ALL A
, OE_TRANSACTION_TYPES_TL T
WHERE T.TRANSACTION_TYPE_ID = A.TRANSACTION_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND A.TRANSACTION_TYPE_CODE='ORDER' UNION SELECT '' NAME
, '' DESCRIPTION
, 0 TRANSACTION_TYPE_ID
, '' LANGUAGE
, '' TRANSACTION_TYPE_CODE
FROM DUAL

Columns