[Home] [Help] [Dependency Information]
Object Name: | HZ_SECURITY_ISSUED |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_SECURITY_ISSUED |
Subobject Name: | |
Status: | VALID |
The HZ_SECURITY_ISSUED table stores information about the financial instruments such as stocks and bonds that were issued by an organization. These financial instruments may vary depending upon the securities market on which they are offered.
.
The primary key for this table is SECURITY_ISSUED_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_SECURITY_ISSUED_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SECURITY_ISSUED_ID |
HZ_SECURITY_ISSUED_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_ID |
HZ_SECURITY_ISSUED_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STOCK_EXCHANGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECURITY_ISSUED_ID | NUMBER | (10) | Yes | Unique identifier of the security issued |
ESTIMATED_TOTAL_AMOUNT | NUMBER | The total value in whole numbers of the security issued by an organization. | ||
PARTY_ID | NUMBER | (15) | Yes | Identifier for the party. Foreign key to the HZ_PARTIES table. |
STOCK_EXCHANGE_ID | NUMBER | (15) | Yes | Stock exchange identifier. Foreign key to the HZ_STOCK_MARKETS table |
SECURITY_ISSUED_CLASS | VARCHAR2 | (30) | Security classes include public stock, common stock, preferred stock, gilt-edged bonds, debentures, and so on. The classes of securities issued vary from market to market. | |
SECURITY_ISSUED_NAME | VARCHAR2 | (240) | A text field that lets you assign a descriptive name to a security. | |
TOTAL_AMOUNT_IN_A_CURRENCY | VARCHAR2 | (240) | Indicates the estimated total amount of currency for the security issued. | |
STOCK_TICKER_SYMBOL | VARCHAR2 | (60) | The series of characters that identify a security such as a common stock, bond, or mutual fund. The characters are assigned by the trading market where the security is traded. | |
SECURITY_CURRENCY_CODE | VARCHAR2 | (15) | The currency in which the security is issued. Foreign key to the FND_CURRENCIES table | |
BEGIN_DATE | DATE | Any date/time combination that indicates the date that the security was first issued. | ||
END_DATE | DATE | Any date/time combination that indicates if the security is retired from trading. | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | ||
STATUS | VARCHAR2 | (1) | Record status flag |
Cut, paste (and edit) the following text to query this object:
SELECT SECURITY_ISSUED_ID
, ESTIMATED_TOTAL_AMOUNT
, PARTY_ID
, STOCK_EXCHANGE_ID
, SECURITY_ISSUED_CLASS
, SECURITY_ISSUED_NAME
, TOTAL_AMOUNT_IN_A_CURRENCY
, STOCK_TICKER_SYMBOL
, SECURITY_CURRENCY_CODE
, BEGIN_DATE
, END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, STATUS
FROM AR.HZ_SECURITY_ISSUED;
AR.HZ_SECURITY_ISSUED does not reference any database object
AR.HZ_SECURITY_ISSUED is referenced by following:
|
|
|