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

VIEW: APPS.IGI_CBR_PRIMARY_LEDGER_V

Object Details
Object Name: IGI_CBR_PRIMARY_LEDGER_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


This View list primary ledgers in the Data Access Set associated with the responsibility


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
ACCESS_SET_ID NUMBER (15)
Data access set ID
LEDGER_ID NUMBER

Ledger defining column
LEDGER_NAME VARCHAR2 (30) Yes Ledger name
CURRENCY_CODE VARCHAR2 (15) Yes Currency code
OBJECT_TYPE_CODE VARCHAR2 (1) Yes Ledger type (ledger or ledger set)
ACCESS_PRIVILEGE_CODE VARCHAR2 (1)
Access type code
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
START_DATE DATE

Start date
END_DATE DATE

End date
Query Text

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


SELECT ROW_ID
,      ACCESS_SET_ID
,      LEDGER_ID
,      LEDGER_NAME
,      CURRENCY_CODE
,      OBJECT_TYPE_CODE
,      ACCESS_PRIVILEGE_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE
,      END_DATE
FROM APPS.IGI_CBR_PRIMARY_LEDGER_V;

Dependencies

[top of page]

APPS.IGI_CBR_PRIMARY_LEDGER_V references the following:

SchemaAPPS
TableGL_ACCESS_SET_LEDGERS
SynonymGL_LEDGERS

APPS.IGI_CBR_PRIMARY_LEDGER_V is not referenced by any database object