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. |