DBA Data[Home] [Help]

VIEW: IBE.IBE_ACTIVE_QUOTES_ALL#

Source

View Text - Preformatted

select ACTIVE_QUOTE_ID ACTIVE_QUOTE_ID, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, ORG_ID ORG_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, QUOTE_HEADER_ID QUOTE_HEADER_ID, ORDER_HEADER_ID ORDER_HEADER_ID, CURRENCY_CODE CURRENCY_CODE, RECORD_TYPE RECORD_TYPE from "IBE"."IBE_ACTIVE_QUOTES_ALL"
View Text - HTML Formatted

SELECT ACTIVE_QUOTE_ID ACTIVE_QUOTE_ID
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, ORG_ID ORG_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, QUOTE_HEADER_ID QUOTE_HEADER_ID
, ORDER_HEADER_ID ORDER_HEADER_ID
, CURRENCY_CODE CURRENCY_CODE
, RECORD_TYPE RECORD_TYPE
FROM "IBE"."IBE_ACTIVE_QUOTES_ALL"