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

VIEW: APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_PRODUCT_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9)
MASTER_OBJECT_TYPE VARCHAR2 (30) Yes
MASTER_OBJECT_TYPE_MEANING VARCHAR2 (80)
MASTER_OBJECT_ID NUMBER
Yes
LEVEL_TYPE_CODE VARCHAR2 (30)
LEVEL_TYPE VARCHAR2 (80)
CATEGORY_ID NUMBER

CATEGORY_NAME VARCHAR2 (163)
CATEGORY_SET_ID NUMBER

CATEGORY_SET_NAME VARCHAR2 (30)
ORGANIZATION_ID NUMBER (32)
INVENTORY_ITEM_ID NUMBER (38)
INVENTORY_ITEM_NUMBER VARCHAR2 (40)
INVENTORY_ITEM_DESCRIPTION VARCHAR2 (240)
LIST_PRICE_PER_UNIT NUMBER

BASE_SALES_QUANTITY NUMBER

BASE_SALES_UOM_CODE VARCHAR2 (3)
PERIOD_ID NUMBER

PERIOD_TYPE VARCHAR2 (30)
ON_DATE DATE

Query Text

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


SELECT ACTIVITY_PRODUCT_ID
,      OBJECT_VERSION_NUMBER
,      MASTER_OBJECT_TYPE
,      MASTER_OBJECT_TYPE_MEANING
,      MASTER_OBJECT_ID
,      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
,      LIST_PRICE_PER_UNIT
,      BASE_SALES_QUANTITY
,      BASE_SALES_UOM_CODE
,      PERIOD_ID
,      PERIOD_TYPE
,      ON_DATE
FROM APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V;

Dependencies

[top of page]

APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V references the following:

SchemaAPPS
ViewAMS_ACT_PRODUCTS_V
SynonymAMS_BASE_SALES_VOL_ALL
ViewMTL_SYSTEM_ITEMS_VL

APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V is not referenced by any database object