[Home] [Help] [Dependency Information]
Object Name: | AMS_P_OFFER_PRODUCTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_OFFER_PRODUCTS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This public view is created for the general information about products associated with offers.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_PRODUCT_ID | NUMBER | Yes | Identifier fot Activity Product | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes | |
OFFER_ID | NUMBER | Yes | Identifier for the Offer. | |
OFFER_NAME | VARCHAR2 | (2000) | Name of the Offer | |
OFFER_STATUS_CODE | VARCHAR2 | (30) | Offer Status | |
OFFER_STATUS_DATE | DATE | Date when the status last changed. | ||
OFFER_CODE | VARCHAR2 | (30) | Offer Code | |
OFFER_START_DATE | DATE | Offer Start Date | ||
OFFER_END_DATE | DATE | Offer end Date | ||
OFFER_TYPE | VARCHAR2 | (30) | Type of the offer | |
OFFER_TYPE_NAME | VARCHAR2 | (4000) | Offer type meaning | |
LEVEL_TYPE_CODE | VARCHAR2 | (30) | Stores the level type code for this product. | |
LEVEL_TYPE | VARCHAR2 | (80) | Stores the 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) | Inventory Item description | |
EXCLUDED_FLAG | VARCHAR2 | (1) | Flag indicates whether the product to be included or excluded for the offer. |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_PRODUCT_ID
, OBJECT_VERSION_NUMBER
, OFFER_ID
, OFFER_NAME
, OFFER_STATUS_CODE
, OFFER_STATUS_DATE
, OFFER_CODE
, OFFER_START_DATE
, OFFER_END_DATE
, OFFER_TYPE
, OFFER_TYPE_NAME
, 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_OFFER_PRODUCTS_V;
APPS.AMS_P_OFFER_PRODUCTS_V is not referenced by any database object
|
|
|