DBA Data[Home] [Help]

VIEW: AR.HZ_SECURITY_ISSUED#

Source

View Text - Preformatted

select SECURITY_ISSUED_ID SECURITY_ISSUED_ID, ESTIMATED_TOTAL_AMOUNT ESTIMATED_TOTAL_AMOUNT, PARTY_ID PARTY_ID, STOCK_EXCHANGE_ID STOCK_EXCHANGE_ID, SECURITY_ISSUED_CLASS SECURITY_ISSUED_CLASS, SECURITY_ISSUED_NAME SECURITY_ISSUED_NAME, TOTAL_AMOUNT_IN_A_CURRENCY TOTAL_AMOUNT_IN_A_CURRENCY, STOCK_TICKER_SYMBOL STOCK_TICKER_SYMBOL, SECURITY_CURRENCY_CODE SECURITY_CURRENCY_CODE, BEGIN_DATE BEGIN_DATE, END_DATE END_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, WH_UPDATE_DATE WH_UPDATE_DATE, STATUS STATUS from "AR"."HZ_SECURITY_ISSUED"
View Text - HTML Formatted

SELECT SECURITY_ISSUED_ID SECURITY_ISSUED_ID
, ESTIMATED_TOTAL_AMOUNT ESTIMATED_TOTAL_AMOUNT
, PARTY_ID PARTY_ID
, STOCK_EXCHANGE_ID STOCK_EXCHANGE_ID
, SECURITY_ISSUED_CLASS SECURITY_ISSUED_CLASS
, SECURITY_ISSUED_NAME SECURITY_ISSUED_NAME
, TOTAL_AMOUNT_IN_A_CURRENCY TOTAL_AMOUNT_IN_A_CURRENCY
, STOCK_TICKER_SYMBOL STOCK_TICKER_SYMBOL
, SECURITY_CURRENCY_CODE SECURITY_CURRENCY_CODE
, BEGIN_DATE BEGIN_DATE
, END_DATE END_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE WH_UPDATE_DATE
, STATUS STATUS
FROM "AR"."HZ_SECURITY_ISSUED"