DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_SYSTEM_ITEMS

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 938: msc_system_items msi,

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,
941: msc_period_start_dates mpsd
942: WHERE mp.plan_id = p_plan_id

Line 1051: msc_system_items msi,

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
1055: AND mp.plan_id = mpo.plan_id

Line 1140: msc_system_items msi,

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,
1143: msc_period_start_dates mpsd
1144: WHERE mp.plan_id = p_plan_id

Line 1264: msc_system_items msi,

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
1268: AND mp.plan_id = mpo.plan_id

Line 1357: msc_system_items msi,

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,
1360: msc_period_start_dates mpsd
1361: WHERE mp.plan_id = p_plan_id

Line 1449: msc_system_items msi,

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
1452: --msc_period_start_dates mpsd
1453: WHERE mp.plan_id = p_plan_id

Line 1532: msc_system_items msi,

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
1536: AND mp.organization_id = owning.sr_tp_id

Line 1607: msc_system_items msi,

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
1611: AND mp.plan_id = mpo.plan_id

Line 1795: msc_system_items mis,

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,
1799: msc_plan_buckets mpb

Line 1881: msc_system_items mis,

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
1885: AND mp.plan_id = mpo.plan_id

Line 1984: msc_system_items msi, msc_item_categories mic

1980: NULL AS partner_id,
1981: NULL AS customer_class_code,
1982: RECORD_SAFETY_STOCK AS record_type
1983: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
1984: msc_system_items msi, msc_item_categories mic
1985: WHERE mss.sr_instance_id = msi.sr_instance_id
1986: AND mss.plan_id = msi.plan_id
1987: AND mss.organization_id = msi.organization_id
1988: AND mss.inventory_item_id = msi.inventory_item_id

Line 2047: msc_system_items msi, msc_item_categories mic,

2043: NULL AS partner_id,
2044: NULL AS customer_class_code,
2045: RECORD_SAFETY_STOCK AS record_type
2046: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
2047: msc_system_items msi, msc_item_categories mic,
2048: msc_plan_buckets mpb
2049: WHERE mss.sr_instance_id = msi.sr_instance_id
2050: AND mss.plan_id = msi.plan_id
2051: AND mss.organization_id = msi.organization_id

Line 2213: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,

2209: 0 AS nr_sl_records,
2210: NULL AS partner_id,
2211: NULL AS customer_class_code,
2212: RECORD_SAFETY_STOCK AS record_type
2213: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
2214: msc_plans mp, msc_plan_organizations mpo
2215: WHERE mss.sr_instance_id = msi.sr_instance_id
2216: AND mss.plan_id = msi.plan_id
2217: AND mss.organization_id = msi.organization_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 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

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