VIEW: OZF.OZF_ACT_OFFERS#

Source

View Text - Preformatted

select ACTIVITY_OFFER_ID ACTIVITY_OFFER_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACT_OFFER_USED_BY_ID ACT_OFFER_USED_BY_ID, ARC_ACT_OFFER_USED_BY ARC_ACT_OFFER_USED_BY, PRIMARY_OFFER_FLAG PRIMARY_OFFER_FLAG, OFFER_TYPE OFFER_TYPE, OFFER_CODE OFFER_CODE, ACTIVE_PERIOD_SET ACTIVE_PERIOD_SET, ACTIVE_PERIOD ACTIVE_PERIOD, START_DATE START_DATE, END_DATE END_DATE, ORDER_DATE_FROM ORDER_DATE_FROM, ORDER_DATE_TO ORDER_DATE_TO, SHIP_DATE_FROM SHIP_DATE_FROM, SHIP_DATE_TO SHIP_DATE_TO, PERF_DATE_FROM PERF_DATE_FROM, PERF_DATE_TO PERF_DATE_TO, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, OFFER_AMOUNT OFFER_AMOUNT, LUMPSUM_PAYMENT_TYPE LUMPSUM_PAYMENT_TYPE, QP_LIST_HEADER_ID QP_LIST_HEADER_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, CUSTOM_SETUP_ID CUSTOM_SETUP_ID from "OZF"."OZF_ACT_OFFERS"

View Text - HTML Formatted

SELECT ACTIVITY_OFFER_ID ACTIVITY_OFFER_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACT_OFFER_USED_BY_ID ACT_OFFER_USED_BY_ID
, ARC_ACT_OFFER_USED_BY ARC_ACT_OFFER_USED_BY
, PRIMARY_OFFER_FLAG PRIMARY_OFFER_FLAG
, OFFER_TYPE OFFER_TYPE
, OFFER_CODE OFFER_CODE
, ACTIVE_PERIOD_SET ACTIVE_PERIOD_SET
, ACTIVE_PERIOD ACTIVE_PERIOD
, START_DATE START_DATE
, END_DATE END_DATE
, ORDER_DATE_FROM ORDER_DATE_FROM
, ORDER_DATE_TO ORDER_DATE_TO
, SHIP_DATE_FROM SHIP_DATE_FROM
, SHIP_DATE_TO SHIP_DATE_TO
, PERF_DATE_FROM PERF_DATE_FROM
, PERF_DATE_TO PERF_DATE_TO
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, OFFER_AMOUNT OFFER_AMOUNT
, LUMPSUM_PAYMENT_TYPE LUMPSUM_PAYMENT_TYPE
, QP_LIST_HEADER_ID QP_LIST_HEADER_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
FROM "OZF"."OZF_ACT_OFFERS"