[Home] [Help]
74: msik.concatenated_segments item_name,
75: wjdi.inventory_item_id_old
76: from wip_job_dtls_interface wjdi,
77: wip_entities we,
78: mtl_system_items_kfv msik
79: where wjdi.group_id = p_group_id
80: and wjdi.process_phase = wip_constants.ml_validation
81: and wjdi.process_status in (wip_constants.running,
82: wip_constants.warning)
578: and wjdi.substitution_type = p_substitution_type
579: and wjdi.operation_seq_num = p_operation_seq_num
580: and wjdi.inventory_item_id_new = p_inventory_item_id_new
581: and not exists (select 1
582: from mtl_system_items msi
583: where msi.inventory_item_id = wjdi.inventory_item_id_new
584: and msi.organization_id = wjdi.organization_id);
585:
586: /* bug#2811687 : begin */
657: and wjdi.load_type = wip_job_details.wip_mtl_requirement
658: and wjdi.substitution_type = p_substitution_type
659: and wjdi.operation_seq_num = p_operation_seq_num
660: and wjdi.inventory_item_id_new = p_inventory_item_id_new
661: and NOT exists ( select 1 from mtl_system_items msi
662: where msi.inventory_item_id = wjdi.inventory_item_id_new
663: and msi.organization_id = wjdi.organization_id
664: and BOM_ENABLED_FLAG = 'Y'
665: and BOM_ITEM_TYPE = 4
766: and wjdi.operation_seq_num = p_operation_seq_num
767: and wjdi.inventory_item_id_new = p_inventory_item_id_new;
768: /* bug#2811687
769: and not exists (select 1
770: from mtl_system_items msi
771: where msi.inventory_item_id = wjdi.inventory_item_id_new
772: and msi.organization_id = wjdi.organization_id);
773: */
774: end if;
962: l_locationcontrol,
963: l_subLocCtl,
964: l_orgLocCtl,
965: l_project_id,l_task_id
966: from mtl_system_items msi,wip_discrete_jobs wdj,mtl_secondary_inventories sub, mtl_parameters mp
967: where msi.inventory_item_id = l_inventory_itemid
968: and msi.organization_id = p_organization_id
969: and wdj.organization_id=msi.organization_id
970: and wdj.wip_entity_id=p_wip_entity_id