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

VIEW: APPS.JE_NO_GEI_SREPORT_V

Object Details
Object Name: JE_NO_GEI_SREPORT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJE.JE_NO_GEI_SREPORT_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View contains accounting info based on GL_CODE_COMBINATIONS and GL_BALANCES.
View is recreated at runtime by procedure P_GEI_VIEW in report JENOGEIS. When recreated it is based on profile values set by Cst.


[View Source]

Columns
Name Datatype Length Mandatory Comments
AUTHORITY_TYPE VARCHAR2 (25)
Authority type
PERIOD VARCHAR2 (15) Yes Period
ACTUAL_FLAG VARCHAR2 (1) Yes Actual flag
ACCOUNT_NUMBER VARCHAR2 (25)
Account number
BALANCE NUMBER

Balance
TEMPLATE_ID NUMBER (15)
Template identifier
PERIOD_NUM NUMBER (15)
Period number
PERIOD_YEAR NUMBER (15)
Period year
Query Text

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


SELECT AUTHORITY_TYPE
,      PERIOD
,      ACTUAL_FLAG
,      ACCOUNT_NUMBER
,      BALANCE
,      TEMPLATE_ID
,      PERIOD_NUM
,      PERIOD_YEAR
FROM APPS.JE_NO_GEI_SREPORT_V;

Dependencies

[top of page]

APPS.JE_NO_GEI_SREPORT_V references the following:

SchemaAPPS
SynonymGL_BALANCES
SynonymGL_CODE_COMBINATIONS
ViewGL_SETS_OF_BOOKS
APPS.JE_NO_GEI_SREPORT_V is referenced by following:

SchemaAPPS
Package BodyJE_JENOGEIS_XMLP_PKG - show dependent code