VIEW: APPS.GL_SRS_DEL_JI_GROUPS_V

Source

View Text - Preformatted

SELECT int.group_id group_id, int.request_id request_id, lgr.ledger_id ledger_id, src.je_source_name je_source_name FROM gl_je_sources src, gl_ledgers lgr, gl_interface int WHERE ( int.user_je_source_name = decode(src.import_using_key_flag, 'Y', src.je_source_key, src.user_je_source_name) and int.set_of_books_id = lgr.ledger_id and int.ledger_id = -1 and int.group_id is not null) or ( int.user_je_source_name = decode(src.import_using_key_flag, 'Y', src.je_source_key, src.user_je_source_name) and int.ledger_id = lgr.ledger_id and int.set_of_books_id in (-1, lgr.ledger_id) and int.group_id is not null) GROUP BY int.group_id, int.request_id, lgr.ledger_id, src.je_source_name UNION SELECT ctrl.group_id group_id, ctrl.request_id request_id, ctrl.set_of_books_id ledger_id, ctrl.je_source_name je_source_name FROM gl_interface_control ctrl WHERE group_id is not null AND nvl(upper(interface_table_name), 'GL_INTERFACE') <> 'GL_INTERFACE' GROUP BY group_id, request_id, set_of_books_id, je_source_name

View Text - HTML Formatted

SELECT INT.GROUP_ID GROUP_ID
, INT.REQUEST_ID REQUEST_ID
, LGR.LEDGER_ID LEDGER_ID
, SRC.JE_SOURCE_NAME JE_SOURCE_NAME
FROM GL_JE_SOURCES SRC
, GL_LEDGERS LGR
, GL_INTERFACE INT
WHERE ( INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG
, 'Y'
, SRC.JE_SOURCE_KEY
, SRC.USER_JE_SOURCE_NAME)
AND INT.SET_OF_BOOKS_ID = LGR.LEDGER_ID
AND INT.LEDGER_ID = -1
AND INT.GROUP_ID IS NOT NULL) OR ( INT.USER_JE_SOURCE_NAME = DECODE(SRC.IMPORT_USING_KEY_FLAG
, 'Y'
, SRC.JE_SOURCE_KEY
, SRC.USER_JE_SOURCE_NAME)
AND INT.LEDGER_ID = LGR.LEDGER_ID
AND INT.SET_OF_BOOKS_ID IN (-1
, LGR.LEDGER_ID)
AND INT.GROUP_ID IS NOT NULL) GROUP BY INT.GROUP_ID
, INT.REQUEST_ID
, LGR.LEDGER_ID
, SRC.JE_SOURCE_NAME UNION SELECT CTRL.GROUP_ID GROUP_ID
, CTRL.REQUEST_ID REQUEST_ID
, CTRL.SET_OF_BOOKS_ID LEDGER_ID
, CTRL.JE_SOURCE_NAME JE_SOURCE_NAME
FROM GL_INTERFACE_CONTROL CTRL
WHERE GROUP_ID IS NOT NULL
AND NVL(UPPER(INTERFACE_TABLE_NAME)
, 'GL_INTERFACE') <> 'GL_INTERFACE' GROUP BY GROUP_ID
, REQUEST_ID
, SET_OF_BOOKS_ID
, JE_SOURCE_NAME