VIEW: OZF.OZF_OFFERS#

Source

View Text - Preformatted

select OFFER_ID OFFER_ID, QP_LIST_HEADER_ID QP_LIST_HEADER_ID, OFFER_TYPE OFFER_TYPE, OFFER_CODE OFFER_CODE, REUSABLE REUSABLE, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, USER_STATUS_ID USER_STATUS_ID, OWNER_ID OWNER_ID, WF_ITEM_KEY WF_ITEM_KEY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CUSTOMER_REFERENCE CUSTOMER_REFERENCE, BUYING_GROUP_CONTACT_ID BUYING_GROUP_CONTACT_ID, PERF_DATE_FROM PERF_DATE_FROM, PERF_DATE_TO PERF_DATE_TO, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, ORDER_VALUE_DISCOUNT_TYPE ORDER_VALUE_DISCOUNT_TYPE, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE, OFFER_AMOUNT OFFER_AMOUNT, LUMPSUM_AMOUNT LUMPSUM_AMOUNT, LUMPSUM_PAYMENT_TYPE LUMPSUM_PAYMENT_TYPE, SECURITY_GROUP_ID SECURITY_GROUP_ID, DISTRIBUTION_TYPE DISTRIBUTION_TYPE, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ACCOUNT_CLOSED_FLAG ACCOUNT_CLOSED_FLAG, ACTIVITY_MEDIA_ID ACTIVITY_MEDIA_ID, QUALIFIER_ID QUALIFIER_ID, QUALIFIER_TYPE QUALIFIER_TYPE, BUDGET_OFFER_YN BUDGET_OFFER_YN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QUALIFIER_DELETED QUALIFIER_DELETED, BREAK_TYPE BREAK_TYPE, VOLUME_OFFER_TYPE VOLUME_OFFER_TYPE, CONFIDENTIAL_FLAG CONFIDENTIAL_FLAG, BUDGET_SOURCE_TYPE BUDGET_SOURCE_TYPE, BUDGET_SOURCE_ID BUDGET_SOURCE_ID, RETROACTIVE RETROACTIVE, SOURCE_FROM_PARENT SOURCE_FROM_PARENT, LAST_RECAL_DATE LAST_RECAL_DATE, BUYER_NAME BUYER_NAME, DATE_QUALIFIER_PROFILE_VALUE DATE_QUALIFIER_PROFILE_VALUE, AUTOPAY_FLAG AUTOPAY_FLAG, AUTOPAY_DAYS AUTOPAY_DAYS, AUTOPAY_METHOD AUTOPAY_METHOD, AUTOPAY_PARTY_ATTR AUTOPAY_PARTY_ATTR, AUTOPAY_PARTY_ID AUTOPAY_PARTY_ID, TIER_LEVEL TIER_LEVEL, NA_RULE_HEADER_ID NA_RULE_HEADER_ID, BENEFICIARY_ACCOUNT_ID BENEFICIARY_ACCOUNT_ID, LATEST_NA_COMPLETION_DATE LATEST_NA_COMPLETION_DATE, SALES_METHOD_FLAG SALES_METHOD_FLAG, ORG_ID ORG_ID, FUND_REQUEST_CURR_CODE FUND_REQUEST_CURR_CODE, RESALE_LINE_ID_PROCESSED RESALE_LINE_ID_PROCESSED, START_DATE START_DATE, PERCENT_DISCOUNT PERCENT_DISCOUNT from "OZF"."OZF_OFFERS"

View Text - HTML Formatted

SELECT OFFER_ID OFFER_ID
, QP_LIST_HEADER_ID QP_LIST_HEADER_ID
, OFFER_TYPE OFFER_TYPE
, OFFER_CODE OFFER_CODE
, REUSABLE REUSABLE
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, USER_STATUS_ID USER_STATUS_ID
, OWNER_ID OWNER_ID
, WF_ITEM_KEY WF_ITEM_KEY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CUSTOMER_REFERENCE CUSTOMER_REFERENCE
, BUYING_GROUP_CONTACT_ID BUYING_GROUP_CONTACT_ID
, PERF_DATE_FROM PERF_DATE_FROM
, PERF_DATE_TO PERF_DATE_TO
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, ORDER_VALUE_DISCOUNT_TYPE ORDER_VALUE_DISCOUNT_TYPE
, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, OFFER_AMOUNT OFFER_AMOUNT
, LUMPSUM_AMOUNT LUMPSUM_AMOUNT
, LUMPSUM_PAYMENT_TYPE LUMPSUM_PAYMENT_TYPE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, DISTRIBUTION_TYPE DISTRIBUTION_TYPE
, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC
, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC
, TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ACCOUNT_CLOSED_FLAG ACCOUNT_CLOSED_FLAG
, ACTIVITY_MEDIA_ID ACTIVITY_MEDIA_ID
, QUALIFIER_ID QUALIFIER_ID
, QUALIFIER_TYPE QUALIFIER_TYPE
, BUDGET_OFFER_YN BUDGET_OFFER_YN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QUALIFIER_DELETED QUALIFIER_DELETED
, BREAK_TYPE BREAK_TYPE
, VOLUME_OFFER_TYPE VOLUME_OFFER_TYPE
, CONFIDENTIAL_FLAG CONFIDENTIAL_FLAG
, BUDGET_SOURCE_TYPE BUDGET_SOURCE_TYPE
, BUDGET_SOURCE_ID BUDGET_SOURCE_ID
, RETROACTIVE RETROACTIVE
, SOURCE_FROM_PARENT SOURCE_FROM_PARENT
, LAST_RECAL_DATE LAST_RECAL_DATE
, BUYER_NAME BUYER_NAME
, DATE_QUALIFIER_PROFILE_VALUE DATE_QUALIFIER_PROFILE_VALUE
, AUTOPAY_FLAG AUTOPAY_FLAG
, AUTOPAY_DAYS AUTOPAY_DAYS
, AUTOPAY_METHOD AUTOPAY_METHOD
, AUTOPAY_PARTY_ATTR AUTOPAY_PARTY_ATTR
, AUTOPAY_PARTY_ID AUTOPAY_PARTY_ID
, TIER_LEVEL TIER_LEVEL
, NA_RULE_HEADER_ID NA_RULE_HEADER_ID
, BENEFICIARY_ACCOUNT_ID BENEFICIARY_ACCOUNT_ID
, LATEST_NA_COMPLETION_DATE LATEST_NA_COMPLETION_DATE
, SALES_METHOD_FLAG SALES_METHOD_FLAG
, ORG_ID ORG_ID
, FUND_REQUEST_CURR_CODE FUND_REQUEST_CURR_CODE
, RESALE_LINE_ID_PROCESSED RESALE_LINE_ID_PROCESSED
, START_DATE START_DATE
, PERCENT_DISCOUNT PERCENT_DISCOUNT
FROM "OZF"."OZF_OFFERS"