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

TABLE: OZF.OZF_ACTIVITY_CUSTOMERS_TEMP

Object Details
Object Name: OZF_ACTIVITY_CUSTOMERS_TEMP
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_ACTIVITY_CUSTOMERS_TEMP_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnOBJECT_CLASS
Columns
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
Query Text

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;

Dependencies

[top of page]

OZF.OZF_ACTIVITY_CUSTOMERS_TEMP does not reference any database object

OZF.OZF_ACTIVITY_CUSTOMERS_TEMP is referenced by following:

SchemaOZF
ViewOZF_ACTIVITY_CUSTOMERS_TEMP#