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

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 /+ PARALLEL(SCD, as_utility_pvt.get_degree_parallelism) APPEND / into as_sales_credits_denorm SCD

205:
206: BEGIN
207: RETCODE := 0;
208: --Code modified for bug12771336
209: INSERT /*+ PARALLEL(SCD, as_utility_pvt.get_degree_parallelism) APPEND */ into as_sales_credits_denorm SCD
210: (sales_credit_id,
211: last_update_date,
212: last_updated_by,
213: creation_date,

Line 453: as_sales_credits sc,

449: hz_parties cust,
450: hz_parties cmptr,
451: as_lead_lines_all ll,
452: as_leads_all lead,
453: as_sales_credits sc,
454: ar_lookups arlkp1, as_lookups aslkp,
455: mtl_system_items_tl mtlsitl,
456: mtl_units_of_measure_tl mtluom,
457: aso_i_sales_credit_types_v ctypes,

Line 625: as_sales_credits sc,

621: hz_parties cust,
622: hz_parties cmptr,
623: as_lead_lines_all ll,
624: as_leads_all lead,
625: as_sales_credits sc,
626: ar_lookups arlkp1, as_lookups aslkp,
627: mtl_system_items_tl mtlsitl,
628: mtl_units_of_measure_tl mtluom,
629: aso_i_sales_credit_types_v ctypes,

Line 681: UPDATE AS_SALES_CREDITS_DENORM

677: l_module CONSTANT VARCHAR2(255) := 'as.plsql.scden.Bulk_update_sc_Denorm';
678:
679: BEGIN
680: ForALL J in 1 .. p_last
681: UPDATE AS_SALES_CREDITS_DENORM
682: SET object_version_number = nvl(object_version_number,0) + 1, LAST_UPDATE_DATE = SYSDATE,
683: LAST_UPDATED_BY = nvl(FND_GLOBAL.User_Id,-1),
684: LAST_UPDATE_LOGIN = nvl(FND_GLOBAL.Login_id,-1),
685: REQUEST_ID = nvl(FND_GLOBAL.Conc_Request_Id,-1),

Line 754: FROM as_sales_credits_denorm scdh,

750: aslkp.meaning close_reason_meaning,
751: jrs0.source_name lupd_name,
752: jrs1.source_name created_name,
753: org.name bg_name
754: FROM as_sales_credits_denorm scdh,
755: as_sales_stages_all_tl sales,
756: jtf_rs_resource_extns jrs,
757: jtf_rs_groups_tl sg,
758: jtf_rs_groups_tl sg2,

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

874: END;
875: END LOOP;
876:
877: COMMIT;
878: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);
879: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
880: EXCEPTION
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);

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

875: END LOOP;
876:
877: COMMIT;
878: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows processed in AS_SALES_CREDITS_DENORM: '||l_row_count);
879: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Number of rows updated in AS_SALES_CREDITS_DENORM: ' || l_row_updated);
880: EXCEPTION
881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
882: ERRBUF := ERRBUF||'Error in Refresh_SC_Denorm: '||to_char(sqlcode);
883: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 934: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM REUSE STORAGE';

930: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'PERIOD_TYPE used: '||G_PERIOD_TYPE);
931:
932: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'DEGREE OF PARALLELISM used: '||as_utility_pvt.get_degree_parallelism);
933: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
934: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM REUSE STORAGE';
935: clear_snapshots;
936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
937: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
938: IF (RETCODE = 0) THEN

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

933: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
934: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_oracle_schema || '.AS_SALES_CREDITS_DENORM REUSE STORAGE';
935: clear_snapshots;
936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
937: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
938: IF (RETCODE = 0) THEN
939: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
940: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
941: COMMIT;

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

935: clear_snapshots;
936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
937: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
938: IF (RETCODE = 0) THEN
939: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
940: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
941: COMMIT;
942: END IF;
943: IF (RETCODE = 0) THEN

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

936: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Capturing Index Definitions');
937: as_utility_pvt.capture_index_definitions(ERRBUF,RETCODE,'AS_SALES_CREDITS_DENORM',l_oracle_schema);
938: IF (RETCODE = 0) THEN
939: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Droping indexes on AS_SALES_CREDITS_DENORM');
940: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'DROP','AS_SALES_CREDITS_DENORM',l_oracle_schema);
941: COMMIT;
942: END IF;
943: IF (RETCODE = 0) THEN
944: insert_scd (ERRBUF, RETCODE, l_scd_cnt);

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

944: insert_scd (ERRBUF, RETCODE, l_scd_cnt);
945: COMMIT;
946: END IF;
947: IF (RETCODE = 0) THEN
948: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
949: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
950: COMMIT;
951: END IF;
952: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);

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

945: COMMIT;
946: END IF;
947: IF (RETCODE = 0) THEN
948: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
949: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
950: COMMIT;
951: END IF;
952: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);
953: ELSIF (p_mode = 2) THEN

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

948: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Building indexes on AS_SALES_CREDITS_DENORM');
949: as_utility_pvt.execute_ind(ERRBUF,RETCODE,'BUILD','AS_SALES_CREDITS_DENORM',l_oracle_schema);
950: COMMIT;
951: END IF;
952: Write_Log(l_module, G_DEBUG_CONCURRENT, 1, 'Total records inserted into AS_SALES_CREDITS_DENORMS = ' || l_scd_cnt);
953: ELSIF (p_mode = 2) THEN
954: Refresh_SC_Denorm(ERRBUF, RETCODE);
955: END IF;
956: