DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on EAM_ASSET_RESULTS_GTT

Line 1865: INSERT INTO EAM_ASSET_RESULTS_GTT(gen_object_id)

1861: commit;
1862: for asset in asset_cur
1863: loop
1864: begin
1865: INSERT INTO EAM_ASSET_RESULTS_GTT(gen_object_id)
1866: VALUES (asset.gen_object_id);
1867: exception
1868:
1869: when DUP_VAL_ON_INDEX then

Line 1876: insert into EAM_ASSET_RESULTS_GTT (gen_object_id)

1872: RAISE;
1873: end;
1874:
1875: begin
1876: insert into EAM_ASSET_RESULTS_GTT (gen_object_id)
1877: (select object_id from mtl_object_genealogy
1878: where genealogy_type = 5
1879: and (sysdate between NVL(start_date_active,sysdate-1) and NVL(end_date_active,sysdate+1))
1880: start with parent_object_id = asset.gen_object_id