DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on EAM_ASSET_RESULTS_GTT

Line 1892: INSERT INTO EAM_ASSET_RESULTS_GTT(gen_object_id)

1888: commit;
1889: for asset in asset_cur
1890: loop
1891: begin
1892: INSERT INTO EAM_ASSET_RESULTS_GTT(gen_object_id)
1893: VALUES (asset.gen_object_id);
1894: exception
1895:
1896: when DUP_VAL_ON_INDEX then

Line 1903: insert into EAM_ASSET_RESULTS_GTT (gen_object_id)

1899: RAISE;
1900: end;
1901:
1902: begin
1903: insert into EAM_ASSET_RESULTS_GTT (gen_object_id)
1904: (select object_id from mtl_object_genealogy
1905: where genealogy_type = 5
1906: and (sysdate between NVL(start_date_active,sysdate-1) and NVL(end_date_active,sysdate+1))
1907: start with parent_object_id = asset.gen_object_id