[Home] [Help] [Dependency Information]
Object Name: | AMS_CAMPAIGN_PRODUCT_VOLUMES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V |
Subobject Name: | |
Status: | VALID |
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 |
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;
APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V is not referenced by any database object
|
|
|