[Home] [Help] [Dependency Information]
Object Name: | MST_MAST_SUM_REPORT_TEMP_GT |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
MST.MST_MAST_SUM_REPORT_TEMP_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VIEW_ID | NUMBER | |||
PLAN_ID | NUMBER | |||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | ||
REPORT_DATE | DATE | |||
PLAN_START_DATE | DATE | |||
PLAN_END_DATE | DATE | |||
FACILITY_NAME | VARCHAR2 | (60) | ||
CARRIER_NAME | VARCHAR2 | (30) | ||
ORIGIN_NAME | VARCHAR2 | (60) | ||
DESTINATION_NAME | VARCHAR2 | (60) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
SUPPLIER_NAME | VARCHAR2 | (360) | ||
ORDERS | NUMBER | |||
ORDER_GROUPS | NUMBER | |||
WEIGHT | NUMBER | |||
VOLUME | NUMBER | |||
PIECES | NUMBER | |||
PALLETS | NUMBER | |||
ALLOCATED_COST | NUMBER | |||
PLAN_VALUE | NUMBER | |||
TOTAL_TL_COUNT | NUMBER | |||
LTL_COUNT | NUMBER | |||
PARCEL_COUNT | NUMBER | |||
TL_COST | NUMBER | |||
LTL_COST | NUMBER | |||
PARCEL_COST | NUMBER | |||
TRANSPORTATION_COST | NUMBER | |||
HANDLING_COST | NUMBER | |||
TOTAL_COST | NUMBER | |||
TL_STOPS | NUMBER | |||
TL_DISTANCE | NUMBER | |||
CARR_MOVES | NUMBER | |||
MTL_COUNT | NUMBER | |||
DTL_COUNT | NUMBER | |||
PERCENT_ALLOC_COST | NUMBER | |||
PERCENT_VALUE | NUMBER | |||
COST_PER_UNIT_WEIGHT | NUMBER | |||
COST_PER_UNIT_VOLUME | NUMBER | |||
MODE_OF_TRANSPORT | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT VIEW_ID
, PLAN_ID
, COMPILE_DESIGNATOR
, REPORT_DATE
, PLAN_START_DATE
, PLAN_END_DATE
, FACILITY_NAME
, CARRIER_NAME
, ORIGIN_NAME
, DESTINATION_NAME
, CUSTOMER_NAME
, SUPPLIER_NAME
, ORDERS
, ORDER_GROUPS
, WEIGHT
, VOLUME
, PIECES
, PALLETS
, ALLOCATED_COST
, PLAN_VALUE
, TOTAL_TL_COUNT
, LTL_COUNT
, PARCEL_COUNT
, TL_COST
, LTL_COST
, PARCEL_COST
, TRANSPORTATION_COST
, HANDLING_COST
, TOTAL_COST
, TL_STOPS
, TL_DISTANCE
, CARR_MOVES
, MTL_COUNT
, DTL_COUNT
, PERCENT_ALLOC_COST
, PERCENT_VALUE
, COST_PER_UNIT_WEIGHT
, COST_PER_UNIT_VOLUME
, MODE_OF_TRANSPORT
FROM MST.MST_MAST_SUM_REPORT_TEMP_GT;
MST.MST_MAST_SUM_REPORT_TEMP_GT does not reference any database object
MST.MST_MAST_SUM_REPORT_TEMP_GT is referenced by following:
|
|
|