APPS.INV_OBJECT_GENEALOGY dependencies on DUAL

Line 416: FROM DUAL

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

Line 468: FROM DUAL

464: ) ; --bug 13866934
465:
466: /* Bug 13866934 commenting the cusror for adding the new one
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

Line 480: FROM DUAL

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

Line 504: FROM DUAL

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

Line 525: FROM DUAL

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

Line 546: FROM DUAL

542: OR
543: --if queried by job and if it has aser as child
544: EXISTS (
545: SELECT 1
546: FROM DUAL
547: WHERE EXISTS (
548: SELECT 1
549: FROM mtl_object_genealogy mog
550: WHERE parent_object_type = 5