[Home] [Help] [Dependency Information]
Object Name: | OZF_NA_CUSTOMERS_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | |||
OBJECT_CLASS | VARCHAR2 | (30) | ||
OBJECT_TYPE | VARCHAR2 | (30) | ||
OBJECT_DESC | VARCHAR2 | (2000) | ||
OBJECT_STATUS | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
PARENT_ID | NUMBER | |||
PARENT_DESC | VARCHAR2 | (250) | ||
PARENT_CLASS | VARCHAR2 | (30) | ||
PARENT_TYPE | VARCHAR2 | (30) | ||
PARENT_STATUS | VARCHAR2 | (30) | ||
PARTY_ID | NUMBER | |||
CUST_ACCOUNT_ID | NUMBER | |||
CUST_ACCT_SITE_ID | NUMBER | |||
SITE_USE_ID | NUMBER | |||
SITE_USE_CODE | VARCHAR2 | (30) | ||
QUALIFIER_CONTEXT | VARCHAR2 | (30) | ||
QUALIFIER_ATTRIBUTE | VARCHAR2 | (30) | ||
OWNER_ID | NUMBER | |||
SOURCE_CODE | VARCHAR2 | (30) | ||
ACTIVITY_TYPE_CODE | VARCHAR2 | (30) | ||
ACTIVITY_ID | NUMBER | |||
MARKETING_MEDIUM_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (10) | ||
OFFER_CODE | VARCHAR2 | (30) | ||
ASK_FOR_FLAG | VARCHAR2 | (1) | ||
ACTIVE_FLAG | VARCHAR2 | (1) | ||
ACTUAL_UNITS | NUMBER | |||
ACTUAL_REVENUE | NUMBER | |||
ACTUAL_COSTS | NUMBER | |||
ACTUAL_ROI | NUMBER | |||
FORECAST_UNITS | NUMBER | |||
FORECAST_REVENUE | NUMBER | |||
FORECAST_COSTS | NUMBER | |||
FORECAST_ROI | NUMBER | |||
CONFIDENTIAL_FLAG | VARCHAR2 | (1) | ||
CUSTOM_SETUP_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
PROD_INDICATOR | VARCHAR2 | (30) |
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#;
|
|
|