VIEW: APPS.GL_SRS_JI_REQUESTS_V

Source

View Text - Preformatted

SELECT DISTINCT REQUEST_ID REQUEST_ID, SRC.JE_SOURCE_NAME SOURCE_NAME FROM GL_INTERFACE INT, GL_JE_SOURCES_TL SRC WHERE INT.REQUEST_ID IS NOT NULL AND INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG, 'Y', SRC.JE_SOURCE_KEY, SRC.USER_JE_SOURCE_NAME) AND SRC.LANGUAGE = USERENV('LANG') UNION SELECT DISTINCT REQUEST_ID REQUEST_ID, JE_SOURCE_NAME SOURCE_NAME FROM GL_INTERFACE_CONTROL WHERE STATUS <> 'S' AND NVL(UPPER(INTERFACE_TABLE_NAME), 'GL_INTERFACE') <> 'GL_INTERFACE'

View Text - HTML Formatted

SELECT DISTINCT REQUEST_ID REQUEST_ID
, SRC.JE_SOURCE_NAME SOURCE_NAME
FROM GL_INTERFACE INT
, GL_JE_SOURCES_TL SRC
WHERE INT.REQUEST_ID IS NOT NULL
AND INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG
, 'Y'
, SRC.JE_SOURCE_KEY
, SRC.USER_JE_SOURCE_NAME)
AND SRC.LANGUAGE = USERENV('LANG') UNION SELECT DISTINCT REQUEST_ID REQUEST_ID
, JE_SOURCE_NAME SOURCE_NAME
FROM GL_INTERFACE_CONTROL
WHERE STATUS <> 'S'
AND NVL(UPPER(INTERFACE_TABLE_NAME)
, 'GL_INTERFACE') <> 'GL_INTERFACE'