[Home] [Help]
2381:
2382: if(wjsi_row.asset_group_id is not null) then
2383: select 1
2384: into g_dummy
2385: from mtl_serial_numbers
2386: where inventory_item_id = wjsi_row.asset_group_id
2387: and current_organization_id = wjsi_row.organization_id
2388: and serial_number = wjsi_row.asset_number
2389: and maintainable_flag = 'Y';
2431: else
2432: if(wjsi_row.maintenance_object_type = 1) then
2433: select 1
2434: into g_dummy
2435: from mtl_serial_numbers
2436: where serial_number = wjsi_row.rebuild_serial_number
2437: and inventory_item_id = wjsi_row.rebuild_item_id
2438: and current_organization_id = wjsi_row.organization_id
2439: and current_status in (1,3,4);--defined not used, resides in stores, issued out nocopy of stores (consistent w/EAM UI)
2439: and current_status in (1,3,4);--defined not used, resides in stores, issued out nocopy of stores (consistent w/EAM UI)
2440: elsif(wjsi_row.maintenance_object_type = 3) then
2441: select 1
2442: into g_dummy
2443: from mtl_serial_numbers
2444: where serial_number = wjsi_row.rebuild_serial_number
2445: and inventory_item_id = wjsi_row.rebuild_item_id
2446: and current_organization_id = wjsi_row.organization_id;
2447: end if;
2659: if(wjsi_row.maintenance_object_type = 1) then
2660: if(wjsi_row.rebuild_item_id is null) then
2661: select 1
2662: into g_dummy
2663: from mtl_serial_numbers
2664: where current_organization_id = wjsi_row.organization_id
2665: and inventory_item_id = wjsi_row.asset_group_id
2666: and serial_number = wjsi_row.asset_number
2667: and gen_object_id = wjsi_row.maintenance_object_id;
2667: and gen_object_id = wjsi_row.maintenance_object_id;
2668: else
2669: select 1
2670: into g_dummy
2671: from mtl_serial_numbers
2672: where current_organization_id = wjsi_row.organization_id
2673: and inventory_item_id = wjsi_row.rebuild_item_id
2674: and serial_number = wjsi_row.rebuild_serial_number
2675: and gen_object_id = wjsi_row.maintenance_object_id;