VIEW: APPS.GL_SUSPENSE_ACCOUNTS_LOV_V

Source

View Text - Preformatted

SELECT /*$Header: glgvw.odf 120.39 2011/02/18 13:08:22 sommukhe ship $ */ sus.rowid ROW_ID, sus.ledger_id LEDGER_ID, src.user_je_source_name USER_JE_SOURCE_NAME, sus.je_source_name JE_SOURCE_NAME, cat.user_je_category_name USER_JE_CATEGORY_NAME, sus.je_category_name JE_CATEGORY_NAME FROM gl_je_sources src, gl_je_categories cat, gl_suspense_accounts sus WHERE sus.je_source_name = src.je_source_name AND sus.je_category_name = cat.je_category_name

View Text - HTML Formatted

SELECT /*$HEADER: GLGVW.ODF 120.39 2011/02/18 13:08:22 SOMMUKHE SHIP $ */ SUS.ROWID ROW_ID
, SUS.LEDGER_ID LEDGER_ID
, SRC.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, SUS.JE_SOURCE_NAME JE_SOURCE_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, SUS.JE_CATEGORY_NAME JE_CATEGORY_NAME
FROM GL_JE_SOURCES SRC
, GL_JE_CATEGORIES CAT
, GL_SUSPENSE_ACCOUNTS SUS
WHERE SUS.JE_SOURCE_NAME = SRC.JE_SOURCE_NAME
AND SUS.JE_CATEGORY_NAME = CAT.JE_CATEGORY_NAME