elixiat 发表于 2015-9-23 14:24:49

Oracle EBS-SQL (WIP-2):检查非标任务没挂自己本身.sql

  SELECT WE.WIP_ENTITY_NAME,
  MSI.SEGMENT1,
  MSI.DESCRIPTION,
  WDJ.CLASS_CODE,
  WDJ.START_QUANTITY,
  WDJ.SCHEDULED_START_DATE
  FROM    wip.WIP_ENTITIES            WE,
  wip.WIP_DISCRETE_JOBSWDJ,
  INV.MTL_SYSTEM_ITEMS_B MSI
  WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
  AND MSI.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
  AND MSI.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
  AND WDJ.ORGANIZATION_ID = X
  AND WDJ.JOB_TYPE = 3
  AND WDJ.STATUS_TYPE IN (1, 3)
  AND NOT EXISTS(SELECT 'X'
  FROM WIP.WIP_REQUIREMENT_OPERATIONS WRO
  WHERE WRO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
  AND wro.inventory_item_id = wdj.PRIMARY_ITEM_ID)
页: [1]
查看完整版本: Oracle EBS-SQL (WIP-2):检查非标任务没挂自己本身.sql