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.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_PLAN_CURR_RATES

Line 946: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_plan_curr_rates';

942:
943: FII_UTIL.Stop_Timer;
944: FII_UTIL.Print_Timer('Analyzed the base tables in');
945:
946: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_plan_curr_rates';
947: EXECUTE IMMEDIATE l_trunc_stmt;
948: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_plan_curr_rates has been truncated.');
949:
950: BIS_COLLECTION_UTILITIES.put_line('Begin to retrieve the currency conversion rates.');

Line 948: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_plan_curr_rates has been truncated.');

944: FII_UTIL.Print_Timer('Analyzed the base tables in');
945:
946: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_plan_curr_rates';
947: EXECUTE IMMEDIATE l_trunc_stmt;
948: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_plan_curr_rates has been truncated.');
949:
950: BIS_COLLECTION_UTILITIES.put_line('Begin to retrieve the currency conversion rates.');
951: FII_UTIL.Start_Timer;
952:

Line 953: INSERT INTO isc_dbi_plan_curr_rates(

949:
950: BIS_COLLECTION_UTILITIES.put_line('Begin to retrieve the currency conversion rates.');
951: FII_UTIL.Start_Timer;
952:
953: INSERT INTO isc_dbi_plan_curr_rates(
954: ORGANIZATION_ID,
955: FROM_CURRENCY,
956: CONVERSION_DATE,
957: RATE,

Line 982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');

978:
979: FII_UTIL.Start_Timer;
980:
981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');
983:
984: FII_UTIL.Stop_Timer;
985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');
986:

Line 985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');

981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');
983:
984: FII_UTIL.Stop_Timer;
985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');
986:
987: RETURN(l_count);
988:
989: EXCEPTION

Line 1141: FROM isc_dbi_plan_curr_rates tmp

1137: from_currency FROM_CURRENCY,
1138: g_global_currency TO_CURRENCY,
1139: g_global_rate_type RATE_TYPE,
1140: decode(rate, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1141: FROM isc_dbi_plan_curr_rates tmp
1142: WHERE rate < 0
1143: UNION
1144: SELECT distinct decode(rate2, -3, to_date('01/01/1999','MM/DD/RRRR'), conversion_date) CURR_CONV_DATE,
1145: from_currency FROM_CURRENCY,

Line 1149: FROM isc_dbi_plan_curr_rates tmp

1145: from_currency FROM_CURRENCY,
1146: g_sec_global_currency TO_CURRENCY,
1147: g_sec_global_rate_type RATE_TYPE,
1148: decode(rate2, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY') STATUS
1149: FROM isc_dbi_plan_curr_rates tmp
1150: WHERE rate2 < 0
1151: AND l_sec_curr_def = 'Y';
1152:
1153: l_record Missing_Currency_Conversion%ROWTYPE;

Line 1211: -- Identify Missing Currency Rate from ISC_DBI_PLAN_CURR_RATES

1207:
1208: BEGIN
1209:
1210: -- ----------------------------------------------------------
1211: -- Identify Missing Currency Rate from ISC_DBI_PLAN_CURR_RATES
1212: -- When there is missing rate, exit the collection with error
1213: -- ----------------------------------------------------------
1214:
1215: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 1659: isc_dbi_plan_curr_rates curr,

1655: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate2) PURCHASING_COST_G1,
1656: ids.uom_code UOM_CODE
1657: FROM isc_dbi_tmp_plans tmp,
1658: isc_dbi_supplies_f ids,
1659: isc_dbi_plan_curr_rates curr,
1660: fii_time_day time
1661: WHERE tmp.plan_id = ids.plan_id
1662: AND bitand(tmp.plan_usage, 2) = 2
1663: AND ids.organization_id = curr.organization_id

Line 1783: isc_dbi_plan_curr_rates curr,

1779: AND reason.demand_id(+) = id.demand_id
1780: GROUP BY tmp.snapshot_id, id.organization_id, id.uom_code, id.demand_id, id.time_dmd_date_id, id.sr_inventory_item_id,
1781: reason.organization_type, reason.sr_inventory_item_id, reason.sr_supplier_id, reason.sr_supplier_site_id,
1782: reason.organization_id, reason.resource_id, reason.department_id, reason.reason_type) f,
1783: isc_dbi_plan_curr_rates curr,
1784: fii_time_day time
1785: WHERE f.time_dmd_date_id = time.report_date
1786: AND f.organization_id = curr.organization_id
1787: GROUP BY f.snapshot_id, f.organization_id, f.dmd_item_id, f.uom_code, f.organization_type, f.reason_type,

Line 1899: isc_dbi_plan_curr_rates curr,

1895: AND reason.demand_id(+) = id.demand_id
1896: GROUP BY tmp.snapshot_id, id.organization_id, id.uom_code, id.demand_id, id.time_dmd_date_id, id.sr_inventory_item_id,
1897: iex.number1, reason.organization_type, reason.sr_inventory_item_id, reason.sr_supplier_id, reason.sr_supplier_site_id,
1898: reason.organization_id, reason.resource_id, reason.department_id, reason.reason_type) f,
1899: isc_dbi_plan_curr_rates curr,
1900: fii_time_day time
1901: WHERE f.time_dmd_date_id = time.report_date
1902: AND f.organization_id = curr.organization_id
1903: GROUP BY f.snapshot_id, f.organization_id, f.dmd_item_id, f.uom_code, f.organization_type, f.reason_type,

Line 2005: isc_dbi_plan_curr_rates curr

2001: AND iinv.organization_id = per.organization_id
2002: AND per.adjustment_period_flag = 'N'
2003: AND iinv.detail_date = per.start_date
2004: AND time1.report_date between per.start_date and per.end_date) fact,
2005: isc_dbi_plan_curr_rates curr
2006: WHERE fact.organization_id = curr.organization_id
2007: GROUP BY fact.snapshot_id, fact.organization_id, fact.sr_inventory_item_id, fact.uom_code,
2008: grouping sets(fact.ent_year_start_date, fact.ent_qtr_start_date, fact.ent_period_start_date)
2009: UNION ALL