VIEW: APPS.EDW_LUCD_ORDER_TYPE_V

Source

View Text - Preformatted

SELECT lookup_code_pk_key ID, name FROM edw_lkup_lookup_code_ltc WHERE lookup_type ='ORDER_TYPE' or lookup_code_pk_key = -1 or lookup_code_pk_key = 0

View Text - HTML Formatted

SELECT LOOKUP_CODE_PK_KEY ID
, NAME
FROM EDW_LKUP_LOOKUP_CODE_LTC
WHERE LOOKUP_TYPE ='ORDER_TYPE' OR LOOKUP_CODE_PK_KEY = -1 OR LOOKUP_CODE_PK_KEY = 0