WIS_ITEM_LEADTIMES_GT
This is a global temporary table that stores calculated lead times used as part of the calculate manufacturing and cumulative lead time process.
Details
-
Schema: FUSION
-
Object owner: WIS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
WIS_ITEM_LEADTIMES_GT_PK |
JOB_REQUEST_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| JOB_REQUEST_ID | NUMBER | 18 | Yes | Represents the request ID of the job that created the row. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | The organization identifier that represents the manufacturing plant to which this item belongs. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Represents the top level, final assembly, subassembly, or model item which belongs to the given organization. | |
| INVENTORY_ITEM_NUMBER | VARCHAR2 | 300 | Represents the user key to the top level, final assembly, subassembly, or model item which belongs to the given organization. | ||
| ITEM_RANGE_FLAG | VARCHAR2 | 1 | Flag to indicate if the item is part of a range given in the calculate lead time job parameters. | ||
| MAKE_BUY_CODE | VARCHAR2 | 1 | Code to indicate if the item is usually manufactured or bought. | ||
| WORK_DEFINITION_ID | NUMBER | 18 | The unique identifier of a work definition. | ||
| WORK_DEF_NAME | VARCHAR2 | 120 | Indicates the name of the work definition. | ||
| WORK_DEFINITION_HEADER_NAME | VARCHAR2 | 120 | Indicates the unique name for the work definition. In the case of process manufacturing, this represents the process name. | ||
| VERSION_NUMBER | VARCHAR2 | 10 | Indicates the version of the work definition. | ||
| PREPROCESSING_LEAD_TIME | NUMBER | Represents the days which must be added to purchasing or manufacturing lead time to place an order. | |||
| PROCESSING_LEAD_TIME | NUMBER | Represents the days required to procure or manufacture an item. | |||
| POSTPROCESSING_LEAD_TIME | NUMBER | Represents the days required to receive a purchased item into inventory from the initial supplier receipt. | |||
| FIXED_LEAD_TIME | NUMBER | Represents the days required to make an assembly independent of order quantity, such as setup or tear down time. | |||
| VARIABLE_LEAD_TIME | NUMBER | Represents the days required to produce one additional unit of an assembly. | |||
| CUMULATIVE_MFG_LEAD_TIME | NUMBER | Represents manufacturing lead time of an assembly (in days) plus the largest adjusted cumulative manufacturing lead time of its components, where each is adjusted by subtracting the operation lead time offset. | |||
| CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | Represents total lead time of the assembly plus the largest adjusted cumulative total lead time of its components, where each is adjusted by subtracting the operation lead time offset. | |||
| LEAD_TIME_LOT_SIZE | NUMBER | Represents quantity used to compute processing lead time. | |||
| UNIT_OF_MEASURE | VARCHAR2 | 25 | Represents the unit of measure of the lead time lot size. | ||
| ERROR_TEXT | VARCHAR2 | 2000 | Represents the translated error text for a failure that occurred during lead time calculation. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| WIS_ITEM_LEADTIMES_GT_U01 | Unique | JOB_REQUEST_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID |