[Home] [Help]
View: GL_SUSPENSE_ACCOUNTS_LOV_V
View Text
SELECT /*$HEADER: GLGVWREG.LDT 120.16.12010000.5 2009/02/11 04:46:50 KMOTEPAL 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
Columns
Name |
ROW_ID |
LEDGER_ID |
USER_JE_SOURCE_NAME |
JE_SOURCE_NAME |
USER_JE_CATEGORY_NAME |
JE_CATEGORY_NAME |