MSC_AP_FND_LOOKUP_VALUES_B

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
LOOKUP_TYPE LOOKUP_CODE VIEW_APPLICATION_ID SET_ID ENABLED_FLAG START_DATE_ACTIVE END_DATE_ACTIVE

Name

LOOKUP_TYPE

LOOKUP_CODE

VIEW_APPLICATION_ID

SET_ID

ENABLED_FLAG

START_DATE_ACTIVE

END_DATE_ACTIVE

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, DECODE(ENABLED_FLAG,'Y',1,'N',2) ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE FROM FND_LOOKUP_VALUES_B 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,

DECODE(ENABLED_FLAG,'Y',1,'N',2) ENABLED_FLAG,

START_DATE_ACTIVE,

END_DATE_ACTIVE

FROM

FND_LOOKUP_VALUES_B

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')