G2A Many GEOs
SHARE
TWEET

Untitled

a guest Apr 9th, 2020 176 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.  --   RESOURCES.condition_number,
  3.     itd.test_program_name,
  4.     itd.test_program_version,
  5.     itd.probecard_setup,
  6.     itd.flat_orientation,
  7.     itd.handler_driver,
  8.     itd.rtwm_template,
  9.     itd.probecard_orientation,
  10.         --
  11.     itd.test_condition,
  12.     itd.test_software_type,
  13.     itd.test_specification_name,
  14.     itd.test_specification_version,
  15.     itd.project,
  16.    -- resources.resource_type resource_type,
  17.                 CASE  1--RESOURCES.condition_number
  18.                     WHEN 1   THEN itd.probe_setup_file_1
  19.                     WHEN 2   THEN itd.probe_setup_file_2
  20.                     WHEN 3   THEN itd.probe_setup_file_3
  21.                     WHEN 4   THEN itd.probe_setup_file_4
  22.                     WHEN 5   THEN itd.probe_setup_file_5
  23.                     WHEN 6   THEN itd.probe_setup_file_6
  24.                     WHEN 7   THEN itd.probe_setup_file_7
  25.                     WHEN 8   THEN itd.probe_setup_file_8
  26.                     WHEN 9   THEN itd.probe_setup_file_9
  27.                 END  setup_file,
  28.                 CASE  1
  29.                     WHEN 1   THEN itd.pr_temp_1
  30.                     WHEN 2   THEN itd.pr_temp_2
  31.                     WHEN 3   THEN itd.pr_temp_3
  32.                     WHEN 4   THEN itd.pr_temp_4
  33.                     WHEN 5   THEN itd.pr_temp_5
  34.                     WHEN 6   THEN itd.pr_temp_6
  35.                     WHEN 7   THEN itd.pr_temp_7
  36.                     WHEN 8   THEN itd.pr_temp_8
  37.                     WHEN 9   THEN itd.pr_temp_9
  38.                 END temp,
  39.                  CASE
  40.                     WHEN res.resource_code LIKE 'P-%' THEN 'Prober Infromation'
  41.                     WHEN res.resource_code LIKE 'T-%' THEN 'Tester Infromation'
  42.                     ELSE res.resource_code
  43.                 END resource_type
  44. FROM
  45.     apps.xxmlx_item_testprog_details_v itd,
  46.      apps.bom_operational_routings brout,
  47.             apps.bom_operation_resources bor,
  48.             apps.bom_operation_sequences bos,
  49.             apps.bom_standard_operations ops,
  50.             apps.bom_resources res
  51.  
  52. WHERE
  53.     itd.item_id = 31
  54.     AND   itd.organization_id = 114
  55.      AND   brout.assembly_item_id = itd.item_id
  56.             AND   bos.routing_sequence_id = brout.routing_sequence_id
  57.             AND   ops.standard_operation_id = bos.standard_operation_id
  58.             AND   bor.operation_sequence_id = bos.operation_sequence_id
  59.             AND   res.resource_id = bor.resource_id
  60.             AND   res.attribute4 IN (
  61.                 'PROBER',
  62.                 'TESTER'
  63.             );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top