APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_SERIAL_NUMBERS

Line 328: ||' from mtl_serial_numbers'

324: ||' From mtl_lot_numbers'
325: ||' Where inventory_item_id = '||g_inventory_item_id
326: ||' and organization_id = '||g_organization_id
327: ||' and lot_number not in (Select lot_number '
328: ||' from mtl_serial_numbers'
329: ||' where lot_number is not null) '
330: ||' Union all'
331: ||' Select gen_object_id object_id'
332: ||' , 5 object_type'

Line 334: ||' From mtl_serial_numbers'

330: ||' Union all'
331: ||' Select gen_object_id object_id'
332: ||' , 5 object_type'
333: ||' , lot_number lot_number'
334: ||' From mtl_serial_numbers'
335: ||' Where inventory_item_id = '||g_inventory_item_id
336: ;
337: elsif p_serial_number is not null
338: and p_wip_entity_name is null then

Line 342: ||' From mtl_serial_numbers'

338: and p_wip_entity_name is null then
339: l_main_query := ' Select gen_object_id object_id'
340: ||' , 2 object_type'
341: ||' , lot_number lot_number'
342: ||' From mtl_serial_numbers'
343: ||' Where inventory_item_id =' || g_inventory_item_id
344: ||' and serial_number = '||''''||p_serial_number||''''
345: ||' and decode(lot_number, null, '||''''||'%%%%%'||''''||', lot_number) '
346: ||' = decode('||''''||p_lot_number||''''||', null, '||''''||'%%%%%'||''''||','||''''||p_lot_number||''''||')'

Line 355: ||' From mtl_serial_numbers'

351: then
352: l_main_query := ' Select gen_object_id object_id'
353: ||' , 2 object_type'
354: ||' , lot_number lot_number'
355: ||' From mtl_serial_numbers'
356: ||' Where inventory_item_id = '||g_inventory_item_id
357: ||' and lot_number = '||''''||p_lot_number||''''
358: ||' Union all '
359: ||' Select gen_object_id object_id'

Line 367: ||' From mtl_serial_numbers'

363: ||' Where inventory_item_id = '||g_inventory_item_id
364: ||' and organization_id = '||g_organization_id
365: ||' and lot_number = '||''''||p_lot_number||''''
366: ||' and lot_number not in (Select lot_number'
367: ||' From mtl_serial_numbers'
368: ||' Where lot_number is not null )'
369: ;
370: elsif p_wip_entity_name is not null
371: and p_lot_number is null

Line 421: ||' From mtl_serial_numbers msn '

417: then
418: l_main_query := ' Select we.gen_object_id object_id'
419: ||' , 5 object_type'
420: ||' , lot_number lot_number'
421: ||' From mtl_serial_numbers msn '
422: ||' , wip_entities we '
423: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
424: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
425: --||' and we.wip_entity_id = msn.wip_entity_id '

Line 435: ||' From mtl_serial_numbers msn '

431: then
432: l_main_query := ' Select we.gen_object_id object_id'
433: ||' , 5 object_type'
434: ||' , lot_number lot_number'
435: ||' From mtl_serial_numbers msn '
436: ||' , wip_entities we '
437: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
438: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
439: ||' and msn.lot_number = '||''''||p_lot_number||''''

Line 695: , mtl_serial_numbers msn

691: , l_current_org_desc
692: , l_current_org_id
693: FROM mtl_parameters mp
694: , hr_organization_units hou
695: , mtl_serial_numbers msn
696: WHERE msn.gen_object_id = l_object_id
697: AND mp.organization_id = msn.current_organization_id
698: AND hou.organization_id = msn.current_organization_id;
699: END IF;

Line 1102: from mtl_serial_numbers_all_v

1098: , inventory_item_id
1099: , operation_seq_num
1100: , intraoperation_step_type
1101: , lot_number
1102: from mtl_serial_numbers_all_v
1103: where serial_number = p_serial_attributes_rec.serial_number
1104: and gen_object_id = p_serial_attributes_rec.object_id;
1105:
1106: cursor get_job_info IS