eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OE_REASONS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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