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_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_DEMANDS

Line 743: FROM msc_demands msd, msc_system_items msi,

739: count(*) AS nr_sl_records,
740: decode(GROUPING(msd.customer_id), 1, NULL, nvl(msd.customer_id, UNDEFINED_CUSTOMER_ID)) AS partner_id,
741: decode(GROUPING(cust.customer_class_code), 1, NULL, NVL(cust.customer_class_code, UNDEFINED_CUSTOMER_CODE)) AS customer_class_code,
742: RECORD_SERVICE_LEVEL AS record_type
743: FROM msc_demands msd, msc_system_items msi,
744: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo, msc_trading_partners cust
745: WHERE mp.plan_id = p_plan_id
746: AND msd.plan_id = msi.plan_id
747: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)

Line 936: msc_demands msd,

932: g_user_id,
933: to_number(null)
934: FROM msc_plans mp,
935: msc_plan_organizations mpo,
936: msc_demands msd,
937: msc_plan_buckets mpb,
938: msc_system_items msi,
939: msc_item_categories mic,
940: msc_trading_partners owning,

Line 1050: msc_demands msd,

1046: g_user_id,
1047: to_number(null)
1048: FROM msc_plans mp,
1049: msc_plan_organizations mpo,
1050: msc_demands msd,
1051: msc_system_items msi,
1052: msc_item_categories mic,
1053: msc_bis_periods msbp
1054: WHERE mp.plan_id = p_plan_id

Line 1138: msc_demands msd,

1134: g_user_id,
1135: to_number(null)
1136: FROM msc_plans mp,
1137: msc_plan_organizations mpo,
1138: msc_demands msd,
1139: msc_plan_buckets mpb,
1140: msc_system_items msi,
1141: msc_item_categories mic,
1142: msc_trading_partners owning,

Line 1263: msc_demands msd,

1259: g_user_id,
1260: to_number(null)
1261: FROM msc_plans mp,
1262: msc_plan_organizations mpo,
1263: msc_demands msd,
1264: msc_system_items msi,
1265: msc_item_categories mic,
1266: msc_bis_periods msbp
1267: WHERE mp.plan_id = p_plan_id

Line 1355: msc_demands msd,

1351: g_user_id,
1352: to_number(null)
1353: FROM msc_plans mp,
1354: msc_plan_organizations mpo,
1355: msc_demands msd,
1356: msc_plan_buckets mpb,
1357: msc_system_items msi,
1358: msc_item_categories mic,
1359: msc_trading_partners owning,

Line 1447: msc_demands msd,

1443: g_user_id,
1444: to_number(null)
1445: FROM msc_plans mp,
1446: msc_plan_organizations mpo,
1447: msc_demands msd,
1448: msc_plan_buckets mpb,
1449: msc_system_items msi,
1450: msc_item_categories mic,
1451: msc_trading_partners owning

Line 1531: msc_demands msd,

1527: to_number(null)
1528: FROM msc_plans mp,
1529: msc_trading_partners owning,
1530: msc_period_start_dates mpsd,
1531: msc_demands msd,
1532: msc_system_items msi,
1533: msc_item_categories mic
1534: WHERE mp.plan_id = p_plan_id
1535: AND mp.sr_instance_id = owning.sr_instance_id

Line 1606: msc_demands msd,

1602: g_user_id,
1603: to_number(null)
1604: FROM msc_plans mp,
1605: msc_plan_organizations mpo,
1606: msc_demands msd,
1607: msc_system_items msi,
1608: msc_item_categories mic,
1609: msc_bis_periods msbp
1610: WHERE mp.plan_id = p_plan_id

Line 2837: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,

2833: mic.category_name AS category_name,
2834: SYSDATE,
2835: -1,
2836: SYSDATE
2837: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
2838: msc_item_categories mic, msc_bis_periods msbp
2839: WHERE mp.plan_id = l_planlist(l_index)
2840: AND mp.plan_id = mpo.plan_id
2841: AND msd.organization_id = mpo.organization_id