APPS.CST_EAMCOST_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 5396: -- MTL_OBJECT_GENEALOGY

5392: END IF;
5393:
5394: ------------------------------------------------
5395: -- Take a snapshot of hierarchy structure from
5396: -- MTL_OBJECT_GENEALOGY
5397: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT
5398: -- using l_gen_object_id and all it's child
5399: ------------------------------------------------
5400:

Line 5436: FROM mtl_object_genealogy

5432: 1,
5433: NULL,
5434: NULL,
5435: NULL
5436: FROM mtl_object_genealogy
5437: START WITH object_id = l_gen_object_id */
5438: /* Bug 8792876 - AND sysdate between start_date_active and nvl(end_date_active, sysdate)*/
5439: /*AND (END_DATE_ACTIVE IS NULL OR END_DATE_ACTIVE >=
5440: NVL(l_period_start_date,END_DATE_ACTIVE)) AND

Line 5494: FROM mtl_object_genealogy

5490: 1,
5491: NULL,
5492: NULL,
5493: NULL
5494: FROM mtl_object_genealogy
5495: START WITH parent_object_id = l_gen_object_id
5496: /*Bug 15907393 - to avoid parent asset associated as original child asset's child asset*/
5497: AND object_id <> l_gen_object_id
5498: /* Bug 8792876 - AND sysdate between start_date_active and nvl(end_date_active, sysdate)*/