APPS.WIP_VALIDATEMLHEADER_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1160: from mtl_system_items_kfv msik

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

Line 1173: from mtl_system_items_kfv msik

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

Line 1433: from mtl_system_items_kfv msik

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

Line 1451: from mtl_system_items_kfv msik

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

Line 1483: from mtl_system_items_kfv msik

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

Line 1775: from mtl_system_items_kfv msik

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

Line 1793: from mtl_system_items_kfv msik

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

Line 1825: from mtl_system_items_kfv msik

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