[Home] [Help] [Dependency Information]
Object Name: | AMS_FORECAST_PROD_EXCLUSIONS |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_FORECAST_PROD_EXCLUSIONS |
Subobject Name: | |
Status: | VALID |
Stores the product exclusions for an object
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_FORECAST_PROD_EXCLUDE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJ_TYPE
OBJ_ID PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE PRODUCT_ATTR_VALUE |
AMS_FORECAST_PROD_EXCLUDE_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORECAST_PROD_EXCLUSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_PROD_EXCLUSION_ID | NUMBER | Yes | Forecast Product Exclusion Identifier | |
OBJ_TYPE | VARCHAR2 | (30) | Object Type | |
OBJ_ID | NUMBER | Object Identifier | ||
PRODUCT_ATTRIBUTE_CONTEXT | VARCHAR2 | (30) | Context for Pricing Contexts DFF | |
PRODUCT_ATTRIBUTE | VARCHAR2 | (30) | Attribute for for Pricing Contexts DFF | |
PRODUCT_ATTR_VALUE | VARCHAR2 | (240) | Attribute Value for Pricing Contexts DFF | |
PRODUCT_ATTRIBUTE_CONTEXT_E | VARCHAR2 | (30) | Context for for Pricing Contexts DFF | |
PRODUCT_ATTRIBUTE_E | VARCHAR2 | (30) | Attribute for Pricing Contexts DFF | |
PRODUCT_ATTR_VALUE_E | VARCHAR2 | (240) | Attribute value for Pricing Contexts DFF | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_PROD_EXCLUSION_ID
, OBJ_TYPE
, OBJ_ID
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE
, PRODUCT_ATTRIBUTE_CONTEXT_E
, PRODUCT_ATTRIBUTE_E
, PRODUCT_ATTR_VALUE_E
, SECURITY_GROUP_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM AMS.AMS_FORECAST_PROD_EXCLUSIONS;
AMS.AMS_FORECAST_PROD_EXCLUSIONS does not reference any database object
AMS.AMS_FORECAST_PROD_EXCLUSIONS is referenced by following:
|
|
|