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.BIM_MARKET_FACTS_PKG dependencies on BIM_I_MKT_RATES

Line 40: FROM BIM_I_MKT_RATES

36: CURSOR C_missing_rates1
37: IS
38: SELECT tc_code from_currency,
39: decode(prim_conversion_rate,-3,to_date('01/01/1999','MM/DD/RRRR'),trx_date) transaction_create_date
40: FROM BIM_I_MKT_RATES
41: WHERE prim_conversion_rate < 0
42: AND tc_code is not null
43: AND trx_date >= p_start_date
44: ORDER BY tc_code,

Line 51: FROM BIM_I_MKT_RATES

47: CURSOR C_missing_rates2
48: IS
49: SELECT tc_code from_currency,
50: decode(sec_conversion_rate,-3,to_date('01/01/1999','MM/DD/RRRR'),trx_date) transaction_create_date
51: FROM BIM_I_MKT_RATES
52: WHERE sec_conversion_rate < 0
53: AND tc_code is not null
54: AND trx_date >= p_start_date
55: ORDER BY tc_code,

Line 59: SELECT COUNT(*) INTO l_cnt_miss_rate1 FROM BIM_I_MKT_RATES

55: ORDER BY tc_code,
56: trx_date ;
57: BEGIN
58: l_msg_name := 'BIS_DBI_CURR_NO_LOAD';
59: SELECT COUNT(*) INTO l_cnt_miss_rate1 FROM BIM_I_MKT_RATES
60: WHERE
61: prim_conversion_rate < 0
62: AND tc_code is not null
63: AND trx_date >= p_start_date;

Line 65: SELECT COUNT(*) INTO l_cnt_miss_rate2 FROM BIM_I_MKT_RATES

61: prim_conversion_rate < 0
62: AND tc_code is not null
63: AND trx_date >= p_start_date;
64:
65: SELECT COUNT(*) INTO l_cnt_miss_rate2 FROM BIM_I_MKT_RATES
66: WHERE
67: sec_conversion_rate <0
68: AND tc_code is not null
69: AND trx_date >= p_start_date;

Line 425: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';

421: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: error:'||sqlerrm(sqlcode));
422: --dbms_output.put_line('error first:'||sqlerrm(sqlcode));
423: END;
424: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
425: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
426: l_table_name :='bim_i_marketing_facts';
427: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting table bim_i_marketing_facts_stg');
428: /*fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
429: fnd_message.set_token('TABLE_NAME',l_table_name, FALSE);

Line 2813: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Insert into bim_i_mkt_rates.');

2809: and s.child_object_type = f.child_object_type (+)
2810: and f.child_object_id is null;
2811: commit;
2812:
2813: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Insert into bim_i_mkt_rates.');
2814: --Insert rates_temp table
2815: INSERT /*+ append parallel */
2816: INTO BIM_I_MKT_RATES MRT(tc_code,
2817: trx_date,

Line 2816: INTO BIM_I_MKT_RATES MRT(tc_code,

2812:
2813: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Insert into bim_i_mkt_rates.');
2814: --Insert rates_temp table
2815: INSERT /*+ append parallel */
2816: INTO BIM_I_MKT_RATES MRT(tc_code,
2817: trx_date,
2818: prim_conversion_rate,
2819: sec_conversion_rate)
2820: SELECT from_currency,

Line 2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');

2824: FROM (select distinct from_currency from_currency,
2825: transaction_create_date transaction_create_date
2826: from bim_i_marketing_facts_stg);
2827: commit;
2828: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:After Insert into bim_i_mkt_rates.');
2829: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2830: if (l_check_missing_rate = -1) then
2831: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
2832: l_stmt := 'TRUNCATE table '||L_SCHEMA||'.BIM_I_MARKETING_FACTS_STG';

Line 2966: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt

2962: ,BUDGET_APPROVED*sec_conversion_rate
2963: ,CONVERSION_RATE_S
2964: ,metric1*rt.prim_conversion_rate
2965: ,metric1*sec_conversion_rate
2966: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt
2967: where a.from_currency = rt.tc_code(+)
2968: and a.transaction_create_date= rt.trx_date(+);
2969: commit;
2970:

Line 3136: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';

3132: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS: Error in first insert:'||sqlerrm(sqlcode));
3133: --dbms_output.put_line('error inserting:'||sqlerrm(sqlcode));
3134: END;
3135: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MARKETING_FACTS_STG';
3136: EXECUTE IMMEDIATE 'TRUNCATE table '||l_schema||'.BIM_I_MKT_RATES';
3137:
3138: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:First insert BIM_I_MARKETING_FACTS_STG');
3139: --BEGIN
3140: --dbms_output.put_line('right b4 inserting'||sqlerrm(sqlcode));

Line 5347: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting into BIM_I_MKT_RATES');

5343: and a.object_id = b.object_id
5344: AND a.object_type NOT IN ('RCAM')
5345: and a.object_type = b.object_type);
5346:
5347: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting into BIM_I_MKT_RATES');
5348: --insert into bim_i_mkt_rates
5349: INSERT
5350: INTO BIM_I_MKT_RATES MRT(tc_code,
5351: trx_date,

Line 5348: --insert into bim_i_mkt_rates

5344: AND a.object_type NOT IN ('RCAM')
5345: and a.object_type = b.object_type);
5346:
5347: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting into BIM_I_MKT_RATES');
5348: --insert into bim_i_mkt_rates
5349: INSERT
5350: INTO BIM_I_MKT_RATES MRT(tc_code,
5351: trx_date,
5352: prim_conversion_rate,

Line 5350: INTO BIM_I_MKT_RATES MRT(tc_code,

5346:
5347: BIS_COLLECTION_UTILITIES.log('BIM_I_MARKETING_FACTS:Inserting into BIM_I_MKT_RATES');
5348: --insert into bim_i_mkt_rates
5349: INSERT
5350: INTO BIM_I_MKT_RATES MRT(tc_code,
5351: trx_date,
5352: prim_conversion_rate,
5353: sec_conversion_rate)
5354: SELECT from_currency,

Line 5497: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt

5493: ,BUDGET_APPROVED*sec_conversion_rate
5494: ,CONVERSION_RATE_S
5495: ,metric1*rt.prim_conversion_rate
5496: ,metric1*sec_conversion_rate
5497: FROM bim_i_marketing_facts_stg a, bim_i_mkt_rates rt
5498: where a.from_currency = rt.tc_code(+)
5499: and a.transaction_create_date= rt.trx_date(+);
5500:
5501: --Insert schedules