MSC_AP_FND_LOOKUP_VALUES_TL

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE VIEW_APPLICATION_ID SET_ID LANGUAGE SOURCE_LANG MEANING DESCRIPTION

Name

LOOKUP_TYPE

LOOKUP_CODE

VIEW_APPLICATION_ID

SET_ID

LANGUAGE

SOURCE_LANG

MEANING

DESCRIPTION

Query

SQL_Statement
SELECT DECODE(LOOKUP_TYPE, 'DOO_RETURN_REASON', 'RETURN_REASON', 'WSH_SHIPPING_PRIORITY', 'SHIPMENT_PRIORITY', 'ORA_DOO_DEMAND_CLASS','DEMAND_CLASS',LOOKUP_TYPE) LOOKUP_TYPE, LOOKUP_CODE, VIEW_APPLICATION_ID, SET_ID, LANGUAGE, SOURCE_LANG, MEANING, DESCRIPTION FROM FND_LOOKUP_VALUES_TL WHERE (LOOKUP_TYPE IN ('WSH_SERVICE_LEVELS','WSH_MODE_OF_TRANSPORT','ZX_EXEMPTION_REASON_CODE','DOO_ACTIVITY_TYPE','DOO_PAYMENT_METHOD','FOB','WSH_SHIPPING_PRIORITY', 'DOO_RETURN_REASON','WSH_FREIGHT_CHARGE_TERMS','ORA_DOO_DEMAND_CLASS') AND VIEW_APPLICATION_ID = 0) OR (LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')

SQL_Statement

SELECT

DECODE(LOOKUP_TYPE, 'DOO_RETURN_REASON', 'RETURN_REASON', 'WSH_SHIPPING_PRIORITY', 'SHIPMENT_PRIORITY', 'ORA_DOO_DEMAND_CLASS','DEMAND_CLASS',LOOKUP_TYPE) LOOKUP_TYPE,

LOOKUP_CODE,

VIEW_APPLICATION_ID,

SET_ID,

LANGUAGE,

SOURCE_LANG,

MEANING,

DESCRIPTION

FROM

FND_LOOKUP_VALUES_TL

WHERE

(LOOKUP_TYPE IN ('WSH_SERVICE_LEVELS','WSH_MODE_OF_TRANSPORT','ZX_EXEMPTION_REASON_CODE','DOO_ACTIVITY_TYPE','DOO_PAYMENT_METHOD','FOB','WSH_SHIPPING_PRIORITY',

'DOO_RETURN_REASON','WSH_FREIGHT_CHARGE_TERMS','ORA_DOO_DEMAND_CLASS')

AND VIEW_APPLICATION_ID = 0)

OR (LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')