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_OBJECT_GENEALOGY dependencies on MTL_OBJECT_GENEALOGY

Line 418: FROM mtl_object_genealogy

414: SELECT 1 --when queried by asembly serial
415: FROM DUAL
416: WHERE EXISTS (
417: SELECT 1
418: FROM mtl_object_genealogy
419: WHERE genealogy_origin = 1
420: AND object_type = 2
421: AND parent_object_type = 5
422: AND (end_date_active IS NULL OR end_date_active > SYSDATE)

Line 430: FROM mtl_object_genealogy mog

426: SELECT 1
427: FROM DUAL
428: WHERE EXISTS (
429: SELECT mog.parent_object_id
430: FROM mtl_object_genealogy mog
431: WHERE object_type = 2
432: AND parent_object_type = 2
433: AND object_id =
434: NVL (p_object_id, p_object_id2)

Line 438: FROM mtl_object_genealogy

434: NVL (p_object_id, p_object_id2)
435: AND EXISTS (
436: SELECT 1
437: --if queried by comp serial then check if it's parent aser has job as parent
438: FROM mtl_object_genealogy
439: WHERE genealogy_origin = 1
440: AND object_type = 2
441: AND parent_object_type = 5
442: AND ( end_date_active IS NULL

Line 454: FROM mtl_object_genealogy mog

450: SELECT 1
451: FROM DUAL
452: WHERE EXISTS (
453: SELECT mog.parent_object_id
454: FROM mtl_object_genealogy mog
455: WHERE object_type = 1
456: AND parent_object_type = 5
457: AND object_id = NVL (p_object_id, p_object_id2)
458: AND EXISTS (

Line 460: FROM mtl_object_genealogy

456: AND parent_object_type = 5
457: AND object_id = NVL (p_object_id, p_object_id2)
458: AND EXISTS (
459: SELECT 1
460: FROM mtl_object_genealogy
461: WHERE genealogy_origin = 1
462: AND object_type = 2
463: AND parent_object_type = 5
464: AND ( end_date_active IS NULL

Line 475: FROM mtl_object_genealogy mog

471: SELECT 1
472: FROM DUAL
473: WHERE EXISTS (
474: SELECT mog.object_id
475: FROM mtl_object_genealogy mog
476: WHERE parent_object_type = 1
477: AND object_type = 5
478: AND parent_object_id = NVL (p_object_id, p_object_id2)
479: AND EXISTS (

Line 481: FROM mtl_object_genealogy

477: AND object_type = 5
478: AND parent_object_id = NVL (p_object_id, p_object_id2)
479: AND EXISTS (
480: SELECT 1
481: FROM mtl_object_genealogy
482: WHERE genealogy_origin = 1
483: AND object_type = 2
484: AND parent_object_type = 5
485: AND ( end_date_active IS NULL

Line 496: FROM mtl_object_genealogy mog

492: SELECT 1
493: FROM DUAL
494: WHERE EXISTS (
495: SELECT 1
496: FROM mtl_object_genealogy mog
497: WHERE parent_object_type = 5
498: AND object_type = 2
499: AND genealogy_origin=1
500: AND parent_object_id=p_object_id)) ;

Line 661: used at all. Second that mtl_object_genealogy table never has data from this

657: INTO l_trx_src
658: FROM mtl_sales_orders_kfv
659: WHERE sales_order_id = p_trx_src_id;
660: /* Removed p_trx-src_type = 3 for 2 reasons. one, that is function is not
661: used at all. Second that mtl_object_genealogy table never has data from this
662: source. Bug 4237802 */
663: ELSIF p_trx_src_type = 4 THEN -- Move Orders
664: SELECT request_number
665: INTO l_trx_src

Line 815: FROM mtl_object_genealogy

811: , object_type
812: , NULL object_id2
813: , NULL object_type2
814: , NULL parent_object_id2
815: FROM mtl_object_genealogy
816: WHERE parent_object_id = p_object_id
817: AND object_type<>2
818: AND (end_date_active is null or end_date_active > SYSDATE);
819: --AND ((object_type = 2 AND parent_object_type = object_type) OR (object_type <> 2))

Line 830: FROM mtl_object_genealogy

826: , object_type
827: , object_id2
828: , object_type2
829: , parent_object_id2
830: FROM mtl_object_genealogy
831: WHERE parent_object_id = p_object_id
832: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
833: AND (end_date_active IS NULL OR end_date_active > SYSDATE);
834:

Line 1094: FROM mtl_object_genealogy mog

1090: , mog.object_type
1091: , NULL object_id2
1092: , NULL object_type2
1093: , NULL parent_object_id2
1094: FROM mtl_object_genealogy mog
1095: -- WHERE object_type<>2--((object_type = 2 AND parent_object_type = object_type) OR (object_type <> 2))
1096: -- AND (end_date_active is null or end_date_active > SYSDATE)
1097: START WITH (parent_object_id=p_object_id and (end_date_active is null or end_date_active > SYSDATE))
1098: CONNECT BY prior object_id = parent_object_id

Line 1112: FROM mtl_object_genealogy

1108: , object_type
1109: , object_id2
1110: , object_type2
1111: , parent_object_id2
1112: FROM mtl_object_genealogy
1113: -- WHERE end_date_active IS NULL
1114: -- OR end_date_active > SYSDATE
1115: START WITH (parent_object_id=p_object_id and (end_date_active is null or end_date_active > SYSDATE))
1116: CONNECT BY PRIOR object_id = parent_object_id

Line 1275: FROM mtl_object_genealogy

1271: , object_id
1272: , parent_object_type
1273: , parent_object_id2
1274: , parent_object_type2, object_id2,object_type2,object_type
1275: FROM mtl_object_genealogy
1276: WHERE object_id = p_object_id
1277: AND (p_object_id2 IS NULL OR object_id2 = p_object_id2)
1278: AND(end_date_active IS NULL
1279: OR end_date_active > SYSDATE);

Line 1532: FROM mtl_object_genealogy mog

1528: , mog.object_id
1529: , mog.parent_object_type
1530: , mog.parent_object_id2
1531: , mog.parent_object_type2
1532: FROM mtl_object_genealogy mog
1533: -- WHERE end_date_active IS NULL
1534: -- OR end_date_active > SYSDATE
1535: START WITH (object_id = p_object_id and (end_date_active is null or end_date_active > SYSDATE))
1536: CONNECT BY PRIOR parent_object_id = object_id