RCL_REQUIRED_PARTS_GT
This table is a global temporary table which is used by the Parts Search program.
Details
-
Schema: FUSION
-
Object owner: RCL
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | 18 | The inventory item identifier. | |
REVISION | VARCHAR2 | 30 | The item revision. | |
ALTERNATE_ITEM_ID | NUMBER | 18 | The alternate item identifier. | |
QUANTITY | NUMBER | The required quantity for the the item. | ||
ITEM_TYPE | VARCHAR2 | 30 | Type of the item. | |
UOM_CODE | VARCHAR2 | 3 | The unit of measure for the item. |