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.

[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_BIS_INV_DETAIL

Line 1794: msc_bis_inv_detail mbid,

1790: g_user_id,
1791: to_number(null)
1792: FROM msc_plans mp,
1793: msc_plan_organizations mpo,
1794: msc_bis_inv_detail mbid,
1795: msc_system_items mis,
1796: msc_item_categories mic,
1797: msc_trading_partners mtp,
1798: msc_period_start_dates mpsd,

Line 1807: -- For some strange reason MSC_BIS_INV_DETAIL has week records for period buckets

1803: AND mpo.organization_id = mbid.organization_id
1804: AND mpo.sr_instance_id = mbid.sr_instance_id
1805: AND mbid.period_type = CALENDAR_TYPE_MFG
1806: -- BEGIN FUNNY SECTION
1807: -- For some strange reason MSC_BIS_INV_DETAIL has week records for period buckets
1808: -- So we need to filter thsese out before we aggregate
1809: AND mpb.plan_id = mbid.plan_id
1810: AND (mpb.bucket_type = 2 OR nvl(detail_level, DETAIL_LEVEL_PERIOD) = DETAIL_LEVEL_PERIOD)
1811: AND mbid.detail_date BETWEEN mpb.bkt_start_date AND mpb.bkt_end_date

Line 1880: msc_bis_inv_detail mbid,

1876: g_user_id,
1877: to_number(null)
1878: FROM msc_plans mp,
1879: msc_plan_organizations mpo,
1880: msc_bis_inv_detail mbid,
1881: msc_system_items mis,
1882: msc_item_categories mic,
1883: msc_bis_periods mpsd
1884: WHERE mp.plan_id = p_plan_id

Line 2532: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,

2528: NULL AS item_id,
2529: SYSDATE AS last_update_date,
2530: -1 AS last_updated_by,
2531: SYSDATE AS CREATION_DATE
2532: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2533: msc_trading_partners mtp, msc_period_start_dates mpsd, msc_plan_buckets mpb
2534: WHERE mp.plan_id = l_planlist(l_index)
2535: AND mp.plan_id = mpo.plan_id
2536: AND mpo.plan_id = mbid.plan_id

Line 2543: -- For some strange reason MSC_BIS_INV_DETAIL has week records for period buckets

2539: AND mpo.sr_instance_id = nvl(l_sr_instance_id, mpo.sr_instance_id)
2540: AND mpo.organization_id = nvl(l_sr_tp_id, mpo.organization_id)
2541: AND mbid.period_type = CALENDAR_TYPE_MFG
2542: -- BEGIN FUNNY SECTION
2543: -- For some strange reason MSC_BIS_INV_DETAIL has week records for period buckets
2544: -- So we need to filter these out before we aggregate
2545: AND mpb.plan_id = mbid.plan_id
2546: AND (mpb.bucket_type = 2 OR nvl(detail_level, DETAIL_LEVEL_PERIOD) = DETAIL_LEVEL_PERIOD)
2547: AND mbid.detail_date BETWEEN mpb.bkt_start_date AND mpb.bkt_end_date

Line 2638: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,

2634: NULL AS item_id,
2635: SYSDATE AS last_update_date,
2636: -1 AS last_updated_by,
2637: SYSDATE AS CREATION_DATE
2638: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2639: msc_bis_periods mpsd
2640: WHERE mp.plan_id = l_planlist(l_index)
2641: AND mp.plan_id = mpo.plan_id
2642: AND mpo.plan_id = mbid.plan_id