Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

SH


A B C D E F I M O P Q R S T U W 

A

ACCESS_PREDICATES column of table PLAN_TABLE
AMOUNT_SOLD column of table SALES
AMOUNT_SOLD column of table SALES_TRANSACTIONS_EXT

B

BAD_ROWID column of table MVIEW$_EXCEPTIONS
BYTES column of table PLAN_TABLE

C

CAL_MONTH_SALES_MV table
CALENDAR_MONTH_DESC column of table CAL_MONTH_SALES_MV
CALENDAR_MONTH_DESC column of table TIMES
CALENDAR_MONTH_NAME column of table TIMES
CALENDAR_MONTH_NUMBER column of table TIMES
CALENDAR_QUARTER_DESC column of table TIMES
CALENDAR_QUARTER_NUMBER column of table TIMES
CALENDAR_WEEK_NUMBER column of table TIMES
CALENDAR_YEAR column of table TIMES
CAPABILITY_NAME column of table MV_CAPABILITIES_TABLE
CARDINALITY column of table PLAN_TABLE
CHAN_DESC_NN constraint of table CHANNELS
CHAN_PK constraint of table CHANNELS
CHAN_PK index of table CHANNELS
CHANNEL_CLASS column of table CHANNELS
CHANNEL_DESC column of table CHANNELS
CHANNEL_ID column of table CHANNELS
CHANNEL_ID column of table FWEEK_PSCAT_SALES_MV
CHANNEL_ID column of table SALES
CHANNEL_ID column of table SALES_TRANSACTIONS_EXT
CHANNEL_TOTAL column of table CHANNELS
CHANNELS table
COST column of table PLAN_TABLE
COSTS table
COSTS_PROD_BIX index of table COSTS
COSTS_PRODUCT_FK constraint of table COSTS
COSTS_PRODUCT_NN constraint of table COSTS
COSTS_TIME_BIX index of table COSTS
COSTS_TIME_FK constraint of table COSTS
COSTS_TIME_NN constraint of table COSTS
COSTS_UNIT_COST_NN constraint of table COSTS
COSTS_UNIT_PRICE_NN constraint of table COSTS
COUNTRIES table
COUNTRY_COUNTRY_NAME_NN constraint of table COUNTRIES
COUNTRY_ID column of table COUNTRIES
COUNTRY_ID column of table CUSTOMERS
COUNTRY_NAME column of table COUNTRIES
COUNTRY_PK constraint of table COUNTRIES
COUNTRY_PK index of table COUNTRIES
COUNTRY_REGION column of table COUNTRIES
COUNTRY_SUBREGION column of table COUNTRIES
COUNTRY_TOTAL column of table COUNTRIES
CPU_COST column of table PLAN_TABLE
CUST_CITY column of table CUSTOMERS
CUST_CREDIT_LIMIT column of table CUSTOMERS
CUST_EMAIL column of table CUSTOMERS
CUST_FIRST_NAME column of table CUSTOMERS
CUST_GENDER column of table CUSTOMERS
CUST_ID column of table CUSTOMERS
CUST_ID column of table SALES
CUST_ID column of table SALES_TRANSACTIONS_EXT
CUST_INCOME_LEVEL column of table CUSTOMERS
CUST_LAST_NAME column of table CUSTOMERS
CUST_MAIN_PHONE_NUMBER column of table CUSTOMERS
CUST_MARITAL_STATUS column of table CUSTOMERS
CUST_POSTAL_CODE column of table CUSTOMERS
CUST_STATE_PROVINCE column of table CUSTOMERS
CUST_STREET_ADDRESS column of table CUSTOMERS
CUST_TOTAL column of table CUSTOMERS
CUST_YEAR_OF_BIRTH column of table CUSTOMERS
CUSTOMER_CITY_NN constraint of table CUSTOMERS
CUSTOMER_COUNTRY_ID_NN constraint of table CUSTOMERS
CUSTOMER_FNAME_NN constraint of table CUSTOMERS
CUSTOMER_LNAME_NN constraint of table CUSTOMERS
CUSTOMER_PCODE_NN constraint of table CUSTOMERS
CUSTOMER_ST_ADDR_NN constraint of table CUSTOMERS
CUSTOMERS table
CUSTOMERS_COUNTRY_FK constraint of table CUSTOMERS
CUSTOMERS_GENDER_BIX index of table CUSTOMERS
CUSTOMERS_MARITAL_BIX index of table CUSTOMERS
CUSTOMERS_PK constraint of table CUSTOMERS
CUSTOMERS_PK index of table CUSTOMERS
CUSTOMERS_YOB_BIX index of table CUSTOMERS

D

DAY_NAME column of table TIMES
DAY_NUMBER_IN_MONTH column of table TIMES
DAY_NUMBER_IN_WEEK column of table TIMES
DAYS_IN_CAL_MONTH column of table TIMES
DAYS_IN_CAL_QUARTER column of table TIMES
DAYS_IN_CAL_YEAR column of table TIMES
DAYS_IN_FIS_MONTH column of table TIMES
DAYS_IN_FIS_QUARTER column of table TIMES
DAYS_IN_FIS_YEAR column of table TIMES
DIMENSION_NAME column of table MVIEW$_EXCEPTIONS
DISTRIBUTION column of table PLAN_TABLE
DOLLARS column of table CAL_MONTH_SALES_MV
DOLLARS column of table FWEEK_PSCAT_SALES_MV

E

END_OF_CAL_MONTH column of table TIMES
END_OF_CAL_QUARTER column of table TIMES
END_OF_CAL_YEAR column of table TIMES
END_OF_FIS_MONTH column of table TIMES
END_OF_FIS_QUARTER column of table TIMES
END_OF_FIS_YEAR column of table TIMES

F

FILTER_PREDICATES column of table PLAN_TABLE
FISCAL_MONTH_DESC column of table TIMES
FISCAL_MONTH_NAME column of table TIMES
FISCAL_MONTH_NUMBER column of table TIMES
FISCAL_QUARTER_DESC column of table TIMES
FISCAL_QUARTER_NUMBER column of table TIMES
FISCAL_WEEK_NUMBER column of table TIMES
FISCAL_YEAR column of table TIMES
FLAGS column of table REWRITE_TABLE
FW_PSC_S_MV_CHAN_BIX index of table FWEEK_PSCAT_SALES_MV
FW_PSC_S_MV_PROMO_BIX index of table FWEEK_PSCAT_SALES_MV
FW_PSC_S_MV_SUBCAT_BIX index of table FWEEK_PSCAT_SALES_MV
FW_PSC_S_MV_WD_BIX index of table FWEEK_PSCAT_SALES_MV
FWEEK_PSCAT_SALES_MV table

I

I_SNAP$_CAL_MONTH_SALES_MV index of table CAL_MONTH_SALES_MV
I_SNAP$_FWEEK_PSCAT_SALES_ index of table FWEEK_PSCAT_SALES_MV
ID column of table PLAN_TABLE
IO_COST column of table PLAN_TABLE

M

MESSAGE column of table REWRITE_TABLE
MSGNO column of table MV_CAPABILITIES_TABLE
MSGTXT column of table MV_CAPABILITIES_TABLE
MV_CAPABILITIES_TABLE table
MV_NAME column of table REWRITE_TABLE
MV_OWNER column of table REWRITE_TABLE
MVIEW$_EXCEPTIONS table
MVNAME column of table MV_CAPABILITIES_TABLE
MVOWNER column of table MV_CAPABILITIES_TABLE

O

OBJECT_INSTANCE column of table PLAN_TABLE
OBJECT_NAME column of table PLAN_TABLE
OBJECT_NODE column of table PLAN_TABLE
OBJECT_OWNER column of table PLAN_TABLE
OBJECT_TYPE column of table PLAN_TABLE
OPERATION column of table PLAN_TABLE
OPTIMIZER column of table PLAN_TABLE
OPTIONS column of table PLAN_TABLE
OTHER column of table PLAN_TABLE
OTHER_TAG column of table PLAN_TABLE
OWNER column of table MVIEW$_EXCEPTIONS

P

PARENT_ID column of table PLAN_TABLE
PARTITION_ID column of table PLAN_TABLE
PARTITION_START column of table PLAN_TABLE
PARTITION_STOP column of table PLAN_TABLE
PASS column of table REWRITE_TABLE
PLAN_TABLE table
POSITION column of table PLAN_TABLE
POSSIBLE column of table MV_CAPABILITIES_TABLE
PROD_CAT_DESC column of table PRODUCTS
PROD_CATEGORY column of table PRODUCTS
PROD_DESC column of table PRODUCTS
PROD_ID column of table COSTS
PROD_ID column of table PRODUCTS
PROD_ID column of table SALES
PROD_ID column of table SALES_TRANSACTIONS_EXT
PROD_LIST_PRICE column of table PRODUCTS
PROD_MIN_PRICE column of table PRODUCTS
PROD_NAME column of table PRODUCTS
PROD_PACK_SIZE column of table PRODUCTS
PROD_STATUS column of table PRODUCTS
PROD_SUBCAT_DESC column of table PRODUCTS
PROD_SUBCATEGORY column of table FWEEK_PSCAT_SALES_MV
PROD_SUBCATEGORY column of table PRODUCTS
PROD_TOTAL column of table PRODUCTS
PROD_UNIT_OF_MEASURE column of table PRODUCTS
PROD_WEIGHT_CLASS column of table PRODUCTS
PRODUCTS table
PRODUCTS_PK constraint of table PRODUCTS
PRODUCTS_PK index of table PRODUCTS
PRODUCTS_PROD_CAT_IX index of table PRODUCTS
PRODUCTS_PROD_CAT_NN constraint of table PRODUCTS
PRODUCTS_PROD_CATD_NN constraint of table PRODUCTS
PRODUCTS_PROD_DESC_NN constraint of table PRODUCTS
PRODUCTS_PROD_LIST_PRICE_NN constraint of table PRODUCTS
PRODUCTS_PROD_MIN_PRICE_NN constraint of table PRODUCTS
PRODUCTS_PROD_NAME_NN constraint of table PRODUCTS
PRODUCTS_PROD_STAT_NN constraint of table PRODUCTS
PRODUCTS_PROD_STATUS_BIX index of table PRODUCTS
PRODUCTS_PROD_SUBCAT_IX index of table PRODUCTS
PRODUCTS_PROD_SUBCAT_NN constraint of table PRODUCTS
PRODUCTS_PROD_SUBCATD_NN constraint of table PRODUCTS
PROMO_BEGIN_DATE column of table PROMOTIONS
PROMO_BEGIN_DATE_NN constraint of table PROMOTIONS
PROMO_CAT_NN constraint of table PROMOTIONS
PROMO_CATEGORY column of table PROMOTIONS
PROMO_COST column of table PROMOTIONS
PROMO_COST_NN constraint of table PROMOTIONS
PROMO_END_DATE column of table PROMOTIONS
PROMO_END_DATE_NN constraint of table PROMOTIONS
PROMO_ID column of table FWEEK_PSCAT_SALES_MV
PROMO_ID column of table PROMOTIONS
PROMO_ID column of table SALES
PROMO_ID column of table SALES_TRANSACTIONS_EXT
PROMO_NAME column of table PROMOTIONS
PROMO_NAME_NN constraint of table PROMOTIONS
PROMO_PK constraint of table PROMOTIONS
PROMO_PK index of table PROMOTIONS
PROMO_SUBCAT_NN constraint of table PROMOTIONS
PROMO_SUBCATEGORY column of table PROMOTIONS
PROMO_TOTAL column of table PROMOTIONS
PROMOTIONS table

Q

QUANTITY_SOLD column of table SALES
QUANTITY_SOLD column of table SALES_TRANSACTIONS_EXT
QUERY column of table REWRITE_TABLE

R

RELATED_NUM column of table MV_CAPABILITIES_TABLE
RELATED_TEXT column of table MV_CAPABILITIES_TABLE
RELATIONSHIP column of table MVIEW$_EXCEPTIONS
REMARKS column of table PLAN_TABLE
RESERVED1 column of table REWRITE_TABLE
RESERVED2 column of table REWRITE_TABLE
REWRITE_TABLE table

S

SALES table
SALES_AMOUNT_NN constraint of table SALES
SALES_CHANNEL_BIX index of table SALES
SALES_CHANNEL_FK constraint of table SALES
SALES_CHANNEL_NN constraint of table SALES
SALES_CUST_BIX index of table SALES
SALES_CUSTOMER_FK constraint of table SALES
SALES_CUSTOMER_NN constraint of table SALES
SALES_PROD_BIX index of table SALES
SALES_PRODUCT_FK constraint of table SALES
SALES_PRODUCT_NN constraint of table SALES
SALES_PROMO_BIX index of table SALES
SALES_PROMO_FK constraint of table SALES
SALES_PROMO_NN constraint of table SALES
SALES_QUANTITY_NN constraint of table SALES
SALES_TIME_BIX index of table SALES
SALES_TIME_FK constraint of table SALES
SALES_TIME_NN constraint of table SALES
SALES_TRANSACTIONS_EXT table
SEARCH_COLUMNS column of table PLAN_TABLE
SEQ column of table MV_CAPABILITIES_TABLE
SEQUENCE column of table REWRITE_TABLE
STATEMENT_ID column of table MV_CAPABILITIES_TABLE
STATEMENT_ID column of table PLAN_TABLE
STATEMENT_ID column of table REWRITE_TABLE
SUPPLIER_ID column of table PRODUCTS
SYS_C002532 constraint of table MVIEW$_EXCEPTIONS
SYS_C002533 constraint of table MVIEW$_EXCEPTIONS
SYS_C002534 constraint of table MVIEW$_EXCEPTIONS
SYS_C002535 constraint of table MVIEW$_EXCEPTIONS
SYS_C002536 constraint of table MVIEW$_EXCEPTIONS
SYS_C002537 constraint of table CAL_MONTH_SALES_MV
SYS_C002538 constraint of table FWEEK_PSCAT_SALES_MV
SYS_C002539 constraint of table FWEEK_PSCAT_SALES_MV
SYS_C002540 constraint of table FWEEK_PSCAT_SALES_MV
SYS_C002541 constraint of table FWEEK_PSCAT_SALES_MV

T

TABLE_NAME column of table MVIEW$_EXCEPTIONS
TEMP_SPACE column of table PLAN_TABLE
TIM_CAL_MONTH_DESC_NN constraint of table TIMES
TIM_CAL_MONTH_NAME_NN constraint of table TIMES
TIM_CAL_MONTH_NUMBER_NN constraint of table TIMES
TIM_CAL_QUARTER_DESC_NN constraint of table TIMES
TIM_CAL_QUARTER_NUMBER_NN constraint of table TIMES
TIM_CAL_WEEK_NN constraint of table TIMES
TIM_CAL_YEAR_NN constraint of table TIMES
TIM_DAY_IN_MONTH_NN constraint of table TIMES
TIM_DAY_IN_WEEK_NN constraint of table TIMES
TIM_DAY_NAME_NN constraint of table TIMES
TIM_DAYS_CAL_MONTH_NN constraint of table TIMES
TIM_DAYS_CAL_QUARTER_NN constraint of table TIMES
TIM_DAYS_CAL_YEAR_NN constraint of table TIMES
TIM_DAYS_FIS_MONTH_NN constraint of table TIMES
TIM_DAYS_FIS_QUARTER_NN constraint of table TIMES
TIM_DAYS_FIS_YEAR_NN constraint of table TIMES
TIM_END_OF_CAL_MONTH_NN constraint of table TIMES
TIM_END_OF_CAL_QUARTER_NN constraint of table TIMES
TIM_END_OF_CAL_YEAR_NN constraint of table TIMES
TIM_END_OF_FIS_MONTH_NN constraint of table TIMES
TIM_END_OF_FIS_QUARTER_NN constraint of table TIMES
TIM_END_OF_FIS_YEAR_NN constraint of table TIMES
TIM_FIS_MONTH_DESC_NN constraint of table TIMES
TIM_FIS_MONTH_NAME_NN constraint of table TIMES
TIM_FIS_MONTH_NUMBER_NN constraint of table TIMES
TIM_FIS_QUARTER_DESC_NN constraint of table TIMES
TIM_FIS_QUARTER_NUMBER_NN constraint of table TIMES
TIM_FIS_WEEK_NN constraint of table TIMES
TIM_FIS_YEAR_NN constraint of table TIMES
TIM_WEEK_ENDING_DAY_NN constraint of table TIMES
TIME_ID column of table COSTS
TIME_ID column of table SALES
TIME_ID column of table SALES_TRANSACTIONS_EXT
TIME_ID column of table TIMES
TIME_PK constraint of table TIMES
TIME_PK index of table TIMES
TIMES table
TIMESTAMP column of table PLAN_TABLE

U

UNIT_COST column of table COSTS
UNIT_COST column of table SALES_TRANSACTIONS_EXT
UNIT_PRICE column of table COSTS
UNIT_PRICE column of table SALES_TRANSACTIONS_EXT

W

WEEK_ENDING_DAY column of table FWEEK_PSCAT_SALES_MV
WEEK_ENDING_DAY column of table TIMES


Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005