1. Tables and Views for SCM
  2. DOS_CHANGE_MAKE_ORDER_DTLS_V

DOS_CHANGE_MAKE_ORDER_DTLS_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

SUPPLY_MAKE_DETAILS_ID

TRACKING_LINE_ID

GROUP_ID

BOM_REVISION_DATE

ROUTING_REVISION_DATE

FIRM_PLANNED_FLAG

DEMAND_CLASS

BUILD_SEQUENCE

CHARGE_ACCT_ID

LOAD_TYPE

NET_QUANTITY

ACCOUNTING_CLASS_CODE

ALT_ROUTING_DESIGNATOR

ALT_BOM_DESIGNATOR

SCHEDULE_GRP_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DELIVER_TO_SUBINVENTORY

NET_QUANTITY_UOM_CODE

CHANGE_SUPPLY_OPERATION

EXEC_SYSTEM_COMPL_LOCTR_CODE

PRIMARY_DOC_QUANTITY

PRIMARY_DOC_QUANTITY_UOM

NEED_BY_DATE

ALLOW_EXPLOSION_FLAG

SCHEDULING_METHOD

SOURCE_SYSTEM_ID

SOURCE_SYSTEM_TYPE

WORK_DEFINITION_AS_OF_DATE

WORK_DEFINITION_ID

WORK_DEFINITION_NAME

WORK_METHOD_CODE

WORK_ORDER_NUMBER

WORK_ORDER_STATUS_ID

WORK_ORDER_SUB_TYPE

WORK_ORDER_TYPE

WORK_ORDER_ID

WORK_ORDER_COMPLETION_DATE

WIP_QTY

WORK_ORDER_DESCRIPTION

WORK_ORDER_START_DATE

Query

SQL_Statement

SELECT

supply_order_entity_id SUPPLY_MAKE_DETAILS_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/TrackingLineId') TRACKING_LINE_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/GroupId') GROUP_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/BomRevisionDate') BOM_REVISION_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/RoutingRevisionDate') ROUTING_REVISION_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/FirmPlannedFlag') FIRM_PLANNED_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/DemandClass') DEMAND_CLASS,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/BuildSequence') BUILD_SEQUENCE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/ChargeAcctId') CHARGE_ACCT_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/LoadType') LOAD_TYPE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/NetQuantity') NET_QUANTITY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/AccountingClassCode') ACCOUNTING_CLASS_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/AltRoutingDesignator') ALT_ROUTING_DESIGNATOR,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/AltBomDesignator') ALT_BOM_DESIGNATOR,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/ScheduleGrpId') SCHEDULE_GRP_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/CreatedBy') CREATED_BY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/CreationDate') CREATION_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/LastUpdatedBy') LAST_UPDATED_BY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/ObjectVersionNumber') OBJECT_VERSION_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/LastUpdateDate') LAST_UPDATE_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/LastUpdateLogin') LAST_UPDATE_LOGIN,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/DeliverToSubinventory') DELIVER_TO_SUBINVENTORY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/NetQuantityUomCode') NET_QUANTITY_UOM_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/ChangeSupplyOperation') CHANGE_SUPPLY_OPERATION,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/ExecSystemComplLoctrCode') EXEC_SYSTEM_COMPL_LOCTR_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/PrimaryDocQuantity') PRIMARY_DOC_QUANTITY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/PrimaryDocQuantityUom') PRIMARY_DOC_QUANTITY_UOM,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/NeedByDate') NEED_BY_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/AllowExplosionFlag') ALLOW_EXPLOSION_FLAG,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/SchedulingMethod') SCHEDULING_METHOD,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/SourceSystemId') SOURCE_SYSTEM_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/SourceSystemType') SOURCE_SYSTEM_TYPE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkDefinitionAsOfDate') WORK_DEFINITION_AS_OF_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkDefinitionId') WORK_DEFINITION_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkDefinitionName') WORK_DEFINITION_NAME,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkMethodCode') WORK_METHOD_CODE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderNumber') WORK_ORDER_NUMBER,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderStatusId') WORK_ORDER_STATUS_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderSubType') WORK_ORDER_SUB_TYPE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderType') WORK_ORDER_TYPE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderId') WORK_ORDER_ID,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderCompletionDate') WORK_ORDER_COMPLETION_DATE,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WipQty') WIP_QTY,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderDescription') WORK_ORDER_DESCRIPTION,

extractValue(SUPPLY_ORDER_ENTITY_CONTENTS, '/DosSupplyMakeOrderDtlsVORow/WorkOrderStartDate') WORK_ORDER_START_DATE

FROM DOS_CHANGE_SUPPLY_ORDER WHERE SUPPLY_ORDER_ENTITY_TYPE='DOS_SUPPLY_MAKE_ORDER_DTLS' AND ACTIVE_FLAG='Y'