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


VIEW: APPS.GL_JE_BATCHES_POST_V

Object Details
Object Name: GL_JE_BATCHES_POST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_JE_BATCHES_POST_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)
JE_BATCH_ID NUMBER (15) Yes
NAME VARCHAR2 (100) Yes
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
PERIOD_SET_NAME VARCHAR2 (15) Yes
ACCOUNTED_PERIOD_TYPE VARCHAR2 (15) Yes
ACTUAL_FLAG VARCHAR2 (1) Yes
STATUS VARCHAR2 (1) Yes
STATUS_VERIFIED VARCHAR2 (1) Yes
DEFAULT_PERIOD_NAME VARCHAR2 (15)
DEFAULT_EFFECTIVE_DATE DATE
Yes
BUDGETARY_CONTROL_STATUS VARCHAR2 (1) Yes
APPROVAL_STATUS_CODE VARCHAR2 (1) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CONTROL_TOTAL NUMBER

RUNNING_TOTAL_DR NUMBER

RUNNING_TOTAL_CR NUMBER

POSTING_RUN_ID NUMBER (15)
REQUEST_ID NUMBER (15)
PERIOD_YEAR NUMBER (15) Yes
PERIOD_NUM NUMBER (15) Yes
Query Text

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


SELECT ROW_ID
,      JE_BATCH_ID
,      NAME
,      CHART_OF_ACCOUNTS_ID
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      ACTUAL_FLAG
,      STATUS
,      STATUS_VERIFIED
,      DEFAULT_PERIOD_NAME
,      DEFAULT_EFFECTIVE_DATE
,      BUDGETARY_CONTROL_STATUS
,      APPROVAL_STATUS_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CONTROL_TOTAL
,      RUNNING_TOTAL_DR
,      RUNNING_TOTAL_CR
,      POSTING_RUN_ID
,      REQUEST_ID
,      PERIOD_YEAR
,      PERIOD_NUM
FROM APPS.GL_JE_BATCHES_POST_V;

Dependencies

[top of page]

APPS.GL_JE_BATCHES_POST_V references the following:

SchemaAPPS
TableGL_ACCESS_SET_LEDGERS
SynonymGL_JE_BATCHES
PL/SQL PackageGL_JE_BATCHES_POST_PKG - show dependent code
SynonymGL_JE_HEADERS
SynonymGL_PERIODS

APPS.GL_JE_BATCHES_POST_V is not referenced by any database object