APPS.AS_ATA_TOTAL_PUB dependencies on AS_TERR_RESOURCES_TMP

Line 101: --fix for bug(5869095) --populating as_terr_resources_tmp table

97: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_CALL_TO || G_PR_ACCOUNT, l_errbuf, l_retcode);
98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: End If;
100:
101: --fix for bug(5869095) --populating as_terr_resources_tmp table
102:
103: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
104:
105: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */

Line 103: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';

99: End If;
100:
101: --fix for bug(5869095) --populating as_terr_resources_tmp table
102:
103: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
104:
105: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
106: INTO AS_TERR_RESOURCES_TMP
107: (RESOURCE_ID,

Line 105: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */

101: --fix for bug(5869095) --populating as_terr_resources_tmp table
102:
103: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
104:
105: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
106: INTO AS_TERR_RESOURCES_TMP
107: (RESOURCE_ID,
108: RESOURCE_TYPE,
109: PARTY_ID,

Line 106: INTO AS_TERR_RESOURCES_TMP

102:
103: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_TERR_RESOURCES_TMP REUSE STORAGE';
104:
105: INSERT /*+ append parallel(AS_TERR_RESOURCES_TMP) */
106: INTO AS_TERR_RESOURCES_TMP
107: (RESOURCE_ID,
108: RESOURCE_TYPE,
109: PARTY_ID,
110: TERR_ID)

Line 128: dbms_stats.gather_table_stats('OSM','AS_TERR_RESOURCES_TMP',

124: );
125:
126: COMMIT;
127:
128: dbms_stats.gather_table_stats('OSM','AS_TERR_RESOURCES_TMP',
129: estimate_percent=>10, degree=>8, granularity=>'GLOBAL', cascade=>TRUE) ;
130: COMMIT;
131:
132: --fix for bug(5869095) --populating as_terr_resources_tmp table

Line 132: --fix for bug(5869095) --populating as_terr_resources_tmp table

128: dbms_stats.gather_table_stats('OSM','AS_TERR_RESOURCES_TMP',
129: estimate_percent=>10, degree=>8, granularity=>'GLOBAL', cascade=>TRUE) ;
130: COMMIT;
131:
132: --fix for bug(5869095) --populating as_terr_resources_tmp table
133:
134: END IF;
135: AS_GAR.LOG(G_ENTITY || G_PR_ACCOUNT || AS_GAR.G_END);
136: EXCEPTION