Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- operation_seq_num,
- operation_code,
- test_condition,
- tp.TEST_SPECIFICATION_NAME
- FROM
- (
- SELECT
- msi.inventory_item_id,
- msi.organization_id,
- msi.segment1,
- we.wip_entity_name,
- bop.operation_code,
- -- xwmtv.fm_operation_seq_num,
- wo.operation_seq_num,
- wo.description,
- wo.quantity_in_queue,
- wo.quantity_running,
- wo.quantity_waiting_to_move,
- 'Test Condition '
- || ROW_NUMBER() OVER(
- PARTITION BY msi.segment1,
- we.wip_entity_name,
- bop.operation_code
- ORDER BY
- wo.operation_seq_num
- ) AS test_specification_name
- FROM
- apps.mtl_system_items msi,
- apps.wip_entities we,
- apps.wip_operations wo,
- apps.wip_discrete_jobs wdj,
- apps.bom_standard_operations bop,
- apps.wip_operation_resources wor,
- apps.bom_resources res-- apps.XXMLX_WIP_MOVE_TRANSACTIONS_V xwmtv
- WHERE
- msi.inventory_item_id = we.primary_item_id
- AND msi.organization_id = we.organization_id
- AND we.wip_entity_id = wo.wip_entity_id
- AND we.organization_id = wo.organization_id
- AND we.wip_entity_id = wdj.wip_entity_id
- AND we.organization_id = wdj.organization_id
- -- AND we.wip_entity_id =xwmtv.wip_entity_id
- -- AND we.organization_id = xwmtv.organization_id
- AND bop.standard_operation_id = wo.standard_operation_id
- -- AND bop.operation_code = xwmtv.fm_operation_code
- -- AND xwmtv.fm_operation_code = xwmtv.to_operation_code
- AND wo.wip_entity_id = wdj.wip_entity_id
- AND wo.organization_id = wdj.organization_id
- AND wor.wip_entity_id = wdj.wip_entity_id
- AND wor.operation_seq_num = wo.operation_seq_num
- AND res.resource_id = wor.resource_id
- AND res.resource_code LIKE 'TP%'
- AND we.wip_entity_name = 'TEST12'
- ) job,
- apps.xxmlx_item_testprog_details_v tp
- WHERE
- tp.test_specification_name = job.test_specification_name
- AND tp.item_id = job.inventory_item_id
- AND tp.organization_id = job.organization_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement