1. Tables and Views for SCM
  2. DOS_SUPP_MAKE_ORDER_RESOURCE_V

DOS_SUPP_MAKE_ORDER_RESOURCE_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

WD_OP_ALT_RESOURCE_ID

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/WdOpAltResourceId') WD_OP_ALT_RESOURCE_ID

FROM DOS_LINE_SUPPLEMENTAL_INFO WHERE DETAIL_TYPE = 'WORKORDERRESOURCE'