APPS.WIP_JSI_VALIDATOR dependencies on MTL_SERIAL_NUMBERS

Line 2380: from mtl_serial_numbers

2376:
2377: if(wjsi_row.asset_group_id is not null) then
2378: select 1
2379: into g_dummy
2380: from mtl_serial_numbers
2381: where inventory_item_id = wjsi_row.asset_group_id
2382: and current_organization_id = wjsi_row.organization_id
2383: and serial_number = wjsi_row.asset_number
2384: and maintainable_flag = 'Y';

Line 2430: from mtl_serial_numbers

2426: else
2427: if(wjsi_row.maintenance_object_type = 1) then
2428: select 1
2429: into g_dummy
2430: from mtl_serial_numbers
2431: where serial_number = wjsi_row.rebuild_serial_number
2432: and inventory_item_id = wjsi_row.rebuild_item_id
2433: and current_organization_id = wjsi_row.organization_id
2434: and current_status in (1,3,4);--defined not used, resides in stores, issued out nocopy of stores (consistent w/EAM UI)

Line 2438: from mtl_serial_numbers

2434: and current_status in (1,3,4);--defined not used, resides in stores, issued out nocopy of stores (consistent w/EAM UI)
2435: elsif(wjsi_row.maintenance_object_type = 3) then
2436: select 1
2437: into g_dummy
2438: from mtl_serial_numbers
2439: where serial_number = wjsi_row.rebuild_serial_number
2440: and inventory_item_id = wjsi_row.rebuild_item_id
2441: and current_organization_id = wjsi_row.organization_id;
2442: end if;

Line 2658: from mtl_serial_numbers

2654: if(wjsi_row.maintenance_object_type = 1) then
2655: if(wjsi_row.rebuild_item_id is null) then
2656: select 1
2657: into g_dummy
2658: from mtl_serial_numbers
2659: where current_organization_id = wjsi_row.organization_id
2660: and inventory_item_id = wjsi_row.asset_group_id
2661: and serial_number = wjsi_row.asset_number
2662: and gen_object_id = wjsi_row.maintenance_object_id;

Line 2666: from mtl_serial_numbers

2662: and gen_object_id = wjsi_row.maintenance_object_id;
2663: else
2664: select 1
2665: into g_dummy
2666: from mtl_serial_numbers
2667: where current_organization_id = wjsi_row.organization_id
2668: and inventory_item_id = wjsi_row.rebuild_item_id
2669: and serial_number = wjsi_row.rebuild_serial_number
2670: and gen_object_id = wjsi_row.maintenance_object_id;