[Home] [Help] [Dependency Information]
Object Name: | GL_SHARES_OUTSTANDING |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_SHARES_OUTSTANDING |
Subobject Name: | |
Status: | VALID |
GL_SHARES_OUTSTANDING stores the number of shares outstanding information you enter in the Common Stocks form. Each record contains the fiscal year, the share measurement method (Basic or Diluted), the measurement type (Actual or Planned), and the number of shares outstanding for each quarter.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_SHARES_OUTSTANDING_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
FISCAL_YEAR SHARE_MEASURE_CODE MEASURE_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
FISCAL_YEAR | NUMBER | (15) | Yes | Fiscal year |
SHARE_MEASURE_CODE | VARCHAR2 | (30) | Yes | Share measurement method (Basic or Diluted) |
MEASURE_TYPE_CODE | VARCHAR2 | (30) | Yes | Measurement type (Actual or Planned) |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
Q1_NUMBER_OF_SHARES | NUMBER | Number of shares outstanding in quarter 1 | ||
Q2_NUMBER_OF_SHARES | NUMBER | Number of shares outstanding in quarter 2 | ||
Q3_NUMBER_OF_SHARES | NUMBER | Number of shares outstanding in quarter 3 | ||
Q4_NUMBER_OF_SHARES | NUMBER | Number of shares outstanding in quarter 4 | ||
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, FISCAL_YEAR
, SHARE_MEASURE_CODE
, MEASURE_TYPE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, Q1_NUMBER_OF_SHARES
, Q2_NUMBER_OF_SHARES
, Q3_NUMBER_OF_SHARES
, Q4_NUMBER_OF_SHARES
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_SHARES_OUTSTANDING;
GL.GL_SHARES_OUTSTANDING does not reference any database object
GL.GL_SHARES_OUTSTANDING is referenced by following:
|
|
|