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

TABLE: OZF.OZF_NA_CUSTOMERS_TEMP

Object Details
Object Name: OZF_NA_CUSTOMERS_TEMP
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_NA_CUSTOMERS_TEMP
Subobject Name:
Status: VALID


This table is used by the Net accrual engine to derive all the customers that are eligible for the Net Accrual Offer. This table has the same structure as OZF_ACTIVITY_CUSTOMERS but is deleted after the net accrual processing is completed.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER

Object Id
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 Id
PARENT_DESC VARCHAR2 (250)
Parent Desc
PARENT_CLASS VARCHAR2 (30)
Parent Class
PARENT_TYPE VARCHAR2 (30)
Parent Type
PARENT_STATUS VARCHAR2 (30)
Parent Status
PARTY_ID NUMBER

Party Id
CUST_ACCOUNT_ID NUMBER

Cust Account Id
CUST_ACCT_SITE_ID NUMBER

Cust Acct Site Id
SITE_USE_ID NUMBER

Site Use Id
SITE_USE_CODE VARCHAR2 (30)
Site Use Code
QUALIFIER_CONTEXT VARCHAR2 (30)
Qualifier Context
QUALIFIER_ATTRIBUTE VARCHAR2 (30)
Qualifier Attribute
OWNER_ID NUMBER

Owner Id
SOURCE_CODE VARCHAR2 (30)
Source Code
ACTIVITY_TYPE_CODE VARCHAR2 (30)
Activity Type Code
ACTIVITY_ID NUMBER

Activity Id
MARKETING_MEDIUM_ID NUMBER

Marketing Medium Id
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 Units
ACTUAL_REVENUE NUMBER

Actual Revenue
ACTUAL_COSTS NUMBER

Actual Costs
ACTUAL_ROI NUMBER

Actual Roi
FORECAST_UNITS NUMBER

Forecast Units
FORECAST_REVENUE NUMBER

Forecast Revenue
FORECAST_COSTS NUMBER

Forecast Costs
FORECAST_ROI NUMBER

Forecast Roi
CONFIDENTIAL_FLAG VARCHAR2 (1)
Confidential Flag
CUSTOM_SETUP_ID NUMBER

Custom Setup Id
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATED_BY NUMBER

Last Updated By
CREATION_DATE DATE

Creation Date
CREATED_BY NUMBER

Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
PROD_INDICATOR VARCHAR2 (30)
Prod Indicator
Query Text

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


SELECT 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
FROM OZF.OZF_NA_CUSTOMERS_TEMP;

Dependencies

[top of page]

OZF.OZF_NA_CUSTOMERS_TEMP does not reference any database object

OZF.OZF_NA_CUSTOMERS_TEMP is referenced by following:

SchemaOZF
ViewOZF_NA_CUSTOMERS_TEMP#