DOS_SUPP_MAKE_ORDER_MATERIAL_V
Details
-
Schema: FUSION
-
Object owner: DOS
-
Object type: VIEW
Columns
Name |
---|
TRACKING_LINE_ID WORKORDER_DETAILS_INTF_ID LINE_INTERFACE_ID HEADER_INTERFACE_ID INTERFACE_BATCH_NUMBER INTERFACE_STATUS_CODE ACTION_CODE LOAD_TYPE OPERATION_SEQUENCE_NUMBER MATERIAL_SEQ_NUMBER COMP_ITEM_ID_OLD COMP_ITEM_ID_NEW MATERIAL_QTY_PER_PRODUCT SUBSTITUTE_QTY_PER_PRODUCT |
Query
SQL_Statement |
---|
SELECT DOS_LINE_SUPPLEMENTAL_INFO.TRACKING_LINE_ID TRACKING_LINE_ID, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/WorkOrderDetailsIntfId') WORKORDER_DETAILS_INTF_ID, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/LineInterfaceId') LINE_INTERFACE_ID, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/HeaderInterfaceId') HEADER_INTERFACE_ID, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/InterfaceBatchNumber') INTERFACE_BATCH_NUMBER, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/InterfaceStatusCode') INTERFACE_STATUS_CODE, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/ActionCode') ACTION_CODE, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/LoadType') LOAD_TYPE, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/OperationSequenceNumber') OPERATION_SEQUENCE_NUMBER, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/MaterialSeqNumber') MATERIAL_SEQ_NUMBER, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/COMPItemIdOld') COMP_ITEM_ID_OLD, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/COMPItemIdNew') COMP_ITEM_ID_NEW, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/MaterialQtyPerProduct') MATERIAL_QTY_PER_PRODUCT, extractValue(CONTENT, '/DosLineSupplWorkOrderDtlsVORow/SubstituteQtyPerProduct') SUBSTITUTE_QTY_PER_PRODUCT FROM DOS_LINE_SUPPLEMENTAL_INFO WHERE DETAIL_TYPE = 'WORKORDERMATERIAL' |