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 999: From mtl_object_genealogy

995: and inventory_item_id = p_lot_attributes_rec.inventory_item_id;
996:
997: /*Cursor get_orig_txn_id IS
998: Select origin_txn_id
999: From mtl_object_genealogy
1000: Where object_id = p_lot_attributes_rec.object_id;
1001: Cursor get_source_data IS
1002: Select transaction_source_name
1003: ,transaction_quantity

Line 2338: FROM mtl_object_genealogy

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

Line 2411: FROM mtl_object_genealogy

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

Line 2446: ||' FROM mtl_object_genealogy'

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

Line 2466: ||' FROM mtl_object_genealogy '

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

Line 2553: FROM mtl_object_genealogy

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
2557: Select 1

Line 2590: ||' FROM mtl_object_genealogy'

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

Line 2609: ||' FROM mtl_object_genealogy '

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

Line 2729: FROM mtl_object_genealogy

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
2733: Select 1

Line 2764: ||' FROM mtl_object_genealogy'

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

Line 2783: ||' FROM mtl_object_genealogy '

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

Line 2890: ||' FROM mtl_object_genealogy'

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

Line 2909: ||' FROM mtl_object_genealogy '

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

Line 2921: ||' FROM mtl_object_genealogy'

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