APPS.CST_EAMCOST_PUB dependencies on MTL_OBJECT_GENEALOGY

Line 5132: -- MTL_OBJECT_GENEALOGY

5128: FROM dual;
5129:
5130: ------------------------------------------------
5131: -- Take a snapshot of hierarchy structure from
5132: -- MTL_OBJECT_GENEALOGY
5133: -- and put it into CST_EAM_HIERARCHY_SNAPSHOT
5134: -- using l_gen_object_id and all it's child
5135: ------------------------------------------------
5136: l_statement := 50;

Line 5166: FROM mtl_object_genealogy

5162: 1,
5163: NULL,
5164: NULL,
5165: NULL
5166: FROM mtl_object_genealogy
5167: START WITH object_id = l_gen_object_id
5168: AND sysdate between start_date_active and nvl(end_date_active, sysdate)
5169: CONNECT BY parent_object_id = PRIOR object_id
5170: AND sysdate between start_date_active and nvl(end_date_active, sysdate);

Line 5215: FROM mtl_object_genealogy

5211: 1,
5212: NULL,
5213: NULL,
5214: NULL
5215: FROM mtl_object_genealogy
5216: START WITH parent_object_id = l_gen_object_id
5217: AND sysdate between start_date_active and nvl(end_date_active, sysdate)
5218: CONNECT BY parent_object_id = PRIOR object_id
5219: AND sysdate between start_date_active and nvl(end_date_active, sysdate);