[Home] [Help] [Dependency Information]
Object Name: | AMS_P_CAMPAIGN_PRODUCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_CAMPAIGN_PRODUCTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is created to store the information about the products which are associated with the campaign
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_PRODUCT_ID | NUMBER | Yes | Unique identifier | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes | |
CAMPAIGN_ID | NUMBER | Yes | Identifier of the campaign this product is associated with. | |
CAMPAIGN_NAME | VARCHAR2 | (240) | Yes | Name of the campaign this product is associated with. |
CAMPAIGN_STATUS_CODE | VARCHAR2 | (30) | Yes | Status code of the campaign |
CAMPAIGN_STATUS_DATE | DATE | Yes | Date when the campaign's status was last updated | |
CAMPAIGN_SOURCE_CODE | VARCHAR2 | (30) | Yes | Source code of the campaign this product is associated with |
ACTUAL_START_DATE | DATE | Actual execution start date for campaign | ||
ACTUAL_END_DATE | DATE | Actual execution end date for campaign | ||
CAMPAIGN_TYPE | VARCHAR2 | (30) | Type of the campaign this product is associated with. | |
LEVEL_TYPE_CODE | VARCHAR2 | (30) | Stores the level type code for this product. | |
LEVEL_TYPE | VARCHAR2 | (80) | Level type for this product. | |
CATEGORY_ID | NUMBER | Identifier of the Category of the product | ||
CATEGORY_NAME | VARCHAR2 | (163) | Name of the Category of the product | |
CATEGORY_SET_ID | NUMBER | Identifier of the category set of this product | ||
CATEGORY_SET_NAME | VARCHAR2 | (30) | Name of the category set of this product | |
ORGANIZATION_ID | NUMBER | (32) | Stores the organization id that this product belongs to. | |
INVENTORY_ITEM_ID | NUMBER | (38) | Unique key that stores the inventory item id | |
INVENTORY_ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item number of the product | |
INVENTORY_ITEM_DESCRIPTION | VARCHAR2 | (240) | Description of the item | |
EXCLUDED_FLAG | VARCHAR2 | (1) | Flag to indicate if the specified product is to be included or excluded. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_PRODUCT_ID
, OBJECT_VERSION_NUMBER
, CAMPAIGN_ID
, CAMPAIGN_NAME
, CAMPAIGN_STATUS_CODE
, CAMPAIGN_STATUS_DATE
, CAMPAIGN_SOURCE_CODE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, CAMPAIGN_TYPE
, LEVEL_TYPE_CODE
, LEVEL_TYPE
, CATEGORY_ID
, CATEGORY_NAME
, CATEGORY_SET_ID
, CATEGORY_SET_NAME
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, INVENTORY_ITEM_NUMBER
, INVENTORY_ITEM_DESCRIPTION
, EXCLUDED_FLAG
FROM APPS.AMS_P_CAMPAIGN_PRODUCTS_V;
APPS.AMS_P_CAMPAIGN_PRODUCTS_V is not referenced by any database object
|
|
|