APPS.WIP_JSI_DEFAULTER dependencies on MTL_SYSTEM_ITEMS_KFV

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');