[Home] [Help] [Dependency Information]
Object Name: | IGI_CBR_PRIMARY_LEDGER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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
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 |
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;
APPS.IGI_CBR_PRIMARY_LEDGER_V is not referenced by any database object
|
|
|