[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_ORG_LE_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Temp Table for organization primary ledger data
OPI.OPI_DBI_ORG_LE_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization Identifier. | ||
LEDGER_ID | NUMBER | Primary Ledger Identifier. | ||
LEGAL_ENTITY_ID | NUMBER | Legal Entity Identifier. | ||
VALUATION_COST_TYPE_ID | NUMBER | Valuation Cost Type Identifier. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, LEDGER_ID
, LEGAL_ENTITY_ID
, VALUATION_COST_TYPE_ID
FROM OPI.OPI_DBI_ORG_LE_TEMP;
OPI.OPI_DBI_ORG_LE_TEMP does not reference any database object
OPI.OPI_DBI_ORG_LE_TEMP is referenced by following:
|
|
|