[Home] [Help]
726: decode(GROUPING(msd.customer_id), 1, NULL, nvl(msd.customer_id, UNDEFINED_CUSTOMER_ID)) AS partner_id,
727: decode(GROUPING(cust.customer_class_code), 1, NULL, NVL(cust.customer_class_code, UNDEFINED_CUSTOMER_CODE)) AS customer_class_code,
728: RECORD_SERVICE_LEVEL AS record_type
729: FROM msc_demands msd, msc_system_items msi,
730: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo, msc_trading_partners cust
731: WHERE mp.plan_id = p_plan_id
732: AND msd.plan_id = msi.plan_id
733: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
734: AND trunc(msd.using_assembly_demand_date) between l_start_date AND l_end_date
920: msc_plan_organizations mpo,
921: msc_demands msd,
922: msc_plan_buckets mpb,
923: msc_system_items msi,
924: msc_item_categories mic,
925: msc_trading_partners owning,
926: msc_period_start_dates mpsd
927: WHERE mp.plan_id = p_plan_id
928: AND msd.plan_id = msi.plan_id
1044: FROM msc_plans mp,
1045: msc_plan_organizations mpo,
1046: msc_demands msd,
1047: msc_system_items msi,
1048: msc_item_categories mic,
1049: msc_bis_periods msbp
1050: WHERE mp.plan_id = p_plan_id
1051: AND mp.plan_id = mpo.plan_id
1052: AND msd.organization_id = mpo.organization_id
1136: msc_plan_organizations mpo,
1137: msc_demands msd,
1138: msc_plan_buckets mpb,
1139: msc_system_items msi,
1140: msc_item_categories mic,
1141: msc_trading_partners owning,
1142: msc_period_start_dates mpsd
1143: WHERE mp.plan_id = p_plan_id
1144: AND msd.plan_id = msi.plan_id
1228: msc_plan_organizations mpo,
1229: msc_demands msd,
1230: msc_plan_buckets mpb,
1231: msc_system_items msi,
1232: msc_item_categories mic,
1233: msc_trading_partners owning
1234: --msc_period_start_dates mpsd
1235: WHERE mp.plan_id = p_plan_id
1236: AND msd.plan_id = msi.plan_id
1311: msc_trading_partners owning,
1312: msc_period_start_dates mpsd,
1313: msc_demands msd,
1314: msc_system_items msi,
1315: msc_item_categories mic
1316: WHERE mp.plan_id = p_plan_id
1317: AND mp.sr_instance_id = owning.sr_instance_id
1318: AND mp.organization_id = owning.sr_tp_id
1319: AND owning.partner_type = 3
1386: FROM msc_plans mp,
1387: msc_plan_organizations mpo,
1388: msc_demands msd,
1389: msc_system_items msi,
1390: msc_item_categories mic,
1391: msc_bis_periods msbp
1392: WHERE mp.plan_id = p_plan_id
1393: AND mp.plan_id = mpo.plan_id
1394: AND msd.organization_id = mpo.organization_id
1466: FROM msc_plans mp,
1467: msc_plan_organizations mpo,
1468: msc_bis_inv_detail mbid,
1469: msc_system_items mis,
1470: msc_item_categories mic,
1471: msc_trading_partners mtp,
1472: msc_period_start_dates mpsd,
1473: msc_plan_buckets mpb
1474: WHERE mp.plan_id = p_plan_id
1552: FROM msc_plans mp,
1553: msc_plan_organizations mpo,
1554: msc_bis_inv_detail mbid,
1555: msc_system_items mis,
1556: msc_item_categories mic,
1557: msc_bis_periods mpsd
1558: WHERE mp.plan_id = p_plan_id
1559: AND mp.plan_id = mpo.plan_id
1560: AND mpo.plan_id = mbid.plan_id
1654: NULL AS partner_id,
1655: NULL AS customer_class_code,
1656: RECORD_SAFETY_STOCK AS record_type
1657: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
1658: msc_system_items msi, msc_item_categories mic
1659: WHERE mss.sr_instance_id = msi.sr_instance_id
1660: AND mss.plan_id = msi.plan_id
1661: AND mss.organization_id = msi.organization_id
1662: AND mss.inventory_item_id = msi.inventory_item_id
1794: 0 AS nr_sl_records,
1795: NULL AS partner_id,
1796: NULL AS customer_class_code,
1797: RECORD_SAFETY_STOCK AS record_type
1798: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
1799: msc_plans mp, msc_plan_organizations mpo
1800: WHERE mss.sr_instance_id = msi.sr_instance_id
1801: AND mss.plan_id = msi.plan_id
1802: AND mss.organization_id = msi.organization_id
2113: NULL AS item_id,
2114: SYSDATE AS last_update_date,
2115: -1 AS last_updated_by,
2116: SYSDATE AS CREATION_DATE
2117: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2118: msc_trading_partners mtp, msc_period_start_dates mpsd, msc_plan_buckets mpb
2119: WHERE mp.plan_id = l_planlist(l_index)
2120: AND mp.plan_id = mpo.plan_id
2121: AND mpo.plan_id = mbid.plan_id
2219: NULL AS item_id,
2220: SYSDATE AS last_update_date,
2221: -1 AS last_updated_by,
2222: SYSDATE AS CREATION_DATE
2223: FROM msc_plans mp, msc_plan_organizations mpo, msc_bis_inv_detail mbid, msc_system_items mis, msc_item_categories mic,
2224: msc_bis_periods mpsd
2225: WHERE mp.plan_id = l_planlist(l_index)
2226: AND mp.plan_id = mpo.plan_id
2227: AND mpo.plan_id = mbid.plan_id
2420: SYSDATE,
2421: -1,
2422: SYSDATE
2423: FROM msc_plans mp, msc_plan_organizations mpo, msc_demands msd, msc_system_items msi,
2424: msc_item_categories mic, msc_bis_periods msbp
2425: WHERE mp.plan_id = l_planlist(l_index)
2426: AND mp.plan_id = mpo.plan_id
2427: AND msd.organization_id = mpo.organization_id
2428: AND msd.sr_instance_id = mpo.sr_instance_id