1. Tables and Views for SCM
  2. DOS_LINE_SUPP_MAKE_INFO_V

DOS_LINE_SUPP_MAKE_INFO_V

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: VIEW

Columns

Name

LINE_ID

TRACKING_LN_SUPLM_INFRMTN_ID

TRACKING_LINE_ID

OBJECT_VERSION_NUMBER

DETAIL_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SOURCESYSTEMDETAILSREFERENCEID

AUTOSOURCEFLAG

ALTNUMBER

APPLIEDRESOURCEUNITS

APPLIEDRESOURCEVALUE

ASSIGNEDUNITS

AUTHSTATUS

BACKFLUSHFLAG

BATCHNUMBER

CLASSCODE

COMPLETIONDATE

COUNTPOINTTYPE

OPERATIONSEQUENCEID

OPERATIONSEQUENCENUMBER

QUANTITYISSUED

QUANTITYPERASSEMBLY

STANDARDOPERATIONID

STANDARDOPERATIONNAME

STANDARDRATEFLAG

RESOURCEACTIVITYID

RESOURCEAUTOCHARGETYPE

RESOURCEBASISTYPE

RESOURCEDEPARTMENTID

RESOURCEDEPARTMENTNAME

RESOURCEIDNEW

RESOURCEIDOLD

RESOURCENAMENEW

RESOURCENAMEOLD

RESOURCESEQUENCENUMBER

RESOURCEUOM

WIPSUPPLYTYPE

ITEMIDNEW

ITEMIDOLD

ITEMNAMENEW

ITEMNAMEOLD

MPSDATEREQD

MPSQUANTITYREQD

MRPNETFLAG

PROCESSPHASE

PROCESSSTATUS

SOURCECODE

SOURCELINEID

SCHEDULEDFLAG

STARTDATE

STATUSTYPE

SUBSTITUTIONTYPE

SUPPLYLOCID

SUPPLYSUBINV

SUPPLYLOCNAME

COMPONENTREQUIREDQUANTITY

COMPONENTUOM

Query

SQL_Statement

select LINE_ID,TRACKING_LN_SUPLM_INFRMTN_ID,TRACKING_LINE_ID,OBJECT_VERSION_NUMBER,DETAIL_TYPE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SourceSystemDetailsReferenceId') SourceSystemDetailsReferenceId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/AutosourceFlag')AutosourceFlag,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/AltNumber')AltNumber,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/AppliedResourceUnits')AppliedResourceUnits,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/AppliedResourceValue')AppliedResourceValue,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/AssignedUnits')AssignedUnits,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/AuthStatus')AuthStatus,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/BackflushFlag')BackflushFlag,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/BatchNumber')BatchNumber,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ClassCode')ClassCode,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/CompletionDate')CompletionDate,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/CountPointType')CountPointType,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/OperationSequenceId')OperationSequenceId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/OperationSequenceNumber')OperationSequenceNumber,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/QuantityIssued')QuantityIssued,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/QuantityPERAssembly')QuantityPERAssembly,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/StandardOperationId')StandardOperationId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/StandardOperationName')StandardOperationName,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/StandardRateFlag')StandardRateFlag,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceActivityId')ResourceActivityId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceAutoChargeType')ResourceAutoChargeType,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceBasisType')ResourceBasisType,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceDepartmentId')ResourceDepartmentId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceDepartmentName')ResourceDepartmentName,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceIdNew')ResourceIdNew,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceIdOld')ResourceIdOld,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceNameNew')ResourceNameNew,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceNameOld')ResourceNameOld,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceSequenceNumber')ResourceSequenceNumber,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ResourceUOM')ResourceUOM,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/WIPSupplyType')WIPSupplyType,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ItemIdNew')ItemIdNew,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ItemIdOld')ItemIdOld,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ItemNameNew')ItemNameNew,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ItemNameOld')ItemNameOld,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/MPSDateReqd')MPSDateReqd,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/MPSQuantityReqd')MPSQuantityReqd,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/MRPNetFlag')MRPNetFlag,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ProcessPhase')ProcessPhase,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ProcessStatus')ProcessStatus,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SourceCode')SourceCode,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SourceLineId')SourceLineId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ScheduledFlag')ScheduledFlag,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/StartDate')StartDate,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/StatusType')StatusType,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SubstitutionType')SubstitutionType,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SupplyLocId')SupplyLocId,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SupplySubInv')SupplySubInv,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/SupplyLocName')SupplyLocName,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ComponentRequiredQuantity')ComponentRequiredQuantity,

extractvalue(CONTENT, '/DosProcessSupplyOrdersMakeDetailsTRVORow/ComponentUOM')ComponentUOM

from DOS_LINE_SUPPLEMENTAL_INFO where DETAIL_TYPE ='MAKE'