[Home] [Help]
159: IS
160: CURSOR c1(p_plan_id NUMBER) IS
161: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
162: mpsd.period_start_date
163: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
164: WHERE mp.plan_id = p_plan_id
165: AND mtp.sr_tp_id = mp.organization_id
166: AND mtp.sr_instance_id = mp.sr_instance_id
167: AND mtp.partner_type = 3
218: IS
219: CURSOR c1(p_plan_id NUMBER) IS
220: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
221: mpsd.period_start_date, mpb.bucket_type
222: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
223: WHERE mp.plan_id = p_plan_id
224: AND mtp.sr_tp_id = mp.organization_id
225: AND mtp.sr_instance_id = mp.sr_instance_id
226: AND mtp.partner_type = 3
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)
748: AND trunc(msd.using_assembly_demand_date) between l_start_date AND l_end_date
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
943: AND msd.plan_id = msi.plan_id
944: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
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
1145: AND msd.plan_id = msi.plan_id
1146: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
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
1362: AND msd.plan_id = msi.plan_id
1363: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
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
1454: AND msd.plan_id = msi.plan_id
1455: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1525: sysdate,
1526: g_user_id,
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
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
1800: WHERE mp.plan_id = p_plan_id
1801: AND mp.plan_id = mpo.plan_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
2537: AND mpo.organization_id = mbid.organization_id