[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
854: p_uom_code,
855: p_operating_unit,
856: p_action
857: FROM msc_apps_instances mai, -- xml fix
858: msc_system_items msi,
859: msc_trading_partners mp,
860: msc_supplies s
861: WHERE msi.inventory_item_id = s.inventory_item_id
862: AND msi.plan_id = s.plan_id
915: p_uom_code,
916: p_operating_unit,
917: p_action
918: FROM msc_apps_instances mai, -- xml fix
919: msc_system_items msi,
920: msc_trading_partners mp,
921: msc_supplies s
922: WHERE msi.inventory_item_id = s.inventory_item_id
923: AND msi.plan_id = s.plan_id
1024: p_po_number,
1025: p_po_quantity,
1026: p_plan_id
1027: FROM msc_apps_instances mai,
1028: msc_system_items msi,
1029: msc_supplies s
1030: WHERE msi.inventory_item_id = s.inventory_item_id
1031: AND msi.plan_id = s.plan_id
1032: AND msi.organization_id = s.organization_id
1082: p_po_number,
1083: p_po_quantity,
1084: p_plan_id
1085: FROM msc_apps_instances mai,
1086: msc_system_items msi,
1087: msc_supplies s
1088: WHERE msi.inventory_item_id = s.inventory_item_id
1089: AND msi.plan_id = s.plan_id
1090: AND msi.organization_id = s.organization_id
1404:
1405: CURSOR source_item_c(l_inst_id number, l_org_id number,
1406: l_item_id number) IS
1407: select sr_inventory_item_id
1408: from msc_system_items msi
1409: where msi.plan_id = arg_plan_id
1410: and msi.organization_id =l_org_id
1411: and msi.sr_instance_id = l_inst_id
1412: and msi.inventory_item_id = l_item_id;
2471: s.po_line_id,
2472: s.implement_quantity,
2473: cal2.calendar_date
2474: from msc_supplies s,
2475: msc_system_items msi,
2476: msc_plans mp,
2477: msc_calendar_dates cal1,
2478: msc_calendar_dates cal2,
2479: msc_trading_partners mtp
2844: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2845: md.planned_arrival_date,
2846: md.intransit_lead_time
2847: from msc_demands md,
2848: msc_system_items msi
2849: where md.plan_id = p_plan_id
2850: and md.ship_set_id = p_ship_set_id
2851: and msi.plan_id = md.plan_id
2852: and msi.organization_id = md.organization_id
2872: md.sr_instance_id,
2873: nvl(md.planned_ship_date,md.dmd_satisfied_date),
2874: md.planned_arrival_date
2875: from msc_demands md,
2876: msc_system_items msi
2877: where md.plan_id = p_plan_id
2878: and md.arrival_set_id = p_arrival_set_id
2879: and msi.plan_id = md.plan_id
2880: and msi.organization_id = md.organization_id
3397: CURSOR PLANNER_C( p_plan_id in number, p_inventory_item_id in number,
3398: p_organization_id in number, p_instance_id in number) IS
3399: SELECT distinct pl.user_name
3400: FROM msc_planners pl,
3401: msc_system_items sys
3402: WHERE sys.plan_id = p_plan_id
3403: AND sys.organization_id = p_organization_id
3404: AND sys.sr_instance_id = p_instance_id
3405: AND sys.inventory_item_id = p_inventory_item_id
3440: msc_get_name.item_desc(nvl(md.prev_subst_item,md.original_item_id),
3441: nvl(md.prev_subst_org, md.original_org_id),
3442: md.plan_id,md.original_inst_id)
3443: orig_item_desc
3444: from msc_system_items msi,
3445: msc_plans mp,
3446: msc_demands md,
3447: msc_sales_order_interface msoi
3448: where msoi.batch_id = p_batch_id