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


VIEW: APPS.AMS_CAMPAIGN_PRODUCTS_V

Object Details
Object Name: AMS_CAMPAIGN_PRODUCTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_CAMPAIGN_PRODUCTS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER

PRODUCT_ID NUMBER

PRODUCT_NAME VARCHAR2 (163)
PRODUCT_TYPE VARCHAR2 (7)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CAMPAIGN_ID
,      PRODUCT_ID
,      PRODUCT_NAME
,      PRODUCT_TYPE
FROM APPS.AMS_CAMPAIGN_PRODUCTS_V;

Dependencies

[top of page]

APPS.AMS_CAMPAIGN_PRODUCTS_V references the following:

SchemaAPPS
SynonymAMS_ACT_OFFERS
ViewMTL_CATEGORIES_V
ViewMTL_SYSTEM_ITEMS_VL
SynonymQP_LIST_LINES
SynonymQP_PRICING_ATTRIBUTES

APPS.AMS_CAMPAIGN_PRODUCTS_V is not referenced by any database object