APPS.INV_OBJECT_GENEALOGY dependencies on DUAL

Line 415: FROM DUAL

411: )
412: RETURN NUMBER IS
413: CURSOR jRecord IS
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

Line 427: FROM DUAL

423: AND (object_id = NVL (p_object_id, p_object_id2))
424: OR --when quereid by component serial
425: EXISTS (
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

Line 451: FROM DUAL

447: OR
448: -- if queried by component lot, then check if it's parent has aser as child
449: EXISTS (
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

Line 472: FROM DUAL

468: OR
469: --if queried by assembly lot of lot serial, then check if it's parent has aser as child
470: EXISTS (
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

Line 493: FROM DUAL

489: OR
490: --if queried by job and if it has aser as child
491: EXISTS (
492: SELECT 1
493: FROM DUAL
494: WHERE EXISTS (
495: SELECT 1
496: FROM mtl_object_genealogy mog
497: WHERE parent_object_type = 5