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 MTL_OBJECT_GENEALOGY

Line 1003: From mtl_object_genealogy

999: and inventory_item_id = p_lot_attributes_rec.inventory_item_id;
1000:
1001: /*Cursor get_orig_txn_id IS
1002: Select origin_txn_id
1003: From mtl_object_genealogy
1004: Where object_id = p_lot_attributes_rec.object_id;
1005: Cursor get_source_data IS
1006: Select transaction_source_name
1007: ,transaction_quantity

Line 2385: FROM mtl_object_genealogy

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:
2389: Begin

Line 2457: FROM mtl_object_genealogy

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)
2461: AND parent_object_id = l_object_id

Line 2485: ||' FROM mtl_object_genealogy'

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
2489: --||' CONNECT BY PRIOR object_id = parent_object_id'

Line 2505: ||' FROM mtl_object_genealogy '

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)) '
2509: ;

Line 2581: FROM mtl_object_genealogy

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
2585: debug(' Write children reports');

Line 2610: ||' FROM mtl_object_genealogy'

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
2614: --||' CONNECT BY PRIOR object_id = parent_object_id'

Line 2629: ||' FROM mtl_object_genealogy '

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)) '
2633: ;

Line 2739: FROM mtl_object_genealogy

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:
2743: Begin

Line 2766: ||' FROM mtl_object_genealogy'

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
2770: --||' CONNECT BY object_id = PRIOR parent_object_id '

Line 2785: ||' FROM mtl_object_genealogy '

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)) '
2789: ;

Line 2873: ||' FROM mtl_object_genealogy'

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
2877: --||' CONNECT BY object_id = PRIOR parent_object_id '

Line 2892: ||' FROM mtl_object_genealogy '

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)) '
2896: ;

Line 2904: ||' FROM mtl_object_genealogy'

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
2908: ||' AND object_id = '||l_parent_object_id