eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_GENEALOGY_REPORT_GEN dependencies on INV_OBJECT_GENEALOGY

Line 577: l_object_label := inv_object_genealogy.getobjectnumber

573: else
574: XML_write('item_assembly', 'Component Item: '||p_item_no);
575: end if;
576: end if;
577: l_object_label := inv_object_genealogy.getobjectnumber
578: (p_object_id, p_object_type, p_object_id2, p_object_type2);
579: XML_write('object_label', l_object_label);
580: if p_lot_number is not null then
581: XML_write('lot', 'Lot: '||p_lot_number);

Line 702: inv_object_genealogy.getobjectinfo(

698: AND hou.organization_id = msn.current_organization_id;
699: END IF;
700:
701: IF l_object_type = 2 THEN
702: inv_object_genealogy.getobjectinfo(
703: l_object_id
704: , l_object_type
705: , l_object_name
706: , l_object_description

Line 720: inv_object_genealogy.getobjectinfo(

716: , l_intraoperation_step_type
717: , l_current_lot_number
718: );
719: ELSIF l_object_type = 1 Then
720: inv_object_genealogy.getobjectinfo(
721: l_object_id
722: , l_object_type
723: , l_object_name
724: , l_object_description

Line 2337: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)

2333: l_rec_query rc;
2334:
2335: Cursor get_child is
2336: SELECT object_id
2337: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)
2338: FROM mtl_object_genealogy
2339: WHERE parent_object_id = l_object_id
2340: ;
2341:

Line 2344: l_node_name := inv_object_genealogy.getobjectnumber

2340: ;
2341:
2342: Begin
2343: debug('Get All Children');
2344: l_node_name := inv_object_genealogy.getobjectnumber
2345: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2346: l_object_id := p_object_id;
2347: l_object_type := p_object_type;
2348:

Line 2410: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)

2406: SELECT object_id
2407: , object_type
2408: , object_id2
2409: , object_type2
2410: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)
2411: FROM mtl_object_genealogy
2412: WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)
2413: CONNECT BY PRIOR object_id = parent_object_id
2414: START WITH (parent_object_id2 IS NULL OR parent_object_id2 = l_object_id2)

Line 2445: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'

2441: l_query := ' SELECT object_id '
2442: ||' , object_type'
2443: ||' , object_id2'
2444: ||' , object_type2'
2445: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2446: ||' FROM mtl_object_genealogy'
2447: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2448: ||' and decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2449: ||' AND parent_object_id = '||l_object_id

Line 2455: /*l_child_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);

2451: --||' START WITH decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2452: --||' AND parent_object_id = '||l_object_id
2453: ;
2454: /* It was decided that the direct job link should also be included */
2455: /*l_child_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);
2456: if l_child_rg_name = 'CHILD_INFO_DGEN' THEN
2457: l_query := l_query || ' and object_type <> 5';
2458: end if;
2459: */

Line 2465: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'

2461: l_query := 'SELECT object_id '
2462: ||' , object_type '
2463: ||' , object_id2 '
2464: ||' , object_type2 '
2465: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2466: ||' FROM mtl_object_genealogy '
2467: ||' WHERE parent_object_id = '||l_object_id
2468: ||' AND(end_date_active IS NULL '
2469: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

Line 2506: l_node_name := inv_object_genealogy.getobjectnumber

2502: Exit When l_child_query %NOTFOUND;
2503:
2504: debug(' drill down the tree, level '||l_level||' '||l_node_name||' Object_type '||l_object_type||' object_id '||l_object_id);
2505:
2506: l_node_name := inv_object_genealogy.getobjectnumber
2507: (l_object_id, l_object_type, l_object_id2, l_object_type2);
2508:
2509: write_group_begin('tree_node_level'||l_level);
2510: XML_write('level'||l_level, l_node_name);

Line 2552: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)

2548: SELECT object_id
2549: , object_type
2550: , object_id2
2551: , object_type2
2552: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)
2553: FROM mtl_object_genealogy
2554: WHERE parent_object_id = l_object_id
2555: ;
2556: Cursor get_gme_security IS

Line 2566: l_node_name := inv_object_genealogy.getobjectnumber

2562: and wip.wip_entity_id = gme.batch_id
2563: ;
2564: Begin
2565: debug(' Write children reports');
2566: l_node_name := inv_object_genealogy.getobjectnumber
2567: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2568: l_current_object_id := p_object_id;
2569: l_object_id := p_object_id;
2570: l_object_type := p_object_type;

Line 2589: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'

2585: l_query := ' SELECT object_id '
2586: ||' , object_type'
2587: ||' , object_id2'
2588: ||' , object_type2'
2589: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2590: ||' FROM mtl_object_genealogy'
2591: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2592: ||' and decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2593: ||' AND parent_object_id = '||l_object_id

Line 2598: /*l_child_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);

2594: --||' CONNECT BY PRIOR object_id = parent_object_id'
2595: --||' START WITH decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2596: --||' AND parent_object_id = '||l_object_id
2597: ;
2598: /*l_child_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);
2599: if l_child_rg_name = 'CHILD_INFO_DGEN' THEN
2600: l_query := l_query || ' and object_type <> 5';
2601: end if;
2602: */

Line 2608: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'

2604: l_query := 'SELECT object_id '
2605: ||' , object_type '
2606: ||' , object_id2 '
2607: ||' , object_type2 '
2608: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2609: ||' FROM mtl_object_genealogy '
2610: ||' WHERE parent_object_id = '||l_object_id
2611: ||' AND(end_date_active IS NULL '
2612: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

Line 2679: l_node_name := inv_object_genealogy.getobjectnumber

2675: l_rec_query rc;
2676:
2677: Begin
2678: debug('Get All Parents');
2679: l_node_name := inv_object_genealogy.getobjectnumber
2680: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2681: l_object_id := p_object_id;
2682: l_object_type := p_object_type;
2683:

Line 2728: , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)

2724: SELECT parent_object_id
2725: , parent_object_type
2726: , parent_object_id2
2727: , parent_object_type2
2728: , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)
2729: FROM mtl_object_genealogy
2730: WHERE object_id = l_parent_object_id
2731: ;
2732: Cursor get_gme_security IS

Line 2743: l_node_name := inv_object_genealogy.getobjectnumber

2739: ;
2740:
2741: Begin
2742: debug('Get one level parent, level '||p_level);
2743: l_node_name := inv_object_genealogy.getobjectnumber
2744: (p_parent_object_id, p_parent_object_type, p_parent_object_id2, p_parent_object_type2);
2745: l_current_parent_object_id := p_parent_object_id;
2746: l_parent_object_id := p_parent_object_id;
2747: l_parent_object_type := p_parent_object_type;

Line 2763: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'

2759: l_query := ' SELECT parent_object_id '
2760: ||' , parent_object_type'
2761: ||' , parent_object_id2'
2762: ||' , parent_object_type2'
2763: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2764: ||' FROM mtl_object_genealogy'
2765: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2766: ||' and decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2767: ||' AND object_id = '||l_parent_object_id

Line 2772: /*l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_parent_object_id);

2768: --||' CONNECT BY object_id = PRIOR parent_object_id '
2769: --||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2770: --||' AND object_id = '||l_parent_object_id
2771: ;
2772: /*l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_parent_object_id);
2773: if l_parent_rg_name = 'CHILD_INFO_DGEN' THEN
2774: l_query := l_query || ' and parent_object_type <> 5';
2775: end if;
2776: */

Line 2782: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'

2778: l_query := ' SELECT parent_object_id '
2779: ||' , parent_object_type '
2780: ||' , parent_object_id2 '
2781: ||' , parent_object_type2 '
2782: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2783: ||' FROM mtl_object_genealogy '
2784: ||' WHERE object_id = '||l_parent_object_id
2785: ||' AND(end_date_active IS NULL '
2786: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

Line 2866: l_node_name := inv_object_genealogy.getobjectnumber

2862: ;
2863:
2864: Begin
2865: debug(' Write Parents Reports');
2866: l_node_name := inv_object_genealogy.getobjectnumber
2867: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2868: l_current_object_id := p_object_id;
2869: l_object_id := p_object_id;
2870: l_object_type := p_object_type;

Line 2889: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'

2885: l_query := ' SELECT parent_object_id '
2886: ||' , parent_object_type'
2887: ||' , parent_object_id2'
2888: ||' , parent_object_type2'
2889: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2890: ||' FROM mtl_object_genealogy'
2891: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2892: ||' and decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2893: ||' AND object_id = '||l_object_id

Line 2898: /*l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);

2894: --||' CONNECT BY object_id = PRIOR parent_object_id '
2895: --||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2896: --||' AND object_id = '||l_object_id
2897: ;
2898: /*l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);
2899: if l_parent_rg_name = 'CHILD_INFO_DGEN' THEN
2900: l_query := l_query || ' and parent_object_type <> 5';
2901: end if;
2902: */

Line 2908: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'

2904: l_query := ' SELECT parent_object_id '
2905: ||' , parent_object_type '
2906: ||' , parent_object_id2 '
2907: ||' , parent_object_type2 '
2908: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2909: ||' FROM mtl_object_genealogy '
2910: ||' WHERE object_id = '||l_object_id
2911: ||' AND(end_date_active IS NULL '
2912: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

Line 2920: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'

2916: l_query := ' SELECT parent_object_id '
2917: ||' , parent_object_type'
2918: ||' , parent_object_id2'
2919: ||' , parent_object_type2'
2920: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2921: ||' FROM mtl_object_genealogy'
2922: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2923: ||' CONNECT BY object_id = PRIOR parent_object_id '
2924: ||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2

Line 2927: l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_parent_object_id);

2923: ||' CONNECT BY object_id = PRIOR parent_object_id '
2924: ||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2925: ||' AND object_id = '||l_parent_object_id
2926: ;
2927: l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_parent_object_id);
2928: if l_parent_rg_name = 'CHILD_INFO_DGEN' THEN
2929: l_query := l_query || ' and parent_object_type <> 5';
2930: end if;
2931: */

Line 3010: l_node_name := inv_object_genealogy.getobjectnumber

3006: Begin
3007: debug('Write the tree node, level '||p_level);
3008: if p_level = 0 then
3009: write_group_begin('tree_node_main_level');
3010: l_node_name := inv_object_genealogy.getobjectnumber
3011: (p_object_id, p_object_type, p_object_id2, p_object_type2);
3012: XML_write('main_level', l_node_name);
3013: else
3014: l_count := 0 ;

Line 3021: l_node_name := inv_object_genealogy.getobjectnumber

3017: exit when l_count = p_level;
3018: write_group_begin('tree_node_level'||l_count);
3019: end loop;
3020: */
3021: l_node_name := inv_object_genealogy.getobjectnumber
3022: (p_object_id, p_object_type, p_object_id2, p_object_type2);
3023: write_group_begin('tree_node_level'||p_level);
3024: XML_write('level'||p_level, l_node_name);
3025: end if;