[Home] [Help]
384: (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,
385: WIP_CONSTANTS.LOTBASED)
386: AND NOT EXISTS
387: (SELECT 'X'
388: FROM wip_discrete_jobs wdj
389: WHERE wdj.wip_entity_id = wmti.wip_entity_id
390: AND wdj.organization_id = wmti.organization_id
391: AND wdj.status_type IN (WIP_CONSTANTS.RELEASED,
392: WIP_CONSTANTS.COMP_CHRG))))
473: WIP_CONSTANTS.RET_TXN)
474: AND EXISTS
475: (SELECT 'X'
476: FROM mtl_system_items msi,
477: wip_discrete_jobs wdj
478: WHERE wdj.wip_entity_id = wmti.wip_entity_id
479: AND msi.inventory_item_id = wmti.primary_item_id
480: AND msi.organization_id = wmti.organization_id
481: AND wdj.serialization_start_op IS NULL
511: (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,
512: WIP_CONSTANTS.LOTBASED)
513: AND EXISTS
514: (SELECT 'X'
515: FROM wip_discrete_jobs wdj
516: WHERE wdj.wip_entity_id = wmti.wip_entity_id
517: AND wdj.organization_id = wmti.organization_id
518: AND wdj.completion_subinventory IS NULL)))
519: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
556: (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,
557: WIP_CONSTANTS.LOTBASED)
558: AND NOT EXISTS
559: (SELECT 'X'
560: FROM wip_discrete_jobs wdj,
561: mtl_item_revisions mir
562: WHERE wdj.organization_id = wmti.organization_id
563: AND wdj.wip_entity_id = wmti.wip_entity_id
564: AND mir.organization_id = wmti.organization_id
618: AND msi.organization_id = wmti.organization_id
619: AND msi.lot_control_code = WIP_CONSTANTS.LOT)
620: AND EXISTS
621: (SELECT 'X'
622: FROM wip_discrete_jobs wdj
623: WHERE wdj.organization_id = wmti.organization_id
624: AND wdj.wip_entity_id = wmti.wip_entity_id
625: AND wdj.lot_number IS NULL)
626: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
651: -- This is the first time to complete this assembly to this lot number
652: AND NOT EXISTS
653: (SELECT 'X'
654: FROM mtl_lot_numbers mln,
655: wip_discrete_jobs wdj
656: WHERE wdj.wip_entity_id = wmti.wip_entity_id
657: AND wdj.organization_id = wmti.organization_id
658: AND mln.inventory_item_id = wmti.primary_item_id
659: AND mln.organization_id = wmti.organization_id
692: -- This is the first time to complete this assembly to this lot number
693: AND NOT EXISTS
694: (SELECT 'X'
695: FROM mtl_lot_numbers mln,
696: wip_discrete_jobs wdj
697: WHERE wdj.wip_entity_id = wmti.wip_entity_id
698: AND wdj.organization_id = wmti.organization_id
699: AND mln.inventory_item_id = wmti.primary_item_id
700: AND mln.organization_id = wmti.organization_id
776: (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,
777: WIP_CONSTANTS.LOTBASED)
778: AND EXISTS
779: (SELECT 'X'
780: FROM wip_discrete_jobs wdj
781: WHERE wdj.wip_entity_id = wmti.wip_entity_id
782: AND wdj.organization_id = wmti.organization_id
783: AND wdj.date_released > wmti.transaction_date)))
784: RETURNING wmti.transaction_id BULK COLLECT INTO enums;
1563: wdj.completion_subinventory subinv,
1564: wdj.completion_locator_id locID,
1565: mp.negative_inv_receipt_code negative_allow,
1566: msik.concatenated_segments assembly_name
1567: FROM wip_discrete_jobs wdj,
1568: mtl_system_items_kfv msik,
1569: mtl_parameters mp,
1570: wip_move_txn_interface wmti
1571: WHERE wdj.primary_item_id = msik.inventory_item_id
2588: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2589: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2590: AND EXISTS -- serialized job
2591: (SELECT 'X'
2592: FROM wip_discrete_jobs wdj
2593: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2594: AND wdj.serialization_start_op IS NOT NULL
2595: AND (-- Forward move
2596: (wmti.fm_operation_seq_num < wdj.serialization_start_op AND
2627: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2628: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2629: AND EXISTS -- serialized discrete job and serialized transaction
2630: (SELECT 'X'
2631: FROM wip_discrete_jobs wdj,
2632: wip_entities we
2633: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2634: AND wdj.wip_entity_id = we.wip_entity_id
2635: AND we.entity_type = WIP_CONSTANTS.DISCRETE
2655: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2656: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2657: AND EXISTS -- regular job
2658: (SELECT 'X'
2659: FROM wip_discrete_jobs wdj
2660: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2661: AND (wdj.serialization_start_op IS NULL -- non-serialized job
2662: OR -- serialized job with non-serialized move
2663: (wdj.serialization_start_op IS NOT NULL
2692: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2693: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2694: AND EXISTS -- serialized job and serialized transaction
2695: (SELECT 'X'
2696: FROM wip_discrete_jobs wdj
2697: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2698: AND wdj.serialization_start_op IS NOT NULL
2699: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2700: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
2745: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2746: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2747: AND EXISTS -- serialized job and serialized transaction
2748: (SELECT 'X'
2749: FROM wip_discrete_jobs wdj
2750: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2751: AND wdj.serialization_start_op IS NOT NULL
2752: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2753: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
3037:
3038: if (l_assm_item_id is NULL) then
3039: select wdj.primary_item_id
3040: into l_assm_item_id
3041: from wip_discrete_jobs wdj
3042: where wdj.organization_id = l_org_id
3043: and wdj.wip_entity_id = l_wip_entity_id;
3044: end if;
3045: