OE

# A B C H I L M N O P Q S T U W

#

#_OF_PRODUCTS column of view PRODUCT_PRICES

A

ACCOUNT_MGR_ID column of table CUSTOMERS
ACCOUNT_MGR_ID column of view OC_CORPORATE_CUSTOMERS

B

BOMBAY_INVENTORY view

C

CATALOG_URL column of table PRODUCT_INFORMATION
CATALOG_URL column of view OC_PRODUCT_INFORMATION
CATALOG_URL column of view PRODUCTS
CATEGORIES_TAB table
CATEGORY_DESCRIPTION column of table CATEGORIES_TAB
CATEGORY_ID column of table CATEGORIES_TAB
CATEGORY_ID column of table PRODUCT_INFORMATION
CATEGORY_ID column of view OC_PRODUCT_INFORMATION
CATEGORY_ID column of view PRODUCT_PRICES
CATEGORY_ID column of view PRODUCTS
CATEGORY_NAME column of table CATEGORIES_TAB
CREDIT_LIMIT column of table CUSTOMERS
CREDIT_LIMIT column of view OC_CORPORATE_CUSTOMERS
CREDIT_LIMIT column of view OC_CUSTOMERS
CUST_ACCOUNT_MANAGER_IX index of table CUSTOMERS
CUST_ADDRESS column of table CUSTOMERS
CUST_ADDRESS column of view OC_CORPORATE_CUSTOMERS
CUST_ADDRESS column of view OC_CUSTOMERS
CUST_EMAIL column of table CUSTOMERS
CUST_EMAIL column of view OC_CORPORATE_CUSTOMERS
CUST_EMAIL column of view OC_CUSTOMERS
CUST_EMAIL_IX index of table CUSTOMERS
CUST_FIRST_NAME column of table CUSTOMERS
CUST_FIRST_NAME column of view OC_CORPORATE_CUSTOMERS
CUST_FIRST_NAME column of view OC_CUSTOMERS
CUST_FNAME_NN constraint of table CUSTOMERS
CUST_GEO_LOCATION column of table CUSTOMERS
CUST_LAST_NAME column of table CUSTOMERS
CUST_LAST_NAME column of view OC_CORPORATE_CUSTOMERS
CUST_LAST_NAME column of view OC_CUSTOMERS
CUST_LNAME_IX index of table CUSTOMERS
CUST_LNAME_NN constraint of table CUSTOMERS
CUST_ORDERS column of view OC_CORPORATE_CUSTOMERS
CUST_ORDERS column of view OC_CUSTOMERS
CUST_UPPER_NAME_IX index of table CUSTOMERS
CUSTOMER_CREDIT_LIMIT_MAX constraint of table CUSTOMERS
CUSTOMER_ID column of table CUSTOMERS
CUSTOMER_ID column of table ORDERS
CUSTOMER_ID column of view OC_CORPORATE_CUSTOMERS
CUSTOMER_ID column of view OC_CUSTOMERS
CUSTOMER_ID_MIN constraint of table CUSTOMERS
CUSTOMER_REF column of view OC_ORDERS
CUSTOMERS table
CUSTOMERS_ACCOUNT_MANAGER_FK constraint
CUSTOMERS_PK constraint of table CUSTOMERS
CUSTOMERS_PK index of table CUSTOMERS

H

HIGH_PRICE column of view PRODUCT_PRICES

I

INSERT_ORD_LINE trigger of table ORDER_ITEMS
INV_PRODUCT_IX index of table INVENTORIES
INV_WAREHOUSE_IX index of table INVENTORIES
INVENTORIES table
INVENTORIES_PRODUCT_ID_FK constraint of table INVENTORIES
INVENTORIES_WAREHOUSES_FK constraint of table INVENTORIES
INVENTORY_LIST column of view OC_PRODUCT_INFORMATION
INVENTORY_PK constraint of table INVENTORIES
INVENTORY_PK index of table INVENTORIES
INVENTORY_QOH_NN constraint of table INVENTORIES
INVENTORY_WAREHOUSE_ID_NN constraint of table INVENTORIES
ITEM_ORDER_IX index of table ORDER_ITEMS
ITEM_PRODUCT_IX index of table ORDER_ITEMS

L

LANGUAGE_ID column of table PRODUCT_DESCRIPTIONS
LANGUAGE_ID column of view PRODUCTS
LINE_ITEM_ID column of table ORDER_ITEMS
LIST_PRICE column of table PRODUCT_INFORMATION
LIST_PRICE column of view OC_PRODUCT_INFORMATION
LIST_PRICE column of view PRODUCTS
LOCATION_ID column of table WAREHOUSES
LOW_PRICE column of view PRODUCT_PRICES

M

MIN_PRICE column of table PRODUCT_INFORMATION
MIN_PRICE column of view OC_PRODUCT_INFORMATION
MIN_PRICE column of view PRODUCTS

N

NLS_LANGUAGE column of table CUSTOMERS
NLS_LANGUAGE column of view OC_CORPORATE_CUSTOMERS
NLS_LANGUAGE column of view OC_CUSTOMERS
NLS_TERRITORY column of table CUSTOMERS
NLS_TERRITORY column of view OC_CORPORATE_CUSTOMERS
NLS_TERRITORY column of view OC_CUSTOMERS

O

OC_CORPORATE_CUSTOMERS view
OC_CUSTOMERS view
OC_INVENTORIES view
OC_ORDERS view
OC_PRODUCT_INFORMATION view
ORD_CUSTOMER_IX index of table ORDERS
ORD_ORDER_DATE_IX index of table ORDERS
ORD_SALES_REP_IX index of table ORDERS
ORDER_CUSTOMER_ID_NN constraint of table ORDERS
ORDER_DATE column of table ORDERS
ORDER_DATE_NN constraint of table ORDERS
ORDER_ID column of table ORDER_ITEMS
ORDER_ID column of table ORDERS
ORDER_ID column of view OC_ORDERS
ORDER_ITEM_LIST column of view OC_ORDERS
ORDER_ITEMS table
ORDER_ITEMS_ORDER_ID_FK constraint of table ORDER_ITEMS
ORDER_ITEMS_PK constraint of table ORDER_ITEMS
ORDER_ITEMS_PK index of table ORDER_ITEMS
ORDER_ITEMS_PRODUCT_ID_FK constraint of table ORDER_ITEMS
ORDER_ITEMS_UK index of table ORDER_ITEMS
ORDER_MODE column of table ORDERS
ORDER_MODE column of view OC_ORDERS
ORDER_MODE_LOV constraint of table ORDERS
ORDER_PK constraint of table ORDERS
ORDER_PK index of table ORDERS
ORDER_STATUS column of table ORDERS
ORDER_STATUS column of view OC_ORDERS
ORDER_TOTAL column of table ORDERS
ORDER_TOTAL column of view OC_ORDERS
ORDER_TOTAL_MIN constraint of table ORDERS
ORDERS table
ORDERS_CUSTOMER_ID_FK constraint of table ORDERS
ORDERS_ITEMS_TRG trigger
ORDERS_SALES_REP_FK constraint
ORDERS_SEQ sequence
ORDERS_TRG trigger

P

PARENT_CATEGORY_ID column of table CATEGORIES_TAB
PD_PRODUCT_ID_FK constraint of table PRODUCT_DESCRIPTIONS
PHONE_NUMBERS column of table CUSTOMERS
PHONE_NUMBERS column of view OC_CORPORATE_CUSTOMERS
PHONE_NUMBERS column of view OC_CUSTOMERS
PRD_DESC_PK index of table PRODUCT_DESCRIPTIONS
PROD_NAME_IX index of table PRODUCT_DESCRIPTIONS
PROD_SUPPLIER_IX index of table PRODUCT_INFORMATION
PRODUCT_DESCRIPTION column of table PRODUCT_INFORMATION
PRODUCT_DESCRIPTION column of view OC_PRODUCT_INFORMATION
PRODUCT_DESCRIPTION column of view PRODUCTS
PRODUCT_DESCRIPTIONS table
PRODUCT_DESCRIPTIONS_PK constraint of table PRODUCT_DESCRIPTIONS
PRODUCT_ID column of table INVENTORIES
PRODUCT_ID column of table ORDER_ITEMS
PRODUCT_ID column of table PRODUCT_DESCRIPTIONS
PRODUCT_ID column of table PRODUCT_INFORMATION
PRODUCT_ID column of view BOMBAY_INVENTORY
PRODUCT_ID column of view OC_INVENTORIES
PRODUCT_ID column of view OC_PRODUCT_INFORMATION
PRODUCT_ID column of view PRODUCTS
PRODUCT_ID column of view SYDNEY_INVENTORY
PRODUCT_ID column of view TORONTO_INVENTORY
PRODUCT_INFORMATION table
PRODUCT_INFORMATION_PK constraint of table PRODUCT_INFORMATION
PRODUCT_INFORMATION_PK index of table PRODUCT_INFORMATION
PRODUCT_NAME column of table PRODUCT_INFORMATION
PRODUCT_NAME column of view BOMBAY_INVENTORY
PRODUCT_NAME column of view OC_PRODUCT_INFORMATION
PRODUCT_NAME column of view PRODUCTS
PRODUCT_NAME column of view SYDNEY_INVENTORY
PRODUCT_NAME column of view TORONTO_INVENTORY
PRODUCT_PRICES view
PRODUCT_REF_LIST_NESTEDTAB table
PRODUCT_STATUS column of table PRODUCT_INFORMATION
PRODUCT_STATUS column of view OC_PRODUCT_INFORMATION
PRODUCT_STATUS column of view PRODUCTS
PRODUCT_STATUS_LOV constraint of table PRODUCT_INFORMATION
PRODUCTS view
PROMOTION_ID column of table ORDERS

Q

QUANTITY column of table ORDER_ITEMS
QUANTITY_ON_HAND column of table INVENTORIES
QUANTITY_ON_HAND column of view BOMBAY_INVENTORY
QUANTITY_ON_HAND column of view OC_INVENTORIES
QUANTITY_ON_HAND column of view SYDNEY_INVENTORY
QUANTITY_ON_HAND column of view TORONTO_INVENTORY

S

SALES_REP_ID column of table ORDERS
SALES_REP_ID column of view OC_ORDERS
SUBCATEGORY_REF_LIST_NESTEDTAB table
SUPPLIER_ID column of table PRODUCT_INFORMATION
SUPPLIER_ID column of view OC_PRODUCT_INFORMATION
SUPPLIER_ID column of view PRODUCTS
SYDNEY_INVENTORY view
SYS_C002420 constraint of table ORDER_ITEMS
SYS_C002421 constraint of table ORDER_ITEMS
SYS_C002445 constraint of table CATEGORIES_TAB
SYS_C002445 index of table CATEGORIES_TAB
SYS_C002446 constraint of table CATEGORIES_TAB
SYS_C002446 index of table CATEGORIES_TAB
SYS_C002447 constraint of table CATEGORIES_TAB
SYS_C002447 index of table CATEGORIES_TAB
SYS_C002448 constraint of table CATEGORIES_TAB
SYS_C002448 index of table CATEGORIES_TAB
SYS_IL0000029523C00022$$ index of table CUSTOMERS
SYS_IL0000029523C00023$$ index of table CUSTOMERS
SYS_IL0000029529C00003$$ index of table WAREHOUSES
SYS_IL0000029529C00012$$ index of table WAREHOUSES
SYS_IL0000029529C00013$$ index of table WAREHOUSES

T

TORONTO_INVENTORY view
TRANSLATED_DESC_NN constraint of table PRODUCT_DESCRIPTIONS
TRANSLATED_DESCRIPTION column of table PRODUCT_DESCRIPTIONS
TRANSLATED_NAME column of table PRODUCT_DESCRIPTIONS
TRANSLATED_NAME_NN constraint of table PRODUCT_DESCRIPTIONS

U

UNIT_PRICE column of table ORDER_ITEMS

W

WAREHOUSE column of view OC_INVENTORIES
WAREHOUSE_ID column of table INVENTORIES
WAREHOUSE_ID column of table WAREHOUSES
WAREHOUSE_NAME column of table WAREHOUSES
WAREHOUSE_SPEC column of table WAREHOUSES
WAREHOUSES table
WAREHOUSES_LOCATION_FK constraint
WAREHOUSES_PK constraint of table WAREHOUSES
WAREHOUSES_PK index of table WAREHOUSES
WARRANTY_PERIOD column of table PRODUCT_INFORMATION
WARRANTY_PERIOD column of view OC_PRODUCT_INFORMATION
WARRANTY_PERIOD column of view PRODUCTS
WEIGHT_CLASS column of table PRODUCT_INFORMATION
WEIGHT_CLASS column of view OC_PRODUCT_INFORMATION
WEIGHT_CLASS column of view PRODUCTS
WH_GEO_LOCATION column of table WAREHOUSES
WHS_LOCATION_IX index of table WAREHOUSES