[Home] [Help]
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
Name |
REASON_TYPE |
REASON_TYPE_CODE |
REASON_CODE |
REASON |
COMMENTS |
CREATION_DATE |
REASON_ID |
ENTITY_ID |
ENTITY_CODE |
VERSION_NUMBER |
HEADER_ID |