[Home] [Help] [Dependency Information]
Object Name: | OZF_ACTIVITY_CUSTOMERS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_ACTIVITY_CUSTOMERS_TEMP |
Subobject Name: | |
Status: | VALID |
OZF_ACTIVITY_CUSTOMERS_TEMP is used as temporary table to store the denormalized market eligibility for Offer and Campaign Schedules till the concurrent program to populate the table finishes processing.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_ACTIVITY_CUSTOMERS_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
OBJECT_CLASS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_CUSTOMER_ID | NUMBER | Unique Identifier | ||
OBJECT_ID | NUMBER | Object Identifier | ||
OBJECT_CLASS | VARCHAR2 | (30) | Object class | |
OBJECT_TYPE | VARCHAR2 | (30) | Object Type | |
OBJECT_DESC | VARCHAR2 | (2000) | Object Desc | |
OBJECT_STATUS | VARCHAR2 | (30) | Object Status | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
PARENT_ID | NUMBER | Parent Object identifier | ||
PARENT_DESC | VARCHAR2 | (250) | Parent Object Description | |
PARENT_CLASS | VARCHAR2 | (30) | Parent Object Class | |
PARENT_TYPE | VARCHAR2 | (30) | Parent Object Type | |
PARENT_STATUS | VARCHAR2 | (30) | Parent Object Status | |
PARTY_ID | NUMBER | Party Identifier | ||
CUST_ACCOUNT_ID | NUMBER | Customer Account Identifier | ||
CUST_ACCT_SITE_ID | NUMBER | Customer Account Site Identifier | ||
SITE_USE_ID | NUMBER | Site Use Identifier | ||
SITE_USE_CODE | VARCHAR2 | (30) | Site Use code | |
QUALIFIER_CONTEXT | VARCHAR2 | (30) | Market Qualfier context | |
QUALIFIER_ATTRIBUTE | VARCHAR2 | (30) | Market Qualfier Attribute | |
OWNER_ID | NUMBER | Object Owner Identifier | ||
SOURCE_CODE | VARCHAR2 | (30) | Source code of the object | |
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | Activity Type Code | |
ACTIVITY_ID | NUMBER | Activity Identifier | ||
MARKETING_MEDIUM_ID | NUMBER | Marketing Medium Identifier | ||
CURRENCY_CODE | VARCHAR2 | (10) | Currency Code | |
OFFER_CODE | VARCHAR2 | (30) | Offer Code | |
ASK_FOR_FLAG | VARCHAR2 | (1) | Ask for Flag | |
ACTIVE_FLAG | VARCHAR2 | (1) | Active Flag | |
ACTUAL_UNITS | NUMBER | Actual Sales in units | ||
ACTUAL_REVENUE | NUMBER | Actual revenue | ||
ACTUAL_COSTS | NUMBER | Actual Costs | ||
ACTUAL_ROI | NUMBER | Actual Return on Investment | ||
FORECAST_UNITS | NUMBER | Forecasted Units | ||
FORECAST_REVENUE | NUMBER | Forecasted Revenue | ||
FORECAST_COSTS | NUMBER | Forecasted Costs | ||
FORECAST_ROI | NUMBER | Forecasted ROI | ||
CONFIDENTIAL_FLAG | VARCHAR2 | (1) | Confidential Flag | |
CUSTOM_SETUP_ID | NUMBER | Custom Setup Identifier | ||
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | Standard WHO Column | ||
CREATION_DATE | DATE | Standard WHO Column | ||
CREATED_BY | NUMBER | Standard WHO Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
PROD_INDICATOR | VARCHAR2 | (30) | Product Eligibility indicator | |
ACTUAL_UOM | VARCHAR2 | (3) | Actual Unit of Measure | |
FORECAST_UOM | VARCHAR2 | (3) | Forecast unit of measure | |
QP_QUALIFIER_ID | NUMBER | Qualifier Id | ||
QP_QUALIFIER_GROUP | NUMBER | Qualifier Group Number |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_CUSTOMER_ID
, OBJECT_ID
, OBJECT_CLASS
, OBJECT_TYPE
, OBJECT_DESC
, OBJECT_STATUS
, START_DATE
, END_DATE
, PARENT_ID
, PARENT_DESC
, PARENT_CLASS
, PARENT_TYPE
, PARENT_STATUS
, PARTY_ID
, CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID
, SITE_USE_ID
, SITE_USE_CODE
, QUALIFIER_CONTEXT
, QUALIFIER_ATTRIBUTE
, OWNER_ID
, SOURCE_CODE
, ACTIVITY_TYPE_CODE
, ACTIVITY_ID
, MARKETING_MEDIUM_ID
, CURRENCY_CODE
, OFFER_CODE
, ASK_FOR_FLAG
, ACTIVE_FLAG
, ACTUAL_UNITS
, ACTUAL_REVENUE
, ACTUAL_COSTS
, ACTUAL_ROI
, FORECAST_UNITS
, FORECAST_REVENUE
, FORECAST_COSTS
, FORECAST_ROI
, CONFIDENTIAL_FLAG
, CUSTOM_SETUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROD_INDICATOR
, ACTUAL_UOM
, FORECAST_UOM
, QP_QUALIFIER_ID
, QP_QUALIFIER_GROUP
FROM OZF.OZF_ACTIVITY_CUSTOMERS_TEMP;
OZF.OZF_ACTIVITY_CUSTOMERS_TEMP does not reference any database object
OZF.OZF_ACTIVITY_CUSTOMERS_TEMP is referenced by following:
|
|
|