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 581: l_object_label := inv_object_genealogy.getobjectnumber

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

Line 706: inv_object_genealogy.getobjectinfo(

702: AND hou.organization_id = msn.current_organization_id;
703: END IF;
704:
705: IF l_object_type = 2 THEN
706: inv_object_genealogy.getobjectinfo(
707: l_object_id
708: , l_object_type
709: , l_object_name
710: , l_object_description

Line 724: inv_object_genealogy.getobjectinfo(

720: , l_intraoperation_step_type
721: , l_current_lot_number
722: );
723: ELSIF l_object_type = 1 Then
724: inv_object_genealogy.getobjectinfo(
725: l_object_id
726: , l_object_type
727: , l_object_name
728: , l_object_description

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

2380: l_rec_query rc;
2381:
2382: Cursor get_child is
2383: SELECT object_id
2384: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)
2385: FROM mtl_object_genealogy
2386: WHERE parent_object_id = l_object_id
2387: ;
2388:

Line 2391: l_node_name := inv_object_genealogy.getobjectnumber

2387: ;
2388:
2389: Begin
2390: debug('Get All Children');
2391: l_node_name := inv_object_genealogy.getobjectnumber
2392: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2393: l_object_id := p_object_id;
2394: l_object_type := p_object_type;
2395:

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

2452: SELECT object_id
2453: , object_type
2454: , object_id2
2455: , object_type2
2456: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)
2457: FROM mtl_object_genealogy
2458: WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)
2459: CONNECT BY PRIOR object_id = parent_object_id
2460: START WITH (parent_object_id2 IS NULL OR parent_object_id2 = l_object_id2)

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

2480: l_query := ' SELECT object_id '
2481: ||' , object_type'
2482: ||' , object_id2'
2483: ||' , object_type2'
2484: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2485: ||' FROM mtl_object_genealogy'
2486: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2487: ||' and decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2488: ||' AND parent_object_id = '||l_object_id

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

2490: --||' START WITH decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2491: --||' AND parent_object_id = '||l_object_id
2492: ;
2493: /* It was decided that the direct job link should also be included */
2494: /*l_child_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);
2495: if l_child_rg_name = 'CHILD_INFO_DGEN' THEN
2496: l_query := l_query || ' and object_type <> 5';
2497: end if;
2498: */

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

2500: l_query := 'SELECT object_id '
2501: ||' , object_type '
2502: ||' , object_id2 '
2503: ||' , object_type2 '
2504: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2505: ||' FROM mtl_object_genealogy '
2506: ||' WHERE parent_object_id = '||l_object_id
2507: ||' AND(end_date_active IS NULL '
2508: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

Line 2535: l_node_name := inv_object_genealogy.getobjectnumber

2531: Exit When l_child_query %NOTFOUND;
2532:
2533: debug(' drill down the tree, level '||l_level||' '||l_node_name||' Object_type '||l_object_type||' object_id '||l_object_id);
2534:
2535: l_node_name := inv_object_genealogy.getobjectnumber
2536: (l_object_id, l_object_type, l_object_id2, l_object_type2);
2537:
2538: write_group_begin('tree_node_level'||l_level);
2539: XML_write('level'||l_level, l_node_name);

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

2576: SELECT object_id
2577: , object_type
2578: , object_id2
2579: , object_type2
2580: , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)
2581: FROM mtl_object_genealogy
2582: WHERE parent_object_id = l_object_id
2583: ;
2584: Begin

Line 2586: l_node_name := inv_object_genealogy.getobjectnumber

2582: WHERE parent_object_id = l_object_id
2583: ;
2584: Begin
2585: debug(' Write children reports');
2586: l_node_name := inv_object_genealogy.getobjectnumber
2587: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2588: l_current_object_id := p_object_id;
2589: l_object_id := p_object_id;
2590: l_object_type := p_object_type;

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

2605: l_query := ' SELECT object_id '
2606: ||' , object_type'
2607: ||' , object_id2'
2608: ||' , object_type2'
2609: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2610: ||' FROM mtl_object_genealogy'
2611: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2612: ||' and decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2613: ||' AND parent_object_id = '||l_object_id

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

2614: --||' CONNECT BY PRIOR object_id = parent_object_id'
2615: --||' START WITH decode(parent_object_id2,null, -9999, parent_object_id2) = '||l_fake_object_id2
2616: --||' AND parent_object_id = '||l_object_id
2617: ;
2618: /*l_child_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);
2619: if l_child_rg_name = 'CHILD_INFO_DGEN' THEN
2620: l_query := l_query || ' and object_type <> 5';
2621: end if;
2622: */

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

2624: l_query := 'SELECT object_id '
2625: ||' , object_type '
2626: ||' , object_id2 '
2627: ||' , object_type2 '
2628: ||' , inv_object_genealogy.getobjectnumber(object_id, object_type, object_id2, object_type2)'
2629: ||' FROM mtl_object_genealogy '
2630: ||' WHERE parent_object_id = '||l_object_id
2631: ||' AND(end_date_active IS NULL '
2632: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

Line 2690: l_node_name := inv_object_genealogy.getobjectnumber

2686: l_rec_query rc;
2687:
2688: Begin
2689: debug('Get All Parents');
2690: l_node_name := inv_object_genealogy.getobjectnumber
2691: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2692: l_object_id := p_object_id;
2693: l_object_type := p_object_type;
2694:

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

2734: SELECT parent_object_id
2735: , parent_object_type
2736: , parent_object_id2
2737: , parent_object_type2
2738: , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)
2739: FROM mtl_object_genealogy
2740: WHERE object_id = l_parent_object_id
2741: ;
2742:

Line 2745: l_node_name := inv_object_genealogy.getobjectnumber

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

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

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

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

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

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

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

Line 2849: l_node_name := inv_object_genealogy.getobjectnumber

2845: l_parent_query rc;
2846:
2847: Begin
2848: debug(' Write Parents Reports');
2849: l_node_name := inv_object_genealogy.getobjectnumber
2850: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2851: l_current_object_id := p_object_id;
2852: l_object_id := p_object_id;
2853: l_object_type := p_object_type;

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

2868: l_query := ' SELECT parent_object_id '
2869: ||' , parent_object_type'
2870: ||' , parent_object_id2'
2871: ||' , parent_object_type2'
2872: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2873: ||' FROM mtl_object_genealogy'
2874: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2875: ||' and decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2876: ||' AND object_id = '||l_object_id

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

2877: --||' CONNECT BY object_id = PRIOR parent_object_id '
2878: --||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2879: --||' AND object_id = '||l_object_id
2880: ;
2881: /*l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_object_id);
2882: if l_parent_rg_name = 'CHILD_INFO_DGEN' THEN
2883: l_query := l_query || ' and parent_object_type <> 5';
2884: end if;
2885: */

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

2887: l_query := ' SELECT parent_object_id '
2888: ||' , parent_object_type '
2889: ||' , parent_object_id2 '
2890: ||' , parent_object_type2 '
2891: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2892: ||' FROM mtl_object_genealogy '
2893: ||' WHERE object_id = '||l_object_id
2894: ||' AND(end_date_active IS NULL '
2895: ||' OR TRUNC(end_date_active) >= TRUNC(SYSDATE)) '

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

2899: l_query := ' SELECT parent_object_id '
2900: ||' , parent_object_type'
2901: ||' , parent_object_id2'
2902: ||' , parent_object_type2'
2903: ||' , inv_object_genealogy.getobjectnumber(parent_object_id, parent_object_type, parent_object_id2, parent_object_type2)'
2904: ||' FROM mtl_object_genealogy'
2905: ||' WHERE (end_date_active IS NULL OR end_date_active >= SYSDATE)'
2906: ||' CONNECT BY object_id = PRIOR parent_object_id '
2907: ||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2

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

2906: ||' CONNECT BY object_id = PRIOR parent_object_id '
2907: ||' START WITH decode(object_id2,null, -9999, object_id2) = '||l_fake_object_id2
2908: ||' AND object_id = '||l_parent_object_id
2909: ;
2910: l_parent_rg_name := inv_object_genealogy.findchildrecordgroup(l_parent_object_id);
2911: if l_parent_rg_name = 'CHILD_INFO_DGEN' THEN
2912: l_query := l_query || ' and parent_object_type <> 5';
2913: end if;
2914: */

Line 2988: l_node_name := inv_object_genealogy.getobjectnumber

2984: Begin
2985: debug('Write the tree node, level '||p_level);
2986: if p_level = 0 then
2987: write_group_begin('tree_node_main_level');
2988: l_node_name := inv_object_genealogy.getobjectnumber
2989: (p_object_id, p_object_type, p_object_id2, p_object_type2);
2990: XML_write('main_level', l_node_name);
2991: else
2992: l_count := 0 ;

Line 2999: l_node_name := inv_object_genealogy.getobjectnumber

2995: exit when l_count = p_level;
2996: write_group_begin('tree_node_level'||l_count);
2997: end loop;
2998: */
2999: l_node_name := inv_object_genealogy.getobjectnumber
3000: (p_object_id, p_object_type, p_object_id2, p_object_type2);
3001: write_group_begin('tree_node_level'||p_level);
3002: XML_write('level'||p_level, l_node_name);
3003: end if;