User Tools

Site Tools


implementation:wms:disallowedlocations

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

implementation:wms:disallowedlocations [2017/06/12 11:11]
csuhaa created
implementation:wms:disallowedlocations [2017/12/11 12:24] (current)
csuhaa 7.1
Line 21: Line 21:
   * Moveable locations   * Moveable locations
   * All locations linked to a WA location   * All locations linked to a WA location
 +
 +The query that is used:
 +
 +<code sql>
 + ​SELECT "​PMX_OSEL"​."​Code"​ FROM "​PMX_OSEL"​ WHERE "​PMX_OSEL"​."​TypeCode"​ IN (N'​PRODLINE',​ N'​MOVLOC'​)
 + ​UNION ​ SELECT "​PMX_OSPL"​."​InputLocationCode"​ FROM "​PMX_OSPL"​ WHERE "​PMX_OSPL"​."​InputLocationCode"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSPL"​."​PickToLocationCode"​ FROM "​PMX_OSPL"​ WHERE "​PMX_OSPL"​."​PickToLocationCode"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_CBLU"​."​CanBeLinedUpLocationCode"​ FROM "​PMX_CBLU"​
 + ​UNION ​ SELECT "​PMX_OSWH"​."​StorLocLogCar"​ FROM "​PMX_OSWH"​ WHERE "​PMX_OSWH"​."​StorLocLogCar"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSWH"​."​StorLocRetItem"​ FROM "​PMX_OSWH"​ WHERE "​PMX_OSWH"​."​StorLocRetItem"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSWH"​."​StorLocLostAndFound"​ FROM "​PMX_OSWH"​ WHERE "​PMX_OSWH"​."​StorLocLostAndFound"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSWA"​."​InputLocationCode"​ FROM "​PMX_OSWA"​ WHERE "​PMX_OSWA"​."​InputLocationCode"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSWA"​."​InputWithBoxLocationCode"​ FROM "​PMX_OSWA"​ WHERE "​PMX_OSWA"​."​InputWithBoxLocationCode"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSWA"​."​OutputLocationCode"​ FROM "​PMX_OSWA"​ WHERE "​PMX_OSWA"​."​OutputLocationCode"​ IS NOT NULL
 + ​UNION ​ SELECT "​PMX_OSSL"​."​Code"​ FROM "​PMX_OSSL"​ WHERE "​PMX_OSSL"​."​BlockStockFromBeingUsedOnProposal"​ = N'​Y'​
 +</​code>​
 +
 +
  
 The cached table is filled when the add-on or fat client is started. The cached table is filled when the add-on or fat client is started.
implementation/wms/disallowedlocations.txt ยท Last modified: 2017/12/11 12:24 by csuhaa