APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_SERIAL_NUMBERS

Line 332: ||' from mtl_serial_numbers'

328: ||' From mtl_lot_numbers'
329: ||' Where inventory_item_id = '||g_inventory_item_id
330: ||' and organization_id = '||g_organization_id
331: ||' and lot_number not in (Select lot_number '
332: ||' from mtl_serial_numbers'
333: ||' where lot_number is not null) '
334: ||' Union all'
335: ||' Select gen_object_id object_id'
336: ||' , 2 object_type' --bug14027562,for the serial number,the object type should be with 2

Line 338: ||' From mtl_serial_numbers'

334: ||' Union all'
335: ||' Select gen_object_id object_id'
336: ||' , 2 object_type' --bug14027562,for the serial number,the object type should be with 2
337: ||' , lot_number lot_number'
338: ||' From mtl_serial_numbers'
339: ||' Where inventory_item_id = '||g_inventory_item_id
340: ;
341: elsif p_serial_number is not null
342: and p_wip_entity_name is null then

Line 346: ||' From mtl_serial_numbers'

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

Line 359: ||' From mtl_serial_numbers'

355: then
356: l_main_query := ' Select gen_object_id object_id'
357: ||' , 2 object_type'
358: ||' , lot_number lot_number'
359: ||' From mtl_serial_numbers'
360: ||' Where inventory_item_id = '||g_inventory_item_id
361: ||' and lot_number = '||''''||p_lot_number||''''
362: ||' Union all '
363: ||' Select gen_object_id object_id'

Line 371: ||' From mtl_serial_numbers'

367: ||' Where inventory_item_id = '||g_inventory_item_id
368: ||' and organization_id = '||g_organization_id
369: ||' and lot_number = '||''''||p_lot_number||''''
370: ||' and lot_number not in (Select lot_number'
371: ||' From mtl_serial_numbers'
372: ||' Where lot_number is not null )'
373: ;
374: elsif p_wip_entity_name is not null
375: and p_lot_number is null

Line 425: ||' From mtl_serial_numbers msn '

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

Line 439: ||' From mtl_serial_numbers msn '

435: then
436: l_main_query := ' Select we.gen_object_id object_id'
437: ||' , 5 object_type'
438: ||' , lot_number lot_number'
439: ||' From mtl_serial_numbers msn '
440: ||' , wip_entities we '
441: ||' Where msn.serial_number = '||''''|| p_serial_number||''''
442: ||' and we.wip_entity_name = '||''''||p_wip_entity_name||''''
443: ||' and msn.lot_number = '||''''||p_lot_number||''''

Line 699: , mtl_serial_numbers msn

695: , l_current_org_desc
696: , l_current_org_id
697: FROM mtl_parameters mp
698: , hr_organization_units hou
699: , mtl_serial_numbers msn
700: WHERE msn.gen_object_id = l_object_id
701: AND mp.organization_id = msn.current_organization_id
702: AND hou.organization_id = msn.current_organization_id;
703: END IF;

Line 1106: from mtl_serial_numbers_all_v

1102: , inventory_item_id
1103: , operation_seq_num
1104: , intraoperation_step_type
1105: , lot_number
1106: from mtl_serial_numbers_all_v
1107: where serial_number = p_serial_attributes_rec.serial_number
1108: and gen_object_id = p_serial_attributes_rec.object_id;
1109:
1110: cursor get_job_info IS