[Home] [Help] [Dependency Information]
Object Name: | AMS_P_CAMPAIGN_OFFERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_CAMPAIGN_OFFERS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is created for the general information about the offers associated with marketing campaigns.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_OFFER_ID | NUMBER | Yes | Unique Identifier | |
CAMPAIGN_ID | NUMBER | Yes | Identifier of the campaign | |
CAMPAIGN_NAME | VARCHAR2 | (240) | Yes | Name of the campaign |
CAMPAIGN_START_DATE | DATE | Actual execution start date for the campaign | ||
CAMPAIGN_END_DATE | DATE | Actual execution end date for the campaign | ||
CAMPAIGN_SOURCE_CODE | VARCHAR2 | (30) | Yes | Campaign source code |
CAMPAIGN_STATUS_CODE | VARCHAR2 | (30) | Yes | System status code for campaign |
OFFER_NAME | VARCHAR2 | (240) | Yes | Name of the offer |
OFFER_CODE | VARCHAR2 | (30) | Yes | Offer source code |
OFFER_TYPE | VARCHAR2 | (4000) | Offer type | |
OFFER_CURRENCY_CODE | VARCHAR2 | (30) | Currency code for Offer | |
START_DATE_EFFECTIVE | DATE | Offer start date | ||
END_DATE_EFFECTIVE | DATE | Offer end date | ||
AUTOMATIC_FLAG | VARCHAR2 | (1) | Flag that indicates if the offer is automatic | |
PRIMARY_OFFER_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if the the offer is the primary offer of the campaign |
QP_LIST_HEADER_ID | NUMBER | Yes | Identifier of the price list header | |
ORDER_DATE_FROM | DATE | Start of the order dates the offer is valid from | ||
ORDER_DATE_TO | DATE | End of the order dates the offer is valid from | ||
SHIP_DATE_FROM | DATE | Offer will be valid if the order is shipped from this date | ||
SHIP_DATE_TO | DATE | Offer will be valid if the order is shipped till this date | ||
PERF_DATE_FROM | DATE | Performance measurement dates for the retailer | ||
PERF_DATE_TO | DATE | Performance measurement dates for the retailer | ||
STATUS_CODE | VARCHAR2 | (30) | Status code of the offer | |
STATUS_DATE | DATE | Date of the last status change | ||
OFFER_AMOUNT | NUMBER | Offer Amount | ||
LUMPSUM_PAYMENT_TYPE | VARCHAR2 | (30) | Lumpsum Payment type | |
REUSABLE | VARCHAR2 | (1) | Flag to indicate if the offer is reusable. | |
LUMPSUM_AMOUNT | NUMBER | Lumpsum Amount. could be percent, amount or quantity. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_OFFER_ID
, CAMPAIGN_ID
, CAMPAIGN_NAME
, CAMPAIGN_START_DATE
, CAMPAIGN_END_DATE
, CAMPAIGN_SOURCE_CODE
, CAMPAIGN_STATUS_CODE
, OFFER_NAME
, OFFER_CODE
, OFFER_TYPE
, OFFER_CURRENCY_CODE
, START_DATE_EFFECTIVE
, END_DATE_EFFECTIVE
, AUTOMATIC_FLAG
, PRIMARY_OFFER_FLAG
, QP_LIST_HEADER_ID
, ORDER_DATE_FROM
, ORDER_DATE_TO
, SHIP_DATE_FROM
, SHIP_DATE_TO
, PERF_DATE_FROM
, PERF_DATE_TO
, STATUS_CODE
, STATUS_DATE
, OFFER_AMOUNT
, LUMPSUM_PAYMENT_TYPE
, REUSABLE
, LUMPSUM_AMOUNT
FROM APPS.AMS_P_CAMPAIGN_OFFERS_V;
APPS.AMS_P_CAMPAIGN_OFFERS_V is not referenced by any database object
|
|
|