[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;
1631: wdj.completion_subinventory subinv,
1632: wdj.completion_locator_id locID,
1633: mp.negative_inv_receipt_code negative_allow,
1634: msik.concatenated_segments assembly_name
1635: FROM wip_discrete_jobs wdj,
1636: mtl_system_items_kfv msik,
1637: mtl_parameters mp,
1638: wip_move_txn_interface wmti
1639: WHERE wdj.primary_item_id = msik.inventory_item_id
2656: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2657: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2658: AND EXISTS -- serialized job
2659: (SELECT 'X'
2660: FROM wip_discrete_jobs wdj
2661: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2662: AND wdj.serialization_start_op IS NOT NULL
2663: AND (-- Forward move
2664: (wmti.fm_operation_seq_num < wdj.serialization_start_op AND
2695: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2696: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2697: AND EXISTS -- serialized discrete job and serialized transaction
2698: (SELECT 'X'
2699: FROM wip_discrete_jobs wdj,
2700: wip_entities we
2701: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2702: AND wdj.wip_entity_id = we.wip_entity_id
2703: AND we.entity_type = WIP_CONSTANTS.DISCRETE
2723: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2724: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2725: AND EXISTS -- regular job
2726: (SELECT 'X'
2727: FROM wip_discrete_jobs wdj
2728: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2729: AND (wdj.serialization_start_op IS NULL -- non-serialized job
2730: OR -- serialized job with non-serialized move
2731: (wdj.serialization_start_op IS NOT NULL
2760: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2761: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2762: AND EXISTS -- serialized job and serialized transaction
2763: (SELECT 'X'
2764: FROM wip_discrete_jobs wdj
2765: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2766: AND wdj.serialization_start_op IS NOT NULL
2767: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2768: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
2813: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2814: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2815: AND EXISTS -- serialized job and serialized transaction
2816: (SELECT 'X'
2817: FROM wip_discrete_jobs wdj
2818: WHERE wdj.wip_entity_id = wmti.wip_entity_id
2819: AND wdj.serialization_start_op IS NOT NULL
2820: AND wmti.fm_operation_seq_num >= wdj.serialization_start_op
2821: AND wmti.to_operation_seq_num >= wdj.serialization_start_op)
3105:
3106: if (l_assm_item_id is NULL) then
3107: select wdj.primary_item_id
3108: into l_assm_item_id
3109: from wip_discrete_jobs wdj
3110: where wdj.organization_id = l_org_id
3111: and wdj.wip_entity_id = l_wip_entity_id;
3112: end if;
3113: