VIEW: APPS.GL_SUSPENSE_ACCOUNTS_V

Source

View Text - Preformatted

SELECT sus.rowid ROW_ID, sus.ledger_id LEDGER_ID, led.name LEDGER_NAME, 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, sus.code_combination_id CODE_COMBINATION_ID, sus.last_update_date LAST_UPDATE_DATE, sus.last_updated_by LAST_UPDATED_BY, sus.creation_date CREATION_DATE, sus.created_by CREATED_BY, sus.last_update_login LAST_UPDATE_LOGIN, sus.attribute1 ATTRIBUTE1, sus.attribute2 ATTRIBUTE2, sus.attribute3 ATTRIBUTE3, sus.attribute4 ATTRIBUTE4, sus.attribute5 ATTRIBUTE5, sus.context CONTEXT FROM gl_je_sources src, gl_je_categories cat, gl_suspense_accounts sus, gl_ledgers led WHERE sus.je_source_name = src.je_source_name AND sus.je_category_name = cat.je_category_name AND sus.ledger_id=led.ledger_id

View Text - HTML Formatted

SELECT SUS.ROWID ROW_ID
, SUS.LEDGER_ID LEDGER_ID
, LED.NAME LEDGER_NAME
, 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
, SUS.CODE_COMBINATION_ID CODE_COMBINATION_ID
, SUS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SUS.LAST_UPDATED_BY LAST_UPDATED_BY
, SUS.CREATION_DATE CREATION_DATE
, SUS.CREATED_BY CREATED_BY
, SUS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUS.ATTRIBUTE1 ATTRIBUTE1
, SUS.ATTRIBUTE2 ATTRIBUTE2
, SUS.ATTRIBUTE3 ATTRIBUTE3
, SUS.ATTRIBUTE4 ATTRIBUTE4
, SUS.ATTRIBUTE5 ATTRIBUTE5
, SUS.CONTEXT CONTEXT
FROM GL_JE_SOURCES SRC
, GL_JE_CATEGORIES CAT
, GL_SUSPENSE_ACCOUNTS SUS
, GL_LEDGERS LED
WHERE SUS.JE_SOURCE_NAME = SRC.JE_SOURCE_NAME
AND SUS.JE_CATEGORY_NAME = CAT.JE_CATEGORY_NAME
AND SUS.LEDGER_ID=LED.LEDGER_ID