eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_P_OFFER_PRODUCTS_V

Object Details

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

View Type

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.

[View Source]

Columns

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.

Query Text

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;

Dependencies

[top of page]

APPS.AMS_P_OFFER_PRODUCTS_V references the following:

APPS: AMS_ACT_OFFERS; AMS_ACT_PRODUCTS_V; AMS_UTILITY_PVT - show dependent code; QP_LIST_HEADERS_VL

APPS.AMS_P_OFFER_PRODUCTS_V is not referenced by any database object