DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GL_SUSPENSE_ACCOUNTS_V

Object Details
Object Name: GL_SUSPENSE_ACCOUNTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_SUSPENSE_ACCOUNTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LEDGER_ID NUMBER (15) Yes
LEDGER_NAME VARCHAR2 (30) Yes
USER_JE_SOURCE_NAME VARCHAR2 (25) Yes
JE_SOURCE_NAME VARCHAR2 (25) Yes
USER_JE_CATEGORY_NAME VARCHAR2 (25) Yes
JE_CATEGORY_NAME VARCHAR2 (25) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
CONTEXT VARCHAR2 (150)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      LEDGER_ID
,      LEDGER_NAME
,      USER_JE_SOURCE_NAME
,      JE_SOURCE_NAME
,      USER_JE_CATEGORY_NAME
,      JE_CATEGORY_NAME
,      CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      CONTEXT
FROM APPS.GL_SUSPENSE_ACCOUNTS_V;

Dependencies

[top of page]

APPS.GL_SUSPENSE_ACCOUNTS_V references the following:

SchemaAPPS
SynonymGL_JE_CATEGORIES
SynonymGL_JE_SOURCES
SynonymGL_LEDGERS
SynonymGL_SUSPENSE_ACCOUNTS

APPS.GL_SUSPENSE_ACCOUNTS_V is not referenced by any database object