DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on MTL_SYSTEM_ITEMS

Line 78: mtl_system_items_kfv msik

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)

Line 584: from mtl_system_items msi

580: and wjdi.substitution_type = p_substitution_type
581: and wjdi.operation_seq_num = p_operation_seq_num
582: and wjdi.inventory_item_id_new = p_inventory_item_id_new
583: and not exists (select 1
584: from mtl_system_items msi
585: where msi.inventory_item_id = wjdi.inventory_item_id_new
586: and msi.organization_id = wjdi.organization_id);
587:
588: /* bug#2811687 : begin */

Line 663: and NOT exists ( select 1 from mtl_system_items msi

659: and wjdi.load_type = wip_job_details.wip_mtl_requirement
660: and wjdi.substitution_type = p_substitution_type
661: and wjdi.operation_seq_num = p_operation_seq_num
662: and wjdi.inventory_item_id_new = p_inventory_item_id_new
663: and NOT exists ( select 1 from mtl_system_items msi
664: where msi.inventory_item_id = wjdi.inventory_item_id_new
665: and msi.organization_id = wjdi.organization_id
666: and BOM_ENABLED_FLAG = 'Y'
667: and BOM_ITEM_TYPE = 4

Line 772: from mtl_system_items msi

768: and wjdi.operation_seq_num = p_operation_seq_num
769: and wjdi.inventory_item_id_new = p_inventory_item_id_new;
770: /* bug#2811687
771: and not exists (select 1
772: from mtl_system_items msi
773: where msi.inventory_item_id = wjdi.inventory_item_id_new
774: and msi.organization_id = wjdi.organization_id);
775: */
776: end if;