Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_SUSPENSE_ACCOUNTS_V |
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