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 1158: sum((pab_tbl.pab_value) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,

1154: to_number(-23453) category_set_id,
1155: to_number(-23453) sr_category_id,
1156: sum(pab_tbl.pab_qty) pab_qty, --- sum(decode(sign(pab_tbl.pab_qty),-1,0,pab_tbl.pab_qty)),
1157: sum(pab_tbl.pab_value) pab_value, -- sum(decode(sign(pab_tbl.pab_qty),-1,0,pab_tbl.pab_value)),
1158: sum((pab_tbl.pab_value) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1159: nvl(mcc.CONV_RATE,0))) pab_value2,
1160: sum(pab_tbl.safety_Stock_qty) safety_Stock_qty ,
1161: sum(pab_tbl.min_inventory_level) min_inventory_level,
1162: sum(pab_tbl.max_inventory_level) max_inventory_level,

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

1163: sum(pab_tbl.avg_daily_demand) avg_daily_demand,
1164: ---------------------------------------------------------------------
1165:
1166: sum(pab_tbl.total_cost),
1167: sum(pab_tbl.total_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1168: nvl(mcc.CONV_RATE,0))),
1169: sum(pab_tbl.revenue),
1170: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1171: nvl(mcc.CONV_RATE,0))),

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

1166: sum(pab_tbl.total_cost),
1167: sum(pab_tbl.total_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1168: nvl(mcc.CONV_RATE,0))),
1169: sum(pab_tbl.revenue),
1170: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1171: nvl(mcc.CONV_RATE,0))),
1172: sum(pab_tbl.mfg_cost),
1173: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1174: nvl(mcc.CONV_RATE,0))),

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

1169: sum(pab_tbl.revenue),
1170: sum(pab_tbl.revenue * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1171: nvl(mcc.CONV_RATE,0))),
1172: sum(pab_tbl.mfg_cost),
1173: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1174: nvl(mcc.CONV_RATE,0))),
1175: sum(pab_tbl.tp_cost),
1176: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1177: nvl(mcc.CONV_RATE,0))),

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

1172: sum(pab_tbl.mfg_cost),
1173: sum(pab_tbl.mfg_cost* decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1174: nvl(mcc.CONV_RATE,0))),
1175: sum(pab_tbl.tp_cost),
1176: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1177: nvl(mcc.CONV_RATE,0))),
1178: sum(pab_tbl.po_cost) ,
1179: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1180: nvl(mcc.CONV_RATE,0))),

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

1175: sum(pab_tbl.tp_cost),
1176: sum(pab_tbl.tp_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1177: nvl(mcc.CONV_RATE,0))),
1178: sum(pab_tbl.po_cost) ,
1179: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1180: nvl(mcc.CONV_RATE,0))),
1181: sum(pab_tbl.carrying_cost),
1182: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1183: nvl(mcc.CONV_RATE,0))),

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

1178: sum(pab_tbl.po_cost) ,
1179: sum(pab_tbl.po_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1180: nvl(mcc.CONV_RATE,0))),
1181: sum(pab_tbl.carrying_cost),
1182: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1183: nvl(mcc.CONV_RATE,0))),
1184: sum(pab_tbl.revenue- pab_tbl.total_cost),
1185: sum((pab_tbl.revenue- pab_tbl.total_cost) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1186: nvl(mcc.CONV_RATE,0))),

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

1181: sum(pab_tbl.carrying_cost),
1182: sum(pab_tbl.carrying_cost * decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1183: nvl(mcc.CONV_RATE,0))),
1184: sum(pab_tbl.revenue- pab_tbl.total_cost),
1185: sum((pab_tbl.revenue- pab_tbl.total_cost) *decode(pab_tbl.currency_code,fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1,
1186: nvl(mcc.CONV_RATE,0))),
1187:
1188: sum(pab_tbl.inv_build_target)
1189: from

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

1588:
1589: ) pab_tbl,msc_plans mp_tbl,
1590: MSC_CURRENCY_CONV_MV mcc
1591: where mcc.FROM_CURRENCY(+) =pab_tbl.currency_code --- make sure 'xxx' is not a valid currency code
1592: and mcc.TO_CURRENCY(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
1593: and mcc.CALENDAR_DATE(+) = pab_tbl.order_date
1594: and mp_tbl.plan_id = pab_tbl.plan_id ---
1595: group by
1596: pab_tbl.plan_id,

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

1934:
1935: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
1936: p_plan_id number, p_plan_run_id number)
1937: is
1938: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
1939: begin
1940: -- level 1
1941: insert into msc_item_inventory_f (
1942: plan_id, plan_run_id, io_plan_flag,