View: GL_SUSPENSE_ACCOUNTS_LOV_V

Product:	GL - General Ledger
Description:	10SC ONLY
Implementation/DBA Data:	APPS.GL_SUSPENSE_ACCOUNTS_LOV_V

View Text

SELECT /*$HEADER: GLGVWREG.LDT 120.29.12020000.1 2012/06/27 14:57:54 APPLDEV 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