View: OE_REASONS_V

Product:	ONT - Order Management
Description:	Reason History
Implementation/DBA Data:	APPS.OE_REASONS_V

View Text

SELECT FLT.MEANING
, OER.REASON_TYPE
, OER.REASON_CODE
, FLV.MEANING
, OER.COMMENTS
, OER.CREATION_DATE
, OER.REASON_ID
, OER.ENTITY_ID
, OER.ENTITY_CODE
, OER.VERSION_NUMBER
, OER.HEADER_ID
FROM OE_REASONS OER
, FND_LOOKUP_VALUES FLV
, FND_LOOKUP_TYPES_VL FLT
WHERE FLV.LANGUAGE = USERENV('LANG')
AND FLV.VIEW_APPLICATION_ID = 660
AND FLT.VIEW_APPLICATION_ID = 660
AND FLT.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLT.LOOKUP_TYPE
, FLT.VIEW_APPLICATION_ID)
AND FLV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(FLV.LOOKUP_TYPE
, FLV.VIEW_APPLICATION_ID)
AND FLV.LOOKUP_TYPE=FLT.LOOKUP_TYPE
AND OER.REASON_TYPE=FLV.LOOKUP_TYPE
AND OER.REASON_CODE=FLV.LOOKUP_CODE

Columns