DBA Data[Home] [Help]

APPS.AMS_DMEXTRACT_PVT dependencies on AMS_DM_SOURCE

Line 214: FROM ams_dm_source ads

210: --INTO ams_dm_drv_stg (
211: INSERT -- /*+ APPEND PARALLEL(AMS_DM_DRV_STG_GT,DEFAULT,DEFAULT)*/
212: INTO ams_dm_drv_stg_gt (party_id)
213: SELECT ads.party_id party_id
214: FROM ams_dm_source ads
215: WHERE ads.used_for_object_id = p_object_id
216: AND ads.arc_used_for_object = p_object_type
217: AND NOT EXISTS (
218: SELECT pdt.party_id party_id

Line 4274: tabname => 'AMS_DM_SOURCE',

4270: );
4271:
4272: DBMS_STATS.gather_table_stats (
4273: ownname => l_ams_schema,
4274: tabname => 'AMS_DM_SOURCE',
4275: estimate_percent => 99,
4276: cascade => TRUE
4277: );
4278: END analyze_mining_tables;