VIEW: APPS.GL_SRS_DEL_JI_LEDGERS_V

Source

View Text - Preformatted

SELECT int.request_id, acc.access_set_id, src.je_source_name, lgr.ledger_id, lgr.name ledger_name from gl_je_sources src, gl_interface int, gl_access_set_ledgers acc, gl_ledgers lgr WHERE ( ( 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 = -1 AND int.set_of_books_id = acc.ledger_id) OR ( 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 IN (-1, acc.ledger_id) AND int.ledger_id = acc.ledger_id)) AND acc.access_privilege_code IN ('B', 'F') AND acc.ledger_id = decode(int.ledger_id, -1, int.set_of_books_id, int.ledger_id) AND lgr.ledger_id = acc.ledger_id GROUP BY lgr.name, lgr.ledger_id, acc.access_set_id, src.je_source_name, int.request_id UNION select ic.request_id, acc.access_set_id, ic.je_source_name, ic.set_of_books_id ledger_id, lgr.name ledger_name from gl_interface_control ic, gl_access_set_ledgers acc, gl_ledgers lgr where ic.group_id is not null and nvl(upper(ic.interface_table_name), 'GL_INTERFACE') <> 'GL_INTERFACE' and acc.access_privilege_code IN ('B', 'F') and acc.ledger_id = ic.set_of_books_id and lgr.ledger_id = acc.ledger_id group by lgr.name, lgr.ledger_id, acc.access_set_id, ic.set_of_books_id, ic.je_source_name, ic.request_id

View Text - HTML Formatted

SELECT INT.REQUEST_ID
, ACC.ACCESS_SET_ID
, SRC.JE_SOURCE_NAME
, LGR.LEDGER_ID
, LGR.NAME LEDGER_NAME
FROM GL_JE_SOURCES SRC
, GL_INTERFACE INT
, GL_ACCESS_SET_LEDGERS ACC
, GL_LEDGERS LGR
WHERE ( ( 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 = -1
AND INT.SET_OF_BOOKS_ID = ACC.LEDGER_ID) OR ( 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 IN (-1
, ACC.LEDGER_ID)
AND INT.LEDGER_ID = ACC.LEDGER_ID))
AND ACC.ACCESS_PRIVILEGE_CODE IN ('B'
, 'F')
AND ACC.LEDGER_ID = DECODE(INT.LEDGER_ID
, -1
, INT.SET_OF_BOOKS_ID
, INT.LEDGER_ID)
AND LGR.LEDGER_ID = ACC.LEDGER_ID GROUP BY LGR.NAME
, LGR.LEDGER_ID
, ACC.ACCESS_SET_ID
, SRC.JE_SOURCE_NAME
, INT.REQUEST_ID UNION SELECT IC.REQUEST_ID
, ACC.ACCESS_SET_ID
, IC.JE_SOURCE_NAME
, IC.SET_OF_BOOKS_ID LEDGER_ID
, LGR.NAME LEDGER_NAME
FROM GL_INTERFACE_CONTROL IC
, GL_ACCESS_SET_LEDGERS ACC
, GL_LEDGERS LGR
WHERE IC.GROUP_ID IS NOT NULL
AND NVL(UPPER(IC.INTERFACE_TABLE_NAME)
, 'GL_INTERFACE') <> 'GL_INTERFACE'
AND ACC.ACCESS_PRIVILEGE_CODE IN ('B'
, 'F')
AND ACC.LEDGER_ID = IC.SET_OF_BOOKS_ID
AND LGR.LEDGER_ID = ACC.LEDGER_ID GROUP BY LGR.NAME
, LGR.LEDGER_ID
, ACC.ACCESS_SET_ID
, IC.SET_OF_BOOKS_ID
, IC.JE_SOURCE_NAME
, IC.REQUEST_ID