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.MSC_ITEM_PKG dependencies on FND_PROFILE

Line 665: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_value2,

661: f.indep_demand_qty,
662: f.dep_demand_qty,
663: f.sales_order_value,
664: f.sales_order_value *
665: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_value2,
666: f.return_order_value,
667: f.make_order_qty,
668: f.make_order_leadtime,
669: f.make_order_count,

Line 698: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_schd_recp_value2,

694: f.sup_end_pgd_to_so_value,
695: f.sup_end_pgd_to_ss_value,
696: f.sup_end_pgd_to_excess_value,
697: f.dmd_pgd_to_schd_recp_value *
698: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_schd_recp_value2,
699: f.dmd_pgd_to_plnd_order_value *
700: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_plnd_order_value2,
701: f.dmd_pgd_to_onhand_value *
702: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_onhand_value2,

Line 700: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_plnd_order_value2,

696: f.sup_end_pgd_to_excess_value,
697: f.dmd_pgd_to_schd_recp_value *
698: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_schd_recp_value2,
699: f.dmd_pgd_to_plnd_order_value *
700: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_plnd_order_value2,
701: f.dmd_pgd_to_onhand_value *
702: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_onhand_value2,
703: f.sup_end_pgd_to_fcst_value *
704: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_fcst_value2,

Line 702: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_onhand_value2,

698: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_schd_recp_value2,
699: f.dmd_pgd_to_plnd_order_value *
700: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_plnd_order_value2,
701: f.dmd_pgd_to_onhand_value *
702: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_onhand_value2,
703: f.sup_end_pgd_to_fcst_value *
704: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_fcst_value2,
705: f.sup_end_pgd_to_so_value *
706: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_so_value2,

Line 704: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_fcst_value2,

700: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_plnd_order_value2,
701: f.dmd_pgd_to_onhand_value *
702: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_onhand_value2,
703: f.sup_end_pgd_to_fcst_value *
704: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_fcst_value2,
705: f.sup_end_pgd_to_so_value *
706: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_so_value2,
707: f.sup_end_pgd_to_ss_value *
708: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_ss_value2,

Line 706: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_so_value2,

702: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) dmd_pgd_to_onhand_value2,
703: f.sup_end_pgd_to_fcst_value *
704: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_fcst_value2,
705: f.sup_end_pgd_to_so_value *
706: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_so_value2,
707: f.sup_end_pgd_to_ss_value *
708: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_ss_value2,
709: f.sup_end_pgd_to_excess_value *
710: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_excess_value2,

Line 708: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_ss_value2,

704: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_fcst_value2,
705: f.sup_end_pgd_to_so_value *
706: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_so_value2,
707: f.sup_end_pgd_to_ss_value *
708: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_ss_value2,
709: f.sup_end_pgd_to_excess_value *
710: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_excess_value2,
711: f.supply_qty_usable,
712: f.supply_qty_defective,

Line 710: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_excess_value2,

706: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_so_value2,
707: f.sup_end_pgd_to_ss_value *
708: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_ss_value2,
709: f.sup_end_pgd_to_excess_value *
710: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sup_end_pgd_to_excess_value2,
711: f.supply_qty_usable,
712: f.supply_qty_defective,
713: f.onhand_value,
714: f.onhand_value *

Line 715: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) onhand_value2,

711: f.supply_qty_usable,
712: f.supply_qty_defective,
713: f.onhand_value,
714: f.onhand_value *
715: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) onhand_value2,
716: f.scheduled_rept_value,
717: f.scheduled_rept_value *
718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,
719: fnd_global.user_id, sysdate,

Line 718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,

714: f.onhand_value *
715: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) onhand_value2,
716: f.scheduled_rept_value,
717: f.scheduled_rept_value *
718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,
719: fnd_global.user_id, sysdate,
720: sysdate, fnd_global.user_id, fnd_global.login_id,
721: fnd_global.conc_program_id, fnd_global.conc_login_id,
722: fnd_global.prog_appl_id, fnd_global.conc_request_id

Line 793: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)

789: decode(l_plan_type, 6, l_owning_currency_code, nvl(mtp.currency_code, l_owning_currency_code))
790: ) f,
791: msc_currency_conv_mv mcc
792: where f.currency_code=mcc.from_currency(+)
793: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)
794: and f.order_date=mcc.calendar_date(+);
795:
796: l_rowcount1 := l_rowcount1 + sql%rowcount;
797: msc_phub_util.log('insert into msc_item_orders_f:final: '||sql%rowcount);

Line 1203: if ((l_enforce_wh_cpty = 1 or nvl(fnd_profile.value('MSR_ENABLE_CYCLE_STOCK_ADJUSTMENT'), 'N') = 'Y')

1199:
1200:
1201:
1202:
1203: if ((l_enforce_wh_cpty = 1 or nvl(fnd_profile.value('MSR_ENABLE_CYCLE_STOCK_ADJUSTMENT'), 'N') = 'Y')
1204: and l_plan_type = 4) then
1205: -- msc_st_item_inventory_f:warehouse_req
1206: insert /*+ append nologging */ into msc_st_item_inventory_f (
1207: st_transaction_id,

Line 1410: f.pab_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) pab_value2,

1406: to_number(-23453) sr_category_id,
1407:
1408: f.pab_qty,
1409: f.pab_value,
1410: f.pab_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) pab_value2,
1411: f.pab_volume,
1412: f.safety_stock_qty,
1413: f.min_inventory_level,
1414: f.max_inventory_level,

Line 1420: f.safety_stock_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) safety_stock_value2,

1416: f.target_inventory_level, -- new measures populated for DRP
1417: f.target_inventory_level_dos, -- new measures populated for DRP
1418: f.inv_build_target,
1419: f.safety_stock_value,
1420: f.safety_stock_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) safety_stock_value2,
1421: f.safety_stock_volume,
1422: f.safety_stock_days,
1423: f.inventory_cost_post,
1424: f.inventory_cost_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_post2,

Line 1424: f.inventory_cost_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_post2,

1420: f.safety_stock_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) safety_stock_value2,
1421: f.safety_stock_volume,
1422: f.safety_stock_days,
1423: f.inventory_cost_post,
1424: f.inventory_cost_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_post2,
1425: f.inventory_cost_no_post,
1426: f.inventory_cost_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_no_post2,
1427: f.inventory_value_post,
1428: f.inventory_value_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_post2,

Line 1426: f.inventory_cost_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_no_post2,

1422: f.safety_stock_days,
1423: f.inventory_cost_post,
1424: f.inventory_cost_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_post2,
1425: f.inventory_cost_no_post,
1426: f.inventory_cost_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_no_post2,
1427: f.inventory_value_post,
1428: f.inventory_value_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_post2,
1429: f.inventory_value_no_post,
1430: f.inventory_value_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_no_post2,

Line 1428: f.inventory_value_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_post2,

1424: f.inventory_cost_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_post2,
1425: f.inventory_cost_no_post,
1426: f.inventory_cost_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_no_post2,
1427: f.inventory_value_post,
1428: f.inventory_value_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_post2,
1429: f.inventory_value_no_post,
1430: f.inventory_value_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_no_post2,
1431: f.demand_var_ss_qty,
1432: f.sup_ltvar_ss_qty,

Line 1430: f.inventory_value_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_no_post2,

1426: f.inventory_cost_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_cost_no_post2,
1427: f.inventory_value_post,
1428: f.inventory_value_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_post2,
1429: f.inventory_value_no_post,
1430: f.inventory_value_no_post * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value_no_post2,
1431: f.demand_var_ss_qty,
1432: f.sup_ltvar_ss_qty,
1433: f.transit_ltvar_ss_qty,
1434: f.mfg_ltvar_ss_qty,

Line 1437: f.inventory_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value2,

1433: f.transit_ltvar_ss_qty,
1434: f.mfg_ltvar_ss_qty,
1435: f.total_unpooled_safety_stock,
1436: f.inventory_value,
1437: f.inventory_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) inventory_value2,
1438: f.wh_required_capacity,
1439: f.avg_cycle_stock,
1440: f.avg_cycle_stock_volume,
1441: f.iqi_value,

Line 1517: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)

1513: decode(l_plan_type, 6, l_owning_currency_code, nvl(mtp.currency_code, l_owning_currency_code))
1514: ) f,
1515: msc_currency_conv_mv mcc
1516: where f.currency_code=mcc.from_currency(+)
1517: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)
1518: and f.order_date=mcc.calendar_date(+);
1519:
1520: l_rowcount2 := l_rowcount2 + sql%rowcount;
1521: msc_phub_util.log('insert into msc_item_inventory_f:final: '||sql%rowcount);

Line 1547: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

1543:
1544: procedure summarize_item_inventory_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1545: p_plan_id number, p_plan_run_id number)
1546: is
1547: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1548: begin
1549: msc_phub_util.log('msc_item_pkg.summarize_item_inventory_f');
1550: retcode := 0;
1551: errbuf := '';

Line 1685: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

1681:
1682: procedure summarize_item_orders_f(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1683: p_plan_id number, p_plan_run_id number)
1684: is
1685: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1686: begin
1687: msc_phub_util.log('msc_item_pkg.summarize_item_orders_f');
1688: retcode := 0;
1689: errbuf := '';