[Home] [Help]
| Product: | GL - General Ledger |
|---|---|
| Description: | 10SC ONLY |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INT.ROWID ROW_ID
, INT.JE_SOURCE_NAME JE_SOURCE_NAME
, SRC.USER_JE_SOURCE_NAME USER_JE_SOURCE_NAME
, INT.JE_CATEGORY_NAME JE_CATEGORY_NAME
, CAT.USER_JE_CATEGORY_NAME USER_JE_CATEGORY_NAME
, INT.DR_CR_CODE DR_CR_CODE
, INT.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, INT.CODE_COMBINATION_ID CODE_COMBINATION_ID
, INT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, INT.LAST_UPDATED_BY LAST_UPDATED_BY
, INT.CREATION_DATE CREATION_DATE
, INT.CREATED_BY CREATED_BY
, INT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INT.ATTRIBUTE1 ATTRIBUTE1
, INT.ATTRIBUTE2 ATTRIBUTE2
, INT.ATTRIBUTE3 ATTRIBUTE3
, INT.ATTRIBUTE4 ATTRIBUTE4
, INT.ATTRIBUTE5 ATTRIBUTE5
, INT.CONTEXT CONTEXT
FROM GL_JE_CATEGORIES CAT
, GL_JE_SOURCES SRC
, GL_INTERCOMPANY_ACCOUNTS INT
WHERE INT.JE_SOURCE_NAME = SRC.JE_SOURCE_NAME
AND INT.JE_CATEGORY_NAME = CAT.JE_CATEGORY_NAME