APPS.WIP_VALIDATEMLHEADER_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1158: from mtl_system_items_kfv msik

1154: and wjsi.load_type in (wip_constants.create_job,
1155: wip_constants.create_ns_job,
1156: wip_constants.create_sched)
1157: and not exists (select 1
1158: from mtl_system_items_kfv msik
1159: where msik.organization_id = wjsi.organization_id
1160: and msik.concatenated_segments = wjsi.primary_item_segments)
1161: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1162:

Line 1171: from mtl_system_items_kfv msik

1167: end if;
1168:
1169: update wip_job_schedule_interface wjsi
1170: set wjsi.primary_item_id = (select msik.inventory_item_id
1171: from mtl_system_items_kfv msik
1172: where msik.organization_id = wjsi.organization_id
1173: and msik.concatenated_segments = wjsi.primary_item_segments),
1174: wjsi.last_update_date = sysdate
1175: where wjsi.group_id = p_groupID

Line 1431: from mtl_system_items_kfv msik

1427: and wdj.organization_id = wjsi.organization_id)))
1428: and wjsi.routing_reference_segments is not null
1429: and wjsi.routing_reference_id is null
1430: and not exists (select 1
1431: from mtl_system_items_kfv msik
1432: where msik.organization_id = wjsi.organization_id
1433: and msik.concatenated_segments = wjsi.routing_reference_segments)
1434: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1435:

Line 1449: from mtl_system_items_kfv msik

1445: from wip_discrete_jobs wdj
1446: where wdj.wip_entity_id = wjsi.wip_entity_id
1447: and wdj.organization_id = wjsi.organization_id),
1448: (select inventory_item_id
1449: from mtl_system_items_kfv msik
1450: where msik.organization_id = wjsi.organization_id
1451: and msik.concatenated_segments = wjsi.routing_reference_segments)),
1452: wjsi.last_update_date = sysdate
1453: where wjsi.group_id = p_groupID

Line 1481: from mtl_system_items_kfv msik

1477: where wdj.wip_entity_id = wjsi.wip_entity_id
1478: and wdj.organization_id = wjsi.organization_id)))
1479: and wjsi.routing_reference_id is not null
1480: and not exists (select 1
1481: from mtl_system_items_kfv msik
1482: where msik.organization_id = wjsi.organization_id
1483: and msik.inventory_item_id = wjsi.routing_reference_id)
1484: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1485:

Line 1773: from mtl_system_items_kfv msik

1769: and wdj.organization_id = wjsi.organization_id)))
1770: and wjsi.bom_reference_segments is not null
1771: and wjsi.bom_reference_id is null
1772: and not exists (select 1
1773: from mtl_system_items_kfv msik
1774: where msik.organization_id = wjsi.organization_id
1775: and msik.concatenated_segments = wjsi.bom_reference_segments)
1776: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1777:

Line 1791: from mtl_system_items_kfv msik

1787: from wip_discrete_jobs wdj
1788: where wdj.wip_entity_id = wjsi.wip_entity_id
1789: and wdj.organization_id = wjsi.organization_id),
1790: (select inventory_item_id
1791: from mtl_system_items_kfv msik
1792: where msik.organization_id = wjsi.organization_id
1793: and msik.concatenated_segments = wjsi.bom_reference_segments)),
1794: wjsi.last_update_date = sysdate
1795: where wjsi.group_id = p_groupID

Line 1823: from mtl_system_items_kfv msik

1819: where wdj.wip_entity_id = wjsi.wip_entity_id
1820: and wdj.organization_id = wjsi.organization_id)))
1821: and wjsi.bom_reference_id is not null
1822: and not exists (select 1
1823: from mtl_system_items_kfv msik
1824: where msik.organization_id = wjsi.organization_id
1825: and msik.inventory_item_id = wjsi.bom_reference_id)
1826: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1827: