eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SC_DENORM dependencies on AS_SALES_CREDITS_DENORM

Line 12: -- AS_SALES_CREDITS_DENORM

8: -- Change to add a new concurrent program
9: -- to refresh as_period_days table
10: -- 12/22/2000 SOLIN Bug 1549115
11: -- Add a new column BUSINESS_GROUP_NAME in
12: -- AS_SALES_CREDITS_DENORM
13: -- 12/26/2000 SOLIN Change to have debug message for concurrent
14: -- program and trigger
15: -- 01/29/2001 SOLIN Change to have dbms_stats.gather_table_stats
16: -- for tables AS_SALES_CREDITS_DENORM and

Line 16: -- for tables AS_SALES_CREDITS_DENORM and

12: -- AS_SALES_CREDITS_DENORM
13: -- 12/26/2000 SOLIN Change to have debug message for concurrent
14: -- program and trigger
15: -- 01/29/2001 SOLIN Change to have dbms_stats.gather_table_stats
16: -- for tables AS_SALES_CREDITS_DENORM and
17: -- AS_MC_SALES_CREDITS_DEN in concurrent program.
18: -- 02/21/2001 SOLIN Bug 1654262.
19: -- Change to use daily rate for period rate
20: -- in case user doesn't set up any daily rate for

Line 165: WHERE (log_owner = l_oracle_schema and master in ('AS_PERIOD_DAYS','AS_SALES_CREDITS_DENORM','AS_MC_SALES_CREDITS_DEN'))

161:
162: cursor dr_obj is
163: SELECT 'drop materialized view log on '||log_owner||'.'||master sqlstmt
164: FROM all_snapshot_logs
165: WHERE (log_owner = l_oracle_schema and master in ('AS_PERIOD_DAYS','AS_SALES_CREDITS_DENORM','AS_MC_SALES_CREDITS_DEN'))
166: --or (log_owner = 'JTF' and master in ('JTF_RS_REP_MANAGERS','JTF_RS_GROUP_USAGES'))
167: or (log_owner = l_apps_schema and master in ('ASF_SC_BIN_MV','ASF_SCBINLD_MV'))
168: UNION ALL
169: SELECT 'drop materialized view '||owner||'.'||name

Line 209: INSERT /+ APPEND PARALLEL(SCD) / into as_sales_credits_denorm SCD

205:
206: BEGIN
207: RETCODE := 0;
208: --Hint added for performance bug#5802537
209: INSERT /*+ APPEND PARALLEL(SCD) */ into as_sales_credits_denorm SCD
210: (sales_credit_id,
211: last_update_date,
212: last_updated_by,
213: creation_date,

Line 517: UPDATE AS_SALES_CREDITS_DENORM

513: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Bulk_update_sc_Denorm';
514:
515: BEGIN
516: ForALL J in 1 .. p_last
517: UPDATE AS_SALES_CREDITS_DENORM
518: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
519: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
520: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
521: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),

Line 590: FROM as_sales_credits_denorm scdh,

586: aslkp.meaning close_reason_meaning,
587: jrs0.source_name lupd_name,
588: jrs1.source_name created_name,
589: org.name bg_name
590: FROM as_sales_credits_denorm scdh,
591: as_sales_stages_all_tl sales,
592: jtf_rs_resource_extns jrs,
593: jtf_rs_groups_tl sg,
594: jtf_rs_groups_tl sg2,

Line 714: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);

710: END;
711: END LOOP;
712:
713: COMMIT;
714: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);
715: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
716: EXCEPTION
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);

Line 715: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);

711: END LOOP;
712:
713: COMMIT;
714: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);
715: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
716: EXCEPTION
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);
719: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 770: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM';

766: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'PERIOD_TYPE used: '||G_PERIOD_TYPE);
767: --Code commented as per suggestion given in bug#5802537 by Lester
768: --Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'DEGREE OF PARALLELISM used: '||as_utility_pvt.get_degree_parallelism);
769: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
770: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM';
771: clear_snapshots;
772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
774: IF (RETCODE = 0) THEN

Line 773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);

769: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
770: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM';
771: clear_snapshots;
772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
774: IF (RETCODE = 0) THEN
775: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
777: COMMIT;

Line 775: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');

771: clear_snapshots;
772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
774: IF (RETCODE = 0) THEN
775: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
777: COMMIT;
778: END IF;
779: IF (RETCODE = 0) THEN

Line 776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);

772: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
773: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
774: IF (RETCODE = 0) THEN
775: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
776: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
777: COMMIT;
778: END IF;
779: IF (RETCODE = 0) THEN
780: insert_scd (ERRBUF, RETCODE, l_scd_cnt);

Line 784: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');

780: insert_scd (ERRBUF, RETCODE, l_scd_cnt);
781: COMMIT;
782: END IF;
783: IF (RETCODE = 0) THEN
784: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
785: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
786: COMMIT;
787: END IF;
788: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);

Line 785: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);

781: COMMIT;
782: END IF;
783: IF (RETCODE = 0) THEN
784: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
785: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
786: COMMIT;
787: END IF;
788: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);
789: ELSIF (p_mode = 2) THEN

Line 788: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);

784: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
785: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
786: COMMIT;
787: END IF;
788: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);
789: ELSIF (p_mode = 2) THEN
790: Refresh_SC_Denorm(ERRBUF, RETCODE);
791: END IF;
792: