DOS_SUPPLY_MAKE_ORDER_DTLS
Supply make order detail will store the attributes that are specific to a make supply request
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
DOS_SUPPLY_MAKE_ORDER_DTL_PK |
SUPPLY_MAKE_DETAILS_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SUPPLY_MAKE_DETAILS_ID | NUMBER | 18 | Yes | Supply Make Order Detail Identifier | |
WORK_ORDER_ID | VARCHAR2 | 120 | Foreign key to the Work Orders table | ||
PRIMARY_DOC_QUANTITY | NUMBER | Primary Document Quantity of the Work Order | |||
PRIMARY_DOC_QUANTITY_UOM | VARCHAR2 | 3 | Primary Document Quantity UOM of the Work Order | ||
DELIVER_TO_SUBINVENTORY | VARCHAR2 | 40 | Completion sub-inventory for WIIP jobs | ||
CHANGE_SUPPLY_OPERATION | VARCHAR2 | 30 | Primary Document Supply Operation to be performed for the demand side change | ||
EXEC_SYSTEM_COMPL_LOCTR_CODE | VARCHAR2 | 40 | Completion Locator Code of the Work Order | ||
TRACKING_LINE_ID | NUMBER | 18 | Yes | Supply Tracking Line Identifier | |
GROUP_ID | NUMBER | 18 | Refers to the Group Identifier for manufacturing Items of an Order | ||
LOAD_TYPE | VARCHAR2 | 30 | "Indicates whether current interface record is planned order or job update recommendation. Must assign one of these values or error occurs. 1 Create standard Discrete job 3 Update standard or non-standard Discrete job 4 Create non-standard Discrete Job" | ||
BOM_REVISION_DATE | TIMESTAMP | Date of the Bill Of Material Revision | |||
ROUTING_REVISION_DATE | TIMESTAMP | Date Of The Routing Revision of the Work Order | |||
ACCOUNTING_CLASS_CODE | VARCHAR2 | 120 | Accounting class associated with job. | ||
FIRM_PLANNED_FLAG | VARCHAR2 | 1 | Firm flag control for planning rescheduling. | ||
ALT_ROUTING_DESIGNATOR | VARCHAR2 | 30 | Alternate Routing Designator of the Work Order | ||
ALT_BOM_DESIGNATOR | VARCHAR2 | 30 | Alternate BOM Designator for the Work Order | ||
DEMAND_CLASS | VARCHAR2 | 30 | Demand class code of Work order | ||
NET_QUANTITY | NUMBER | Work Order net Quantity or Completed Quantity | |||
NET_QUANTITY_UOM_CODE | VARCHAR2 | 3 | Net Quantity Unit of Measure Code | ||
SCHEDULE_GRP_ID | NUMBER | 18 | Schedule Group Identifier of the Work Order | ||
WORK_ORDER_NUMBER | VARCHAR2 | 120 | Work Order Number. The uniqueness of which will be controlled by user at the work method level or at the plant level. Work Order Number. The uniqueness of which will be controlled by user at the work method level or at the plant level. | ||
ALLOW_EXPLOSION_FLAG | VARCHAR2 | 1 | This flag controls the behavior whether the Work Definition should be used in the creation of work order operations, operation resources and operation material. | ||
WORK_ORDER_STATUS_ID | NUMBER | 18 | Work Order Status Identifier refers to the Work Order status table | ||
WORK_DEFINITION_NAME | VARCHAR2 | 120 | This is the name of the work definition. This denotes an alternate way of making a product. | ||
WORK_DEFINITION_AS_OF_DATE | TIMESTAMP | The as of date to automatically figure out the work definition when user does not know the exact work definition | |||
WORK_ORDER_SUB_TYPE | VARCHAR2 | 30 | For a specific Work Order Type, this attribute represents the specific nature of work being performed such as Standard Production, Prototyping, or Repair. | ||
WORK_DEFINITION_ID | NUMBER | 18 | The foreign key reference to the work definition. | ||
WORK_METHOD_CODE | VARCHAR2 | 30 | The work method code of the Work Order | ||
WORK_ORDER_TYPE | VARCHAR2 | 30 | Based on the Work Method, this attribute further classifies the Work Order to indicate whether it is meant for either Standard or Non Standard Production. | ||
SOURCE_SYSTEM_ID | VARCHAR2 | 120 | The application id value is stored here if the source_system_type is INTERNAL. If External, then the Source system as it is defined in TCA source systems table. FND_APPLICATION_ID.APPLICATION_ID HZ_ORIG_SYSTEMS_VL.ORIG_SYSTEM_ID | ||
SCHEDULING_METHOD | VARCHAR2 | 30 | Whether the work order is scheduled based on the Work Definition data or Manual. This lookup for which will be seeded in | ||
SOURCE_SYSTEM_TYPE | VARCHAR2 | 30 | Type of source system. Valid values are INTERNAL or EXTERNAL. Lookup = WIE_SOURCE_SYSTEM_TYPE | ||
BUILD_SEQUENCE | NUMBER | 18 | Build Sequence for the Work Order | ||
CHARGE_ACCT_ID | NUMBER | 18 | Charge account identifier for the Work Order | ||
NEED_BY_DATE | TIMESTAMP | Need By date for the Work order | |||
WORK_ORDER_COMPLETION_DATE | TIMESTAMP | Scheduled ship date from GOP payload. Planning to provide start or completion date of the job. This could be different from need by date. | |||
WORK_ORDER_START_DATE | TIMESTAMP | Expected Start Date for the Work Order | |||
WORK_ORDER_DESCRIPTION | VARCHAR2 | 950 | WIP Job description. Populated by planning for WIP job requests. | ||
WIP_QTY | NUMBER | Reported by MFG and task layers will record this value. This will be used during change management in the dynamic svc rules to determine if WO needs to be updated | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
WORK_PROCESS_NAME | VARCHAR2 | 120 | This column stores the Work Process name. | ||
WORK_ORDER_PRIORITY | NUMBER | Used to set the priority of the work order depending on the demand that needed to be prioritized | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
DOS_SUPPLY_MAKE_ORDER_DTLS_FK1 | Non Unique | FUSION_TS_TX_IDX | TRACKING_LINE_ID |
DOS_SUPPLY_MAKE_ORDER_DTL_U1 | Unique | FUSION_TS_TX_IDX | SUPPLY_MAKE_DETAILS_ID |