APPS.WIP_VALIDATEMLHEADER_PVT dependencies on MTL_SYSTEM_ITEMS

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 1196: from mtl_system_items msi

1192: and wjsi.primary_item_id is not null
1193: and ( wjsi.load_type in (wip_constants.create_job, wip_constants.create_sched)
1194: or (wjsi.load_type = wip_constants.create_ns_job and wjsi.primary_item_id is not null) )
1195: and not exists (select 1
1196: from mtl_system_items msi
1197: where msi.organization_id = wjsi.organization_id
1198: and msi.inventory_item_id = wjsi.primary_item_id)
1199: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1200:

Line 1220: from mtl_system_items msi

1216: wjsi.load_type in (wip_constants.create_job,
1217: wip_constants.create_ns_job,
1218: wip_constants.create_sched) and
1219: ( 'Y' <> (select msi.build_in_wip_flag
1220: from mtl_system_items msi
1221: where msi.organization_id = wjsi.organization_id
1222: and msi.inventory_item_id = wjsi.primary_item_id) or
1223: 'N' <> (select msi.pick_components_flag
1224: from mtl_system_items msi

Line 1224: from mtl_system_items msi

1220: from mtl_system_items msi
1221: where msi.organization_id = wjsi.organization_id
1222: and msi.inventory_item_id = wjsi.primary_item_id) or
1223: 'N' <> (select msi.pick_components_flag
1224: from mtl_system_items msi
1225: where msi.organization_id = wjsi.organization_id
1226: and msi.inventory_item_id = wjsi.primary_item_id) or
1227: (l_see_eng_items_flag = wip_constants.no and
1228: 'Y' = (select msi.eng_item_flag

Line 1229: from mtl_system_items msi

1225: where msi.organization_id = wjsi.organization_id
1226: and msi.inventory_item_id = wjsi.primary_item_id) or
1227: (l_see_eng_items_flag = wip_constants.no and
1228: 'Y' = (select msi.eng_item_flag
1229: from mtl_system_items msi
1230: where msi.organization_id = wjsi.organization_id
1231: and msi.inventory_item_id = wjsi.primary_item_id)))))
1232: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1233:

Line 1272: from mtl_system_items msi

1268: wip_constants.create_sched,
1269: wip_constants.create_ns_job)
1270: and wjsi.primary_item_id is not null
1271: and 'Y' = (select msi.replenish_to_order_flag
1272: from mtl_system_items msi
1273: where msi.organization_id = wjsi.organization_id
1274: and msi.inventory_item_id = wjsi.primary_item_id)
1275: and 4 = (select msi.bom_item_type
1276: from mtl_system_items msi

Line 1276: from mtl_system_items msi

1272: from mtl_system_items msi
1273: where msi.organization_id = wjsi.organization_id
1274: and msi.inventory_item_id = wjsi.primary_item_id)
1275: and 4 = (select msi.bom_item_type
1276: from mtl_system_items msi
1277: where msi.organization_id = wjsi.organization_id
1278: and msi.inventory_item_id = wjsi.primary_item_id)
1279: and not exists (select 1
1280: from bom_bill_of_materials bom

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 1508: from mtl_system_items msi

1504: where wdj.wip_entity_id = wjsi.wip_entity_id
1505: and wdj.organization_id = wjsi.organization_id)))
1506: and wjsi.routing_reference_id is not null
1507: and ('Y' <> (select msi.build_in_wip_flag
1508: from mtl_system_items msi
1509: where msi.organization_id = wjsi.organization_id
1510: and msi.inventory_item_id = wjsi.routing_reference_id) or
1511: 'N' <> (select msi.pick_components_flag
1512: from mtl_system_items msi

Line 1512: from mtl_system_items msi

1508: from mtl_system_items msi
1509: where msi.organization_id = wjsi.organization_id
1510: and msi.inventory_item_id = wjsi.routing_reference_id) or
1511: 'N' <> (select msi.pick_components_flag
1512: from mtl_system_items msi
1513: where msi.organization_id = wjsi.organization_id
1514: and msi.inventory_item_id = wjsi.routing_reference_id) or
1515: (l_see_eng_items_flag = wip_constants.no and
1516: 'Y' = (select msi.eng_item_flag

Line 1517: from mtl_system_items msi

1513: where msi.organization_id = wjsi.organization_id
1514: and msi.inventory_item_id = wjsi.routing_reference_id) or
1515: (l_see_eng_items_flag = wip_constants.no and
1516: 'Y' = (select msi.eng_item_flag
1517: from mtl_system_items msi
1518: where msi.organization_id = wjsi.organization_id
1519: and msi.inventory_item_id = wjsi.routing_reference_id)))
1520: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1521:

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:

Line 1850: from mtl_system_items msi

1846: where wdj.wip_entity_id = wjsi.wip_entity_id
1847: and wdj.organization_id = wjsi.organization_id)))
1848: and wjsi.bom_reference_id is not null
1849: and ('Y' <> (select msi.build_in_wip_flag
1850: from mtl_system_items msi
1851: where msi.organization_id = wjsi.organization_id
1852: and msi.inventory_item_id = wjsi.bom_reference_id) or
1853: 'N' <> (select msi.pick_components_flag
1854: from mtl_system_items msi

Line 1854: from mtl_system_items msi

1850: from mtl_system_items msi
1851: where msi.organization_id = wjsi.organization_id
1852: and msi.inventory_item_id = wjsi.bom_reference_id) or
1853: 'N' <> (select msi.pick_components_flag
1854: from mtl_system_items msi
1855: where msi.organization_id = wjsi.organization_id
1856: and msi.inventory_item_id = wjsi.bom_reference_id) or
1857: (l_see_eng_items_flag = wip_constants.no and
1858: 'Y' = (select msi.eng_item_flag

Line 1859: from mtl_system_items msi

1855: where msi.organization_id = wjsi.organization_id
1856: and msi.inventory_item_id = wjsi.bom_reference_id) or
1857: (l_see_eng_items_flag = wip_constants.no and
1858: 'Y' = (select msi.eng_item_flag
1859: from mtl_system_items msi
1860: where msi.organization_id = wjsi.organization_id
1861: and msi.inventory_item_id = wjsi.bom_reference_id)))
1862: returning wjsi.interface_id bulk collect into l_interfaceTbl;
1863:

Line 3341: from mtl_system_items

3337: primary_item_row.restrict_locators_code,
3338: primary_item_row.location_control_code,
3339: primary_item_row.fixed_lead_time,
3340: primary_item_row.variable_lead_time
3341: from mtl_system_items
3342: where inventory_item_id = l_primaryItemID
3343: and organization_id = wjsi_row.organization_id;
3344: end if;
3345: end setup;

Line 4525: from mtl_system_items

4521: update wip_discrete_jobs
4522: set serialization_start_op = p_rtgVal
4523: where wip_entity_id = l_wipID
4524: and exists (select 1
4525: from mtl_system_items
4526: where inventory_item_id = l_primaryItem
4527: and organization_id = l_orgID
4528: and serial_number_control_code = wip_constants.full_sn);
4529:

Line 4537: from mtl_system_items

4533: from wip_operations
4534: where wip_entity_id = l_wipID)
4535: where wip_entity_id = l_wipID
4536: and exists (select 1
4537: from mtl_system_items
4538: where inventory_item_id = l_primaryItem
4539: and organization_id = l_orgID
4540: and serial_number_control_code = wip_constants.full_sn);
4541: end if;

Line 4597: mtl_system_items msi

4593: --job must have an assembly, and the assembly must be serial controlled (predefined).
4594: select 1
4595: into l_dummy
4596: from wip_discrete_jobs wdj,
4597: mtl_system_items msi
4598: where wdj.primary_item_id = msi.inventory_item_id
4599: and wdj.organization_id = msi.organization_id
4600: and wdj.wip_entity_id = l_wipEntityID
4601: and msi.serial_number_control_code = wip_constants.full_sn;