OE Schema
5-8 Sample Schemas
OE Table Descriptions
This section describes the columns of each table of the OE schema, as follows:
■ Table 5–12, " OE.CUSTOMERS Table Description" on page 5-9
■ Table 5–13, " OE.INVENTORIES Table Description" on page 5-9
■ Table 5–14, " OE.ORDERS Table Description" on page 5-9
■ Table 5–15, " OE.ORDER_ITEMS Table Description" on page 5-9
■ Table 5–16, " OE.PRODUCT_DESCRIPTIONS Table Description" on page 5-10
■ Table 5–17, " OE.PRODUCT_INFORMATION Table Description" on page 5-10
■ Table 5–18, " OE.WAREHOUSES Table Description" on page 5-10
Table 5–11 HR Objects
Object Type Objects
Index CUSTOMERS_PK, CUST_ACCOUNT_MANAGER_IX, CUST_EMAIL_IX, CUST_
LNAME_IX, CUST_UPPER_NAME_IX, INVENTORY_IX, INV_PRODUCT_IX,
ITEM_ORDER_IX, ITEM_PRODUCT_IX, ORDER_ITEMS_PK, ORDER_ITEMS_
UK, ORDER_PK, ORD_CUSTOMER_IX, ORD_ORDER_DATE_IX, ORD_SALES_
REP_IX, PRD_DESC_PK, PRODUCT_INFORMATION_PK, PROD_NAME_IX,
PROD_SUPPLIER_IX, PROMO_ID_PK, REFERENCE_IS_UNIQUE, SYS_
C003584, SYS_C003587, SYS_C003588, SYS_C003589, SYS_C003590,
WAREHOUSES_PK, WHS_LOCATION_IX
Function GET_PHONE_NUMBER_F
Sequence ORDERS_SEQ
Lob SYS_LOB0000045843C00022$$, SYS_LOB0000045843C00023$$, SYS_
LOB0000045852C00003$$, SYS_LOB0000045852C00012$$, SYS_
LOB0000045852C00013$$, SYS_LOB0000046019C00004$$, SYS_
LOB0000046019C00005$$, SYS_LOB0000046019C00007$$, SYS_
LOB0000046019C00011$$, SYS_LOB0000046019C00012$$, SYS_
LOB0000046019C00015$$, SYS_LOB0000046019C00024$$, SYS_
LOB0000046019C00031$$, SYS_LOB0000046019C00032$$,
SYS_
LOB0000046044C00003$$
Synonym COUNTRIES, DEPARTMENTS, EMPLOYEES, JOBS, JOB_HISTORY, LOCATIONS
Table CUSTOMERS, INVENTORIES, ORDERS, ORDER_ITEMS, PRODUCT_
DESCRIPTIONS, PRODUCT_INFORMATION, WAREHOUSES
Trigger INSERT_ORD_LINE, ORDERS_ITEMS_TRG, ORDERS_TRG
Type CATALOG_TYP, CATEGORY_TYP, COMPOSITE_CATEGORY_TYP, CORPORATE_
CUSTOMER_TYP, CUSTOMER_TYP, CUST_ADDRESS_TYP, INVENTORY_LIST_
TYP, INVENTORY_TYP, LEAF_CATEGORY_TYP, ORDER_ITEM_LIST_TYP,
ORDER_ITEM_TYP, ORDER_LIST_TYP, ORDER_TYP, PHONE_LIST_TYP,
PRODUCT_INFORMATION_TYP, PRODUCT_REF_LIST_TYP, SUBCATEGORY_
REF_LIST_TYP, SYS_YOID0000046073$, SYS_YOID0000046075$, SYS_
YOID0000046077$, SYS_YOID0000046079$, SYS_YOID0000046081$,
WAREHOUSE_TYP, XDBPO_ACTIONS_TYPE, XDBPO_ACTION_COLLECTION,
XDBPO_ACTION_TYPE, XDBPO_LINEITEMS_TYPE, XDBPO_LINEITEM_
COLLECTION, XDBPO_LINEITEM_TYPE, XDBPO_PART_TYPE,
XDBPO_
REJECTION_TYPE, XDBPO_SHIPINSTRUCTIONS_TYPE, XDBPO_TYPE
Type Body CATALOG_TYP, COMPOSITE_CATEGORY_TYP, LEAF_CATEGORY_TYP
View ACCOUNT_MANAGERS, BOMBAY_INVENTORY, CUSTOMERS_VIEW, DEPTVIEW,
OC_CORPORATE_CUSTOMERS, OC_CUSTOMERS, OC_INVENTORIES, OC_
ORDERS, OC_PRODUCT_INFORMATION, ORDERS_VIEW, PRODUCTS,
PRODUCT_PRICES, SYDNEY_INVENTORY, TORONTO_INVENTORY