[Home] [Help]
253: ms.implement_date,
254: ms.new_order_quantity,
255: msi.buyer_name
256: from msc_plans mp,
257: msc_system_items msi,
258: msc_supplies ms
259: where ms.plan_id = p_plan_id
260: and ms.transaction_id = p_transaction_id
261: and mp.plan_id = ms.plan_id
390:
391: CURSOR buyer_c IS
392: select mpc.name
393: from msc_supplies ms,
394: msc_system_items msi,
395: msc_partner_contacts mpc
396: where ms.plan_id = p_plan_id
397: and ms.transaction_id = p_transaction_id
398: and msi.plan_id = ms.plan_id
827: p_uom_code,
828: p_operating_unit,
829: p_action
830: FROM msc_apps_instances mai, -- xml fix
831: msc_system_items msi,
832: msc_trading_partners mp,
833: msc_supplies s
834: WHERE msi.inventory_item_id = s.inventory_item_id
835: AND msi.plan_id = s.plan_id
934: p_po_number,
935: p_po_quantity,
936: p_plan_id
937: FROM msc_apps_instances mai,
938: msc_system_items msi,
939: msc_supplies s
940: WHERE msi.inventory_item_id = s.inventory_item_id
941: AND msi.plan_id = s.plan_id
942: AND msi.organization_id = s.organization_id
1251:
1252: CURSOR source_item_c(l_inst_id number, l_org_id number,
1253: l_item_id number) IS
1254: select sr_inventory_item_id
1255: from msc_system_items msi
1256: where msi.plan_id = arg_plan_id
1257: and msi.organization_id =l_org_id
1258: and msi.sr_instance_id = l_inst_id
1259: and msi.inventory_item_id = l_item_id;
2220: s.po_line_id,
2221: s.implement_quantity,
2222: cal2.calendar_date
2223: from msc_supplies s,
2224: msc_system_items msi,
2225: msc_plans mp,
2226: msc_calendar_dates cal1,
2227: msc_calendar_dates cal2,
2228: msc_trading_partners mtp
2593: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2594: md.planned_arrival_date,
2595: md.intransit_lead_time
2596: from msc_demands md,
2597: msc_system_items msi
2598: where md.plan_id = p_plan_id
2599: and md.ship_set_id = p_ship_set_id
2600: and msi.plan_id = md.plan_id
2601: and msi.organization_id = md.organization_id
2621: md.sr_instance_id,
2622: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2623: md.planned_arrival_date
2624: from msc_demands md,
2625: msc_system_items msi
2626: where md.plan_id = p_plan_id
2627: and md.arrival_set_id = p_arrival_set_id
2628: and msi.plan_id = md.plan_id
2629: and msi.organization_id = md.organization_id
3161: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),
3162: nvl(md.prev_subst_org, md.original_org_id),
3163: md.plan_id,md.original_inst_id)
3164: orig_item_desc
3165: from msc_system_items msi,
3166: msc_plans mp,
3167: msc_demands md,
3168: msc_sales_order_interface msoi
3169: where msoi.batch_id = p_batch_id