[Home] [Help] [Dependency Information]
Object Name: | OZF_OFFERS# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OFFER_ID | NUMBER | Yes | ||
QP_LIST_HEADER_ID | NUMBER | Yes | ||
OFFER_TYPE | VARCHAR2 | (30) | Yes | |
OFFER_CODE | VARCHAR2 | (30) | Yes | |
REUSABLE | VARCHAR2 | (1) | ||
CUSTOM_SETUP_ID | NUMBER | Yes | ||
USER_STATUS_ID | NUMBER | Yes | ||
OWNER_ID | NUMBER | |||
WF_ITEM_KEY | VARCHAR2 | (120) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
CUSTOMER_REFERENCE | VARCHAR2 | (240) | ||
BUYING_GROUP_CONTACT_ID | NUMBER | |||
PERF_DATE_FROM | DATE | |||
PERF_DATE_TO | DATE | |||
STATUS_CODE | VARCHAR2 | (30) | ||
STATUS_DATE | DATE | |||
ORDER_VALUE_DISCOUNT_TYPE | VARCHAR2 | (30) | ||
MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | ||
OFFER_AMOUNT | NUMBER | |||
LUMPSUM_AMOUNT | NUMBER | |||
LUMPSUM_PAYMENT_TYPE | VARCHAR2 | (30) | ||
SECURITY_GROUP_ID | NUMBER | |||
DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
BUDGET_AMOUNT_FC | NUMBER | |||
BUDGET_AMOUNT_TC | NUMBER | |||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | (15) | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACCOUNT_CLOSED_FLAG | VARCHAR2 | (1) | ||
ACTIVITY_MEDIA_ID | NUMBER | |||
QUALIFIER_ID | NUMBER | |||
QUALIFIER_TYPE | VARCHAR2 | (30) | ||
BUDGET_OFFER_YN | VARCHAR2 | (1) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
QUALIFIER_DELETED | VARCHAR2 | (1) | ||
BREAK_TYPE | VARCHAR2 | (30) | ||
VOLUME_OFFER_TYPE | VARCHAR2 | (30) | ||
CONFIDENTIAL_FLAG | VARCHAR2 | (1) | ||
BUDGET_SOURCE_TYPE | VARCHAR2 | (30) | ||
BUDGET_SOURCE_ID | NUMBER | |||
RETROACTIVE | VARCHAR2 | (1) | ||
SOURCE_FROM_PARENT | VARCHAR2 | (1) | ||
LAST_RECAL_DATE | DATE | |||
BUYER_NAME | VARCHAR2 | (240) | ||
DATE_QUALIFIER_PROFILE_VALUE | VARCHAR2 | (1) | ||
AUTOPAY_FLAG | VARCHAR2 | (1) | ||
AUTOPAY_DAYS | NUMBER | |||
AUTOPAY_METHOD | VARCHAR2 | (30) | ||
AUTOPAY_PARTY_ATTR | VARCHAR2 | (30) | ||
AUTOPAY_PARTY_ID | NUMBER | |||
TIER_LEVEL | VARCHAR2 | (30) | ||
NA_RULE_HEADER_ID | NUMBER | |||
BENEFICIARY_ACCOUNT_ID | NUMBER | |||
LATEST_NA_COMPLETION_DATE | DATE | |||
SALES_METHOD_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | |||
FUND_REQUEST_CURR_CODE | VARCHAR2 | (30) | ||
RESALE_LINE_ID_PROCESSED | NUMBER | |||
START_DATE | DATE | |||
PERCENT_DISCOUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OFFER_ID
, QP_LIST_HEADER_ID
, OFFER_TYPE
, OFFER_CODE
, REUSABLE
, CUSTOM_SETUP_ID
, USER_STATUS_ID
, OWNER_ID
, WF_ITEM_KEY
, OBJECT_VERSION_NUMBER
, CUSTOMER_REFERENCE
, BUYING_GROUP_CONTACT_ID
, PERF_DATE_FROM
, PERF_DATE_TO
, STATUS_CODE
, STATUS_DATE
, ORDER_VALUE_DISCOUNT_TYPE
, MODIFIER_LEVEL_CODE
, OFFER_AMOUNT
, LUMPSUM_AMOUNT
, LUMPSUM_PAYMENT_TYPE
, SECURITY_GROUP_ID
, DISTRIBUTION_TYPE
, BUDGET_AMOUNT_FC
, BUDGET_AMOUNT_TC
, TRANSACTION_CURRENCY_CODE
, FUNCTIONAL_CURRENCY_CODE
, ACCOUNT_CLOSED_FLAG
, ACTIVITY_MEDIA_ID
, QUALIFIER_ID
, QUALIFIER_TYPE
, BUDGET_OFFER_YN
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, QUALIFIER_DELETED
, BREAK_TYPE
, VOLUME_OFFER_TYPE
, CONFIDENTIAL_FLAG
, BUDGET_SOURCE_TYPE
, BUDGET_SOURCE_ID
, RETROACTIVE
, SOURCE_FROM_PARENT
, LAST_RECAL_DATE
, BUYER_NAME
, DATE_QUALIFIER_PROFILE_VALUE
, AUTOPAY_FLAG
, AUTOPAY_DAYS
, AUTOPAY_METHOD
, AUTOPAY_PARTY_ATTR
, AUTOPAY_PARTY_ID
, TIER_LEVEL
, NA_RULE_HEADER_ID
, BENEFICIARY_ACCOUNT_ID
, LATEST_NA_COMPLETION_DATE
, SALES_METHOD_FLAG
, ORG_ID
, FUND_REQUEST_CURR_CODE
, RESALE_LINE_ID_PROCESSED
, START_DATE
, PERCENT_DISCOUNT
FROM OZF.OZF_OFFERS#;
|
|
|