[Home] [Help]
145: IS
146: CURSOR c1(p_plan_id NUMBER) IS
147: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
148: mpsd.period_start_date
149: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
150: WHERE mp.plan_id = p_plan_id
151: AND mtp.sr_tp_id = mp.organization_id
152: AND mtp.sr_instance_id = mp.sr_instance_id
153: AND mtp.partner_type = 3
204: IS
205: CURSOR c1(p_plan_id NUMBER) IS
206: SELECT mp.plan_id, mp.compile_designator, mtp.calendar_code, mpb.bkt_start_date, mpb.bkt_end_date,
207: mpsd.period_start_date, mpb.bucket_type
208: FROM msc_plans mp, msc_trading_partners mtp, msc_plan_buckets mpb, msc_period_start_dates mpsd
209: WHERE mp.plan_id = p_plan_id
210: AND mtp.sr_tp_id = mp.organization_id
211: AND mtp.sr_instance_id = mp.sr_instance_id
212: AND mtp.partner_type = 3
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
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
929: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
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
1145: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
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
1237: AND msd.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)
1307: sysdate,
1308: g_user_id,
1309: to_number(null)
1310: FROM msc_plans mp,
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
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
1475: AND mp.plan_id = mpo.plan_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
2122: AND mpo.organization_id = mbid.organization_id