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


VIEW: APPS.GL_CONS_SET_NAMES_V

Object Details
Object Name: GL_CONS_SET_NAMES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_CONS_SET_NAMES_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
CONSOLIDATION_SET_ID NUMBER (15) Yes Consolidation set defining column
CONS_SET_NAME VARCHAR2 (30) Yes Consolidation set name
DESCRIPTION VARCHAR2 (240)
Consolidation set description
TO_LEDGER_ID NUMBER (15) Yes
JOURNAL_IMPORT_FLAG VARCHAR2 (1)
RUN_POSTING_FLAG VARCHAR2 (1)
SUMMARIZE_LINES_FLAG VARCHAR2 (1)
AUDIT_MODE_FLAG VARCHAR2 (1)
METHOD_CODE VARCHAR2 (1)
METHOD_MEANING VARCHAR2 (80) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CONS_LEDGER_FLAG VARCHAR2 (1) Yes
ADB_FLAG VARCHAR2 (1) Yes
CALENDAR VARCHAR2 (15) Yes
PERIOD_TYPE VARCHAR2 (15) Yes
TO_SHORT_NAME VARCHAR2 (20) Yes
TO_LEDGER_NAME VARCHAR2 (30) Yes
TO_LEDGER_DESC VARCHAR2 (240)
VIEW_PRIVILEGE VARCHAR2 (1)
USE_PRIVILEGE VARCHAR2 (1)
MODIFY_PRIVILEGE VARCHAR2 (1)
Query Text

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


SELECT CONSOLIDATION_SET_ID
,      CONS_SET_NAME
,      DESCRIPTION
,      TO_LEDGER_ID
,      JOURNAL_IMPORT_FLAG
,      RUN_POSTING_FLAG
,      SUMMARIZE_LINES_FLAG
,      AUDIT_MODE_FLAG
,      METHOD_CODE
,      METHOD_MEANING
,      CURRENCY_CODE
,      CONS_LEDGER_FLAG
,      ADB_FLAG
,      CALENDAR
,      PERIOD_TYPE
,      TO_SHORT_NAME
,      TO_LEDGER_NAME
,      TO_LEDGER_DESC
,      VIEW_PRIVILEGE
,      USE_PRIVILEGE
,      MODIFY_PRIVILEGE
FROM APPS.GL_CONS_SET_NAMES_V;

Dependencies

[top of page]

APPS.GL_CONS_SET_NAMES_V references the following:

SchemaAPPS
PL/SQL PackageFND_DATA_SECURITY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_CONSOLIDATION_SETS
SynonymGL_LEDGERS
ViewGL_LOOKUPS

APPS.GL_CONS_SET_NAMES_V is not referenced by any database object