FND Design Data [Home] [Help]

View: GL_SUSPENSE_ACCOUNTS_LOV_V

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