Advertisement
Guest User

Untitled

a guest
Aug 15th, 2019
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 2.39 KB | None | 0 0
  1. SELECT
  2.     operation_seq_num,
  3.     operation_code,
  4.     test_condition,
  5.     tp.TEST_SPECIFICATION_NAME
  6.  
  7. FROM
  8.     (
  9.         SELECT
  10.             msi.inventory_item_id,
  11.             msi.organization_id,
  12.             msi.segment1,
  13.             we.wip_entity_name,
  14.             bop.operation_code,
  15.          --   xwmtv.fm_operation_seq_num,
  16.             wo.operation_seq_num,
  17.             wo.description,
  18.             wo.quantity_in_queue,
  19.             wo.quantity_running,
  20.             wo.quantity_waiting_to_move,
  21.             'Test Condition '
  22.             || ROW_NUMBER() OVER(
  23.                 PARTITION BY msi.segment1,
  24.                 we.wip_entity_name,
  25.                 bop.operation_code
  26.                 ORDER BY
  27.                     wo.operation_seq_num
  28.             ) AS test_specification_name
  29.         FROM
  30.             apps.mtl_system_items msi,
  31.             apps.wip_entities we,
  32.             apps.wip_operations wo,
  33.             apps.wip_discrete_jobs wdj,
  34.             apps.bom_standard_operations bop,
  35.             apps.wip_operation_resources wor,
  36.             apps.bom_resources res-- apps.XXMLX_WIP_MOVE_TRANSACTIONS_V xwmtv
  37.         WHERE
  38.             msi.inventory_item_id = we.primary_item_id
  39.             AND   msi.organization_id = we.organization_id
  40.             AND   we.wip_entity_id = wo.wip_entity_id
  41.             AND   we.organization_id = wo.organization_id
  42.             AND   we.wip_entity_id = wdj.wip_entity_id
  43.             AND   we.organization_id = wdj.organization_id
  44.    --         AND   we.wip_entity_id =xwmtv.wip_entity_id
  45.   --          AND   we.organization_id = xwmtv.organization_id
  46.             AND   bop.standard_operation_id = wo.standard_operation_id
  47. --            AND   bop.operation_code = xwmtv.fm_operation_code
  48. --            AND  xwmtv.fm_operation_code = xwmtv.to_operation_code
  49.             AND   wo.wip_entity_id = wdj.wip_entity_id
  50.             AND   wo.organization_id = wdj.organization_id
  51.             AND   wor.wip_entity_id = wdj.wip_entity_id
  52.             AND   wor.operation_seq_num = wo.operation_seq_num
  53.             AND   res.resource_id = wor.resource_id
  54.             AND   res.resource_code LIKE 'TP%'
  55.             AND   we.wip_entity_name = 'TEST12'
  56.     ) job,
  57.     apps.xxmlx_item_testprog_details_v tp
  58. WHERE
  59.     tp.test_specification_name = job.test_specification_name
  60.     AND   tp.item_id = job.inventory_item_id
  61.     AND   tp.organization_id = job.organization_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement