[Home] [Help]
[Dependency Information]
[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#;
OZF
OZF_OFFERS
APPS
OZF_OFFERS
|
|
|
|