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 1402: from mtl_system_items_kfv

1398: elsif(wjsi_row.asset_group_segments is not null) then
1399: if(wjsi_row.asset_group_id is null) then
1400: select inventory_item_id
1401: into wjsi_row.asset_group_id
1402: from mtl_system_items_kfv
1403: where concatenated_segments = wjsi_row.asset_group_segments
1404: and organization_id = wjsi_row.organization_id;
1405: else
1406: wip_jsi_utils.record_ignored_column_warning('ASSET_GROUP_SEGMENTS');

Line 1456: from mtl_system_items_kfv

1452: elsif(wjsi_row.rebuild_item_segments is not null) then
1453: if(wjsi_row.rebuild_item_id is null) then
1454: select inventory_item_id
1455: into wjsi_row.rebuild_item_id
1456: from mtl_system_items_kfv
1457: where concatenated_segments = wjsi_row.rebuild_item_segments
1458: and organization_id = wjsi_row.organization_id;
1459: else
1460: wip_jsi_utils.record_ignored_column_warning('REBUILD_ITEM_SEGMENTS');