RCL_AVAILABLE_PARTS_GT
This table is a global temporary table for available parts which is used by the Part Search program.
Details
-
Schema: FUSION
-
Object owner: RCL
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | 18 | The organization id identifier. | |
| SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code. | |
| SOURCE_TYPE_CODE | VARCHAR2 | 30 | The source type. | |
| REQUIRED_ITEM_ID | NUMBER | 18 | The required item identifier. | |
| REQUIRED_ITEM_REV | VARCHAR2 | 18 | It indicates the revision of the item if the item is revision controlled. | |
| REQUIRED_QUANTITY | NUMBER | The required quantity. | ||
| SUPPLIED_ITEM_ID | NUMBER | 18 | The supplied item identifier. | |
| SUPPLIED_ITEM_REV | VARCHAR2 | 18 | The supplied item revision. | |
| SUPPLIED_QUANTITY | NUMBER | The supplied quantity. | ||
| SUPPLIED_ITEM_TYPE | VARCHAR2 | 10 | The supplied item type. | |
| SOURCE_CARRIER_ID | NUMBER | 18 | The carrier identifier. | |
| SOURCE_MODE_OF_TRANSPORT | VARCHAR2 | 30 | The mode of transportation. | |
| SOURCE_SERVICE_LEVELS | VARCHAR2 | 30 | The service level. | |
| SHIPPING_COST | NUMBER | The shipping cost. | ||
| SOURCE_REQUEST_DATE | DATE | The request date. | ||
| EXPECTED_ARRIVAL_DATE | DATE | The expected arrival date. | ||
| EXPECTED_SHIP_DATE | DATE | The expected ship date. | ||
| DISTANCE | NUMBER | The distance from source to destination. | ||
| OPEN_OR_CLOSED | VARCHAR2 | 10 | It indicates if stocking location is open or closed. |