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: SELECT 1 FROM MTL_OBJECT_GENEALOGY

414: --bug 13866934
415: SELECT 1
416: FROM DUAL
417: WHERE EXISTS (
418: SELECT 1 FROM MTL_OBJECT_GENEALOGY
419: WHERE GENEALOGY_ORIGIN = 1 AND OBJECT_TYPE = 2 AND PARENT_OBJECT_TYPE = 5
420: AND ( END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE )
421: AND OBJECT_ID = nvl(p_object_id, p_object_id2)
422:

Line 426: FROM MTL_OBJECT_GENEALOGY MOG

422:
423: union ALL
424:
425: SELECT MOG.PARENT_OBJECT_ID
426: FROM MTL_OBJECT_GENEALOGY MOG
427: WHERE OBJECT_TYPE = 2 AND PARENT_OBJECT_TYPE = 2
428: AND OBJECT_ID = nvl(p_object_id, p_object_id2)
429: AND EXISTS (
430: SELECT 1 FROM MTL_OBJECT_GENEALOGY

Line 430: SELECT 1 FROM MTL_OBJECT_GENEALOGY

426: FROM MTL_OBJECT_GENEALOGY MOG
427: WHERE OBJECT_TYPE = 2 AND PARENT_OBJECT_TYPE = 2
428: AND OBJECT_ID = nvl(p_object_id, p_object_id2)
429: AND EXISTS (
430: SELECT 1 FROM MTL_OBJECT_GENEALOGY
431: WHERE GENEALOGY_ORIGIN = 1 AND OBJECT_TYPE = 2 AND PARENT_OBJECT_TYPE = 5
432: AND ( END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE )
433: AND OBJECT_ID = MOG.PARENT_OBJECT_ID )
434:

Line 438: FROM MTL_OBJECT_GENEALOGY MOG

434:
435: union ALL
436:
437: SELECT MOG.PARENT_OBJECT_ID
438: FROM MTL_OBJECT_GENEALOGY MOG
439: WHERE OBJECT_TYPE = 1 AND PARENT_OBJECT_TYPE = 5
440: AND OBJECT_ID = nvl(p_object_id, p_object_id2)
441: AND EXISTS (
442: SELECT 1 FROM MTL_OBJECT_GENEALOGY

Line 442: SELECT 1 FROM MTL_OBJECT_GENEALOGY

438: FROM MTL_OBJECT_GENEALOGY MOG
439: WHERE OBJECT_TYPE = 1 AND PARENT_OBJECT_TYPE = 5
440: AND OBJECT_ID = nvl(p_object_id, p_object_id2)
441: AND EXISTS (
442: SELECT 1 FROM MTL_OBJECT_GENEALOGY
443: WHERE GENEALOGY_ORIGIN = 1 AND OBJECT_TYPE = 2 AND PARENT_OBJECT_TYPE = 5
444: AND ( END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE )
445: AND PARENT_OBJECT_ID = MOG.PARENT_OBJECT_ID)
446:

Line 450: FROM MTL_OBJECT_GENEALOGY MOG

446:
447: union ALL
448:
449: SELECT MOG.OBJECT_ID
450: FROM MTL_OBJECT_GENEALOGY MOG
451: WHERE PARENT_OBJECT_TYPE = 1 AND OBJECT_TYPE = 5
452: AND PARENT_OBJECT_ID = nvl(p_object_id, p_object_id2)
453: AND EXISTS (
454: SELECT 1 FROM MTL_OBJECT_GENEALOGY

Line 454: SELECT 1 FROM MTL_OBJECT_GENEALOGY

450: FROM MTL_OBJECT_GENEALOGY MOG
451: WHERE PARENT_OBJECT_TYPE = 1 AND OBJECT_TYPE = 5
452: AND PARENT_OBJECT_ID = nvl(p_object_id, p_object_id2)
453: AND EXISTS (
454: SELECT 1 FROM MTL_OBJECT_GENEALOGY
455: WHERE GENEALOGY_ORIGIN = 1 AND OBJECT_TYPE = 2 AND PARENT_OBJECT_TYPE = 5
456: AND ( END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE > SYSDATE )
457: AND PARENT_OBJECT_ID = MOG.OBJECT_ID )
458:

Line 461: SELECT 1 FROM MTL_OBJECT_GENEALOGY MOG

457: AND PARENT_OBJECT_ID = MOG.OBJECT_ID )
458:
459: union ALL
460:
461: SELECT 1 FROM MTL_OBJECT_GENEALOGY MOG
462: WHERE PARENT_OBJECT_TYPE = 5 AND OBJECT_TYPE = 2 AND GENEALOGY_ORIGIN=1
463: AND PARENT_OBJECT_ID=p_object_id
464: ) ; --bug 13866934
465:

Line 471: FROM mtl_object_genealogy

467: SELECT 1 --when queried by asembly serial
468: FROM DUAL
469: WHERE EXISTS (
470: SELECT 1
471: FROM mtl_object_genealogy
472: WHERE genealogy_origin = 1
473: AND object_type = 2
474: AND parent_object_type = 5
475: AND (end_date_active IS NULL OR end_date_active > SYSDATE)

Line 483: FROM mtl_object_genealogy mog

479: SELECT 1
480: FROM DUAL
481: WHERE EXISTS (
482: SELECT mog.parent_object_id
483: FROM mtl_object_genealogy mog
484: WHERE object_type = 2
485: AND parent_object_type = 2
486: AND object_id =
487: NVL (p_object_id, p_object_id2)

Line 491: FROM mtl_object_genealogy

487: NVL (p_object_id, p_object_id2)
488: AND EXISTS (
489: SELECT 1
490: --if queried by comp serial then check if it's parent aser has job as parent
491: FROM mtl_object_genealogy
492: WHERE genealogy_origin = 1
493: AND object_type = 2
494: AND parent_object_type = 5
495: AND ( end_date_active IS NULL

Line 507: FROM mtl_object_genealogy mog

503: SELECT 1
504: FROM DUAL
505: WHERE EXISTS (
506: SELECT mog.parent_object_id
507: FROM mtl_object_genealogy mog
508: WHERE object_type = 1
509: AND parent_object_type = 5
510: AND object_id = NVL (p_object_id, p_object_id2)
511: AND EXISTS (

Line 513: FROM mtl_object_genealogy

509: AND parent_object_type = 5
510: AND object_id = NVL (p_object_id, p_object_id2)
511: AND EXISTS (
512: SELECT 1
513: FROM mtl_object_genealogy
514: WHERE genealogy_origin = 1
515: AND object_type = 2
516: AND parent_object_type = 5
517: AND ( end_date_active IS NULL

Line 528: FROM mtl_object_genealogy mog

524: SELECT 1
525: FROM DUAL
526: WHERE EXISTS (
527: SELECT mog.object_id
528: FROM mtl_object_genealogy mog
529: WHERE parent_object_type = 1
530: AND object_type = 5
531: AND parent_object_id = NVL (p_object_id, p_object_id2)
532: AND EXISTS (

Line 534: FROM mtl_object_genealogy

530: AND object_type = 5
531: AND parent_object_id = NVL (p_object_id, p_object_id2)
532: AND EXISTS (
533: SELECT 1
534: FROM mtl_object_genealogy
535: WHERE genealogy_origin = 1
536: AND object_type = 2
537: AND parent_object_type = 5
538: AND ( end_date_active IS NULL

Line 549: FROM mtl_object_genealogy mog

545: SELECT 1
546: FROM DUAL
547: WHERE EXISTS (
548: SELECT 1
549: FROM mtl_object_genealogy mog
550: WHERE parent_object_type = 5
551: AND object_type = 2
552: AND genealogy_origin=1
553: AND parent_object_id=p_object_id)) ;*/

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

711: INTO l_trx_src
712: FROM mtl_sales_orders_kfv
713: WHERE sales_order_id = p_trx_src_id;
714: /* Removed p_trx-src_type = 3 for 2 reasons. one, that is function is not
715: used at all. Second that mtl_object_genealogy table never has data from this
716: source. Bug 4237802 */
717: ELSIF p_trx_src_type = 4 THEN -- Move Orders
718: SELECT request_number
719: INTO l_trx_src

Line 870: FROM mtl_object_genealogy

866: , object_type
867: , NULL object_id2
868: , NULL object_type2
869: , NULL parent_object_id2
870: FROM mtl_object_genealogy
871: WHERE parent_object_id = p_object_id
872: AND object_type<>2
873: AND (end_date_active is null or end_date_active > SYSDATE);
874: --AND ((object_type = 2 AND parent_object_type = object_type) OR (object_type <> 2))

Line 885: FROM mtl_object_genealogy

881: , object_type
882: , object_id2
883: , object_type2
884: , parent_object_id2
885: FROM mtl_object_genealogy
886: WHERE parent_object_id = p_object_id
887: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
888: AND (end_date_active IS NULL OR end_date_active > SYSDATE);
889: /*

Line 890: Added the below cursor to get the data form mtl_object_genealogy table in decending order.

886: WHERE parent_object_id = p_object_id
887: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
888: AND (end_date_active IS NULL OR end_date_active > SYSDATE);
889: /*
890: Added the below cursor to get the data form mtl_object_genealogy table in decending order.
891: this cursor is created as part of the bug 16512538
892: */
893: CURSOR child_cur3 IS
894: SELECT object_id

Line 900: FROM mtl_object_genealogy

896: , object_type
897: , object_id2
898: , object_type2
899: , parent_object_id2
900: FROM mtl_object_genealogy
901: WHERE parent_object_id = p_object_id
902: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
903: And (End_Date_Active Is Null Or End_Date_Active > Sysdate)
904: order by creation_date desc;

Line 907: Added the below cursor to get the data form mtl_object_genealogy table in decending order.

903: And (End_Date_Active Is Null Or End_Date_Active > Sysdate)
904: order by creation_date desc;
905:
906: /*
907: Added the below cursor to get the data form mtl_object_genealogy table in decending order.
908: this cursor is created as part of the bug 16512538
909: */
910:
911: CURSOR child_cur4 IS

Line 918: FROM mtl_object_genealogy

914: , object_type
915: , object_id2
916: , object_type2
917: , parent_object_id2
918: FROM mtl_object_genealogy
919: WHERE parent_object_id = p_object_id
920: AND (p_object_id2 IS NULL OR parent_object_id2 = p_object_id2)
921: And (End_Date_Active Is Null Or End_Date_Active > Sysdate)
922: order by creation_date asc;

Line 1217: FROM mtl_object_genealogy mog

1213: , mog.object_type
1214: , NULL object_id2
1215: , NULL object_type2
1216: , NULL parent_object_id2
1217: FROM mtl_object_genealogy mog
1218: -- WHERE object_type<>2--((object_type = 2 AND parent_object_type = object_type) OR (object_type <> 2))
1219: -- AND (end_date_active is null or end_date_active > SYSDATE)
1220: START WITH (parent_object_id=p_object_id and (end_date_active is null or end_date_active > SYSDATE))
1221: CONNECT BY nocycle prior object_id = parent_object_id --12701288

Line 1236: FROM mtl_object_genealogy

1232: , object_type
1233: , object_id2
1234: , object_type2
1235: , parent_object_id2
1236: FROM mtl_object_genealogy
1237: -- WHERE end_date_active IS NULL
1238: -- OR end_date_active > SYSDATE
1239: START WITH (parent_object_id=p_object_id AND (end_date_active IS NULL OR end_date_active > SYSDATE))
1240: CONNECT BY nocycle PRIOR object_id = parent_object_id --12701288

Line 1350: FROM mtl_object_genealogy

1346:
1347: LOOP
1348: SELECT Count(*)
1349: INTO n_rows
1350: FROM mtl_object_genealogy
1351: --WHERE level < n_level
1352: START WITH (parent_object_id=p_object_id AND (end_date_active IS NULL OR end_date_active > SYSDATE))
1353: CONNECT BY nocycle PRIOR object_id = parent_object_id --12701288
1354: AND (end_date_active IS NULL OR end_date_active > SYSDATE)

Line 1443: FROM mtl_object_genealogy

1439: , object_id
1440: , parent_object_type
1441: , parent_object_id2
1442: , parent_object_type2, object_id2,object_type2,object_type
1443: FROM mtl_object_genealogy
1444: WHERE object_id = p_object_id
1445: AND (p_object_id2 IS NULL OR object_id2 = p_object_id2)
1446: AND(end_date_active IS NULL
1447: OR end_date_active > SYSDATE);

Line 1703: FROM mtl_object_genealogy mog

1699: , mog.object_id
1700: , mog.parent_object_type
1701: , mog.parent_object_id2
1702: , mog.parent_object_type2
1703: FROM mtl_object_genealogy mog
1704: -- WHERE end_date_active IS NULL
1705: -- OR end_date_active > SYSDATE
1706: START WITH (object_id = p_object_id AND (end_date_active IS NULL OR end_date_active > SYSDATE))
1707: CONNECT BY nocycle PRIOR parent_object_id = object_id --12701288

Line 1764: FROM mtl_object_genealogy

1760:
1761: LOOP
1762: SELECT Count(*)
1763: INTO n_rows
1764: FROM mtl_object_genealogy
1765: --WHERE level < n_level
1766: START WITH (object_id=p_object_id AND (end_date_active IS NULL OR end_date_active > SYSDATE))
1767: CONNECT BY nocycle PRIOR parent_object_id = object_id --12701288
1768: AND (end_date_active IS NULL OR end_date_active > SYSDATE)