APPS.WIP_JSI_DEFAULTER dependencies on MTL_SYSTEM_ITEMS

Line 203: from mtl_system_items

199: update wip_discrete_jobs
200: set serialization_start_op = p_rtgVal
201: where wip_entity_id = l_wipID
202: and exists (select 1
203: from mtl_system_items
204: where inventory_item_id = l_primaryItem
205: and organization_id = l_orgID
206: and serial_number_control_code = wip_constants.full_sn);
207:

Line 215: from mtl_system_items

211: from wip_operations
212: where wip_entity_id = l_wipID)
213: where wip_entity_id = l_wipID
214: and exists (select 1
215: from mtl_system_items
216: where inventory_item_id = l_primaryItem
217: and organization_id = l_orgID
218: and serial_number_control_code = wip_constants.full_sn);
219: end if;

Line 637: from mtl_system_items_kfv

633: elsif(wjsi_row.primary_item_segments is not null) then
634: if(wjsi_row.primary_item_id is null) then
635: select inventory_item_id
636: into wjsi_row.primary_item_id
637: from mtl_system_items_kfv
638: where concatenated_segments = wjsi_row.primary_item_segments
639: and organization_id = wjsi_row.organization_id;
640: else
641: wip_jsi_utils.record_ignored_column_warning('PRIMARY_ITEM_SEGMENTS');

Line 846: from mtl_system_items_kfv

842: elsif(wjsi_row.routing_reference_segments is not null) then
843: if(wjsi_row.routing_reference_id is null) then
844: select inventory_item_id
845: into wjsi_row.routing_reference_id
846: from mtl_system_items_kfv
847: where concatenated_segments = wjsi_row.routing_reference_segments
848: and organization_id = wjsi_row.organization_id;
849: else
850: wip_jsi_utils.record_ignored_column_warning('ROUTING_REFERENCE_SEGMENTS');

Line 872: from mtl_system_items_kfv

868: elsif(wjsi_row.bom_reference_segments is not null) then
869: if(wjsi_row.bom_reference_id is null) then
870: select inventory_item_id
871: into wjsi_row.bom_reference_id
872: from mtl_system_items_kfv
873: where concatenated_segments = wjsi_row.bom_reference_segments
874: and organization_id = wjsi_row.organization_id;
875: else
876: wip_jsi_utils.record_ignored_column_warning('BOM_REFERENCE_SEGMENTS');

Line 1378: from mtl_system_items_kfv

1374: elsif(wjsi_row.asset_group_segments is not null) then
1375: if(wjsi_row.asset_group_id is null) then
1376: select inventory_item_id
1377: into wjsi_row.asset_group_id
1378: from mtl_system_items_kfv
1379: where concatenated_segments = wjsi_row.asset_group_segments
1380: and organization_id = wjsi_row.organization_id;
1381: else
1382: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_SEGMENTS');

Line 1432: from mtl_system_items_kfv

1428: elsif(wjsi_row.rebuild_item_segments is not null) then
1429: if(wjsi_row.rebuild_item_id is null) then
1430: select inventory_item_id
1431: into wjsi_row.rebuild_item_id
1432: from mtl_system_items_kfv
1433: where concatenated_segments = wjsi_row.rebuild_item_segments
1434: and organization_id = wjsi_row.organization_id;
1435: else
1436: wip_jsi_utils.record_ignored_column_warning('REBUILD_ITEM_SEGMENTS');

Line 1757: from mtl_system_items

1753: wjsi_row.maintenance_object_type := 1; --MSN
1754: else
1755: select serial_number_control_code
1756: into l_serial_number_control_code
1757: from mtl_system_items
1758: where organization_id = wjsi_row.organization_id
1759: and inventory_item_id = wjsi_row.rebuild_item_id;
1760:
1761: if(l_serial_number_control_code in (2, 5, 6)) then