DBA Data[Home] [Help]

VIEW: APPS.XDP_FE_SW_GEN_LOOKUP_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.FE_SW_GEN_LOOKUP_ID, B.FETYPE_ID, B.SW_GENERIC, B.ADAPTER_TYPE, B.SW_START_PROC, B.SW_EXIT_PROC, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATED_BY, B.LAST_UPDATE_LOGIN, T.DISPLAY_NAME, T.DESCRIPTION from XDP_FE_SW_GEN_LOOKUP_TL T, XDP_FE_SW_GEN_LOOKUP B WHERE B.FE_SW_GEN_LOOKUP_ID = T.FE_SW_GEN_LOOKUP_ID and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.FE_SW_GEN_LOOKUP_ID
, B.FETYPE_ID
, B.SW_GENERIC
, B.ADAPTER_TYPE
, B.SW_START_PROC
, B.SW_EXIT_PROC
, B.CREATION_DATE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM XDP_FE_SW_GEN_LOOKUP_TL T
, XDP_FE_SW_GEN_LOOKUP B
WHERE B.FE_SW_GEN_LOOKUP_ID = T.FE_SW_GEN_LOOKUP_ID
AND T.LANGUAGE = USERENV('LANG')