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_SNO_PKG dependencies on FND_PROFILE

Line 94: exception_tbl.exception_value * decode(exception_tbl.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0)) exception_value2,

90: exception_tbl.analysis_date,
91: exception_tbl.exception_type,
92: exception_tbl.exception_count,
93: exception_tbl.exception_value,
94: exception_tbl.exception_value * decode(exception_tbl.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0)) exception_value2,
95: exception_tbl.exception_days,
96: exception_tbl.exception_quantity,
97: exception_tbl.exception_ratio,
98: fnd_global.user_id,

Line 206: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

202: t.exception_type
203: ) exception_tbl,
204: msc_currency_conv_mv mcc
205: where mcc.FROM_CURRENCY(+) = nvl(exception_tbl.currency_code, 'XXX')
206: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
207: and mcc.CALENDAR_DATE(+) = exception_tbl.analysis_date;
208:
209: commit;
210:

Line 289: t1.resource_cost * decode(t1.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2

285: to_number(null) order_quantity,
286: to_number(null) resource_hours,
287: to_number(null) no_of_orders,
288: t1.resource_cost,
289: t1.resource_cost * decode(t1.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2
290: from
291: (select
292: mdrs.plan_id,
293: mdrs.sr_instance_id,

Line 320: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

316: and mdr.organization_id = mdrs.organization_id
317: and mdr.department_id = mdrs.department_id
318: and mdr.resource_id = mdrs.resource_id) t1,
319: msc_currency_conv_mv mcc
320: where mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
321: and mcc.from_currency(+) = nvl(t1.currency_code, 'XXX')
322: and mcc.calendar_date(+) = t1.resource_date
323: )
324: group by

Line 381: sum(t1.buy_order_value * decode(t1.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,nvl(mcc.conv_rate,0))) buy_order_value2,

377: sum(t1.po_reschedule_count),
378: sum(t1.po_count),
379: sum(t1.po_cancel_count),
380: sum(t1.buy_order_value),
381: sum(t1.buy_order_value * decode(t1.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,nvl(mcc.conv_rate,0))) buy_order_value2,
382: sum(t1.buy_order_count),
383: fnd_global.user_id,
384: sysdate,
385: sysdate,

Line 481: where mcc.to_currency(+) = FND_PROFILE.value('MSC_HUB_CUR_CODE_RPT')

477: ms.inventory_item_id,
478: trunc(ms.new_schedule_date)
479: ) t1,
480: msc_currency_conv_mv mcc
481: where mcc.to_currency(+) = FND_PROFILE.value('MSC_HUB_CUR_CODE_RPT')
482: and mcc.from_currency(+) = t1.currency_code
483: and mcc.calendar_date(+) = trunc(t1.analysis_date)
484: group by
485: t1.plan_id,

Line 544: t1.qty_by_due_date * nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) * decode(t1.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) constrained_fcst_value2, --wei: SNO new column

540: t1.qty_by_due_date,
541: t1.demand_qty net_demand, --wei: SNO new column
542: t1.qty_by_due_date constrained_fcst, --wei: SNO new column
543: t1.qty_by_due_date * nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) constrained_fcst_value, --wei: SNO new column
544: t1.qty_by_due_date * nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) * decode(t1.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) constrained_fcst_value2, --wei: SNO new column
545: l_user_id created_by,
546: l_sysdate creation_date,
547: l_user_id last_updated_by,
548: l_sysdate last_update_date,

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

591: and msi.sr_instance_id = decode(sign(t1.sr_instance_id), -1, mp.sr_instance_id, t1.sr_instance_id) --wei
592: and msi.organization_id = decode(sign(t1.organization_id), -1, mp.organization_id, t1.organization_id) --wei
593: and msi.inventory_item_id = t1.inventory_item_id
594: and t1.plan_id = mp.plan_id
595: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
596: and mcc.from_currency(+) = nvl(t1.currency_code, 'XXX')
597: and mcc.calendar_date(+) = t1.order_date;
598:
599: commit;

Line 802: sum((pab_tbl.pab_value) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

798: pab_tbl.vmi_flag,
799: pab_tbl.order_date,
800: sum(pab_tbl.pab_qty) pab_qty,
801: sum(pab_tbl.pab_value) pab_value,
802: sum((pab_tbl.pab_value) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
803: nvl(mcc.CONV_RATE,0))) pab_value2,
804: sum(pab_tbl.safety_Stock_qty) safety_Stock_qty,
805: sum(pab_tbl.min_inventory_level) min_inventory_level,
806: sum(pab_tbl.max_inventory_level) max_inventory_level,

Line 809: sum(pab_tbl.total_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

805: sum(pab_tbl.min_inventory_level) min_inventory_level,
806: sum(pab_tbl.max_inventory_level) max_inventory_level,
807: sum(pab_tbl.avg_daily_demand) avg_daily_demand,
808: sum(pab_tbl.total_cost),
809: sum(pab_tbl.total_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
810: nvl(mcc.CONV_RATE,0))),
811: sum(pab_tbl.revenue),
812: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
813: nvl(mcc.CONV_RATE,0))),

Line 812: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

808: sum(pab_tbl.total_cost),
809: sum(pab_tbl.total_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
810: nvl(mcc.CONV_RATE,0))),
811: sum(pab_tbl.revenue),
812: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
813: nvl(mcc.CONV_RATE,0))),
814: sum(pab_tbl.mfg_cost),
815: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
816: nvl(mcc.CONV_RATE,0))),

Line 815: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

811: sum(pab_tbl.revenue),
812: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
813: nvl(mcc.CONV_RATE,0))),
814: sum(pab_tbl.mfg_cost),
815: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
816: nvl(mcc.CONV_RATE,0))),
817: sum(pab_tbl.tp_cost),
818: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
819: nvl(mcc.CONV_RATE,0))),

Line 818: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

814: sum(pab_tbl.mfg_cost),
815: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
816: nvl(mcc.CONV_RATE,0))),
817: sum(pab_tbl.tp_cost),
818: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
819: nvl(mcc.CONV_RATE,0))),
820: sum(pab_tbl.po_cost),
821: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
822: nvl(mcc.CONV_RATE,0))),

Line 821: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

817: sum(pab_tbl.tp_cost),
818: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
819: nvl(mcc.CONV_RATE,0))),
820: sum(pab_tbl.po_cost),
821: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
822: nvl(mcc.CONV_RATE,0))),
823: sum(pab_tbl.carrying_cost),
824: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
825: nvl(mcc.CONV_RATE,0))),

Line 824: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

820: sum(pab_tbl.po_cost),
821: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
822: nvl(mcc.CONV_RATE,0))),
823: sum(pab_tbl.carrying_cost),
824: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
825: nvl(mcc.CONV_RATE,0))),
826: sum(pab_tbl.revenue- pab_tbl.total_cost),
827: sum((pab_tbl.revenue- pab_tbl.total_cost) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
828: nvl(mcc.CONV_RATE,0))),

Line 827: sum((pab_tbl.revenue- pab_tbl.total_cost) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

823: sum(pab_tbl.carrying_cost),
824: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
825: nvl(mcc.CONV_RATE,0))),
826: sum(pab_tbl.revenue- pab_tbl.total_cost),
827: sum((pab_tbl.revenue- pab_tbl.total_cost) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
828: nvl(mcc.CONV_RATE,0))),
829: sum(pab_tbl.inv_build_target) --wei: SNO measure
830: from
831: (

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

866: and bis_mtp.partner_type = 3
867: ) pab_tbl,
868: msc_currency_conv_mv mcc
869: where mcc.from_currency(+) =pab_tbl.currency_code --- make sure 'xxx' is not a valid currency code
870: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
871: and mcc.calendar_date(+) = pab_tbl.order_date
872: group by
873: pab_tbl.plan_id,
874: pab_tbl.plan_run_id,