create
global temporary table 的一个例子
例子：
create global temporary table XX.XX_SUPPLY_TO_ORDER_TEMP
(
OU_ORG_CODE VARCHAR2(20),
SO_HEADER_ID NUMBER,
SO_NUMBER VARCHAR2(100),
BOOK_DATE DATE,
CUSTOMER VARCHAR2(100),
CUSTOM_PO VARCHAR2(100),
SALES_PERSON VARCHAR2(100),
DEMAND_CLASS VARCHAR2(100),
ORDER_STATUS VARCHAR2(100),
CE_PERSON VARCHAR2(100),
SO_LINE_ID NUMBER,
LINE_NUMBER VARCHAR2(100),
MULTIPLE VARCHAR2(100),
INVENTORY_ITEM_ID NUMBER,
ORDERED_ITEM VARCHAR2(100),
ITEM_DESCRIPTION VARCHAR2(240),
USER_ITEM_DESCRIPTION VARCHAR2(240),
LINE_STATUS VARCHAR2(100),
HOLD_STATUS VARCHAR2(100),
ORDERED_QTY NUMBER,
RESERVED_QTY NUMBER,
CREATED_DATE DATE,
REQUEST_DATE DATE,
SCHEDULED_SHIP_DATE DATE,
WAREHOUSE VARCHAR2(100),
SUB_INVENTORY VARCHAR2(100),
ITEM_REVISION VARCHAR2(10),
DEFAULT_TO_SUBINV VARCHAR2(20),
SUPPLY_METHOD VARCHAR2(100),
GENERAL_PLANNING_METHOD VARCHAR2(100),
MRP_PLANNING_METHOD VARCHAR2(100),
MAKE_BUY VARCHAR2(20),
PLANNER_CODE VARCHAR2(20),
WIP_PLANNER_CODE VARCHAR2(20),
PRODUCT_LINE VARCHAR2(240),
PRODUCT_FAMILY VARCHAR2(240),
ITEM_STATUS VARCHAR2(20),
QTY_AVL_TOTAL NUMBER,
QTY_AVL_RSV_DTL VARCHAR2(2000),
BOD_QTY_AVAILABLE NUMBER,
BOD_QTY_SHIP_SUBINV_AVL NUMBER,
NON_BOD_QTY_AVL NUMBER,
RESERVATION_TYPE VARCHAR2(100),
RESERVATION_QTY NUMBER,
OPEN_QTY NUMBER,
UNCONVERTED_WO_QTY NUMBER,
WIP_ENTITY_ID NUMBER,
WO_NUMBER VARCHAR2(100),
WO_CLASS VARCHAR2(100),
WO_STATUS VARCHAR2(100),
WO_QTY NUMBER,
WO_ITEM_REVISION VARCHAR2(20),
CONVERT_DATE DATE,
START_DATE DATE,
DUE_DATE DATE,
ACTUAL_COMPLETE_DATE DATE,
REAL_WIP_PLANNER_ID VARCHAR2(100),
CONSTRAINTS_CODE VARCHAR2(100),
CONSTRAINTS_DETAILS VARCHAR2(100),
LOT_NUMBER VARCHAR2(100),
SORT_LINE_NUMBER VARCHAR2(100),
WO_STATUS_CODE NUMBER,
ORDER_TYPE VARCHAR2(200),
SPLIT_BY VARCHAR2(100),
BOD_PLANNER_CODE VARCHAR2(100),
WO_REMAIN_QTY NUMBER,
QTY_NETTABLE NUMBER,
BOD_QTY_BALANCE NUMBER,
INV_RES_QTY NUMBER,
ORGANIZATION_ID NUMBER
)
on commit delete rows;
/
create index XX.XX_SUPPLY_TO_ORDER_TEMP_N1 on XX.XX_SUPPLY_TO_ORDER_TEMP (SO_HEADER_ID, SO_LINE_ID);
create index XX.XX_SUPPLY_TO_ORDER_TEMP_N2 on XX.XX_SUPPLY_TO_ORDER_TEMP (SO_LINE_ID);
/
create synonym XX_supply_to_order_temp for XX.XX_supply_to_order_temp
/
