Oracle VCP- ASCP Staging Tables

select * FROM msc_st_calendars WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_workday_patterns WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_shift_times WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_calendar_exceptions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_shift_exceptions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_demand_classes WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_trading_partners WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_trading_partner_sites WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_location_associations WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_planners WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_units_of_measure WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_uom_conversions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_uom_class_conversions WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_system_items WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_category_sets WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_item_categories WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_resource_groups WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_department_resources WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_resource_shifts WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_routings WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_routing_operations WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_operation_resources WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_boms WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_bom_components WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_supplies WHERE sr_instance_code = '&enter_sr_instance_code' AND order_type = 18;

select * FROM msc_st_safety_stocks WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_item_suppliers WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM MSC_ST_ITEM_SOURCING WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM msc_st_interorg_ship_methods WHERE sr_instance_code = '&enter_sr_instance_code';

select * FROM MSC_ST_SR_LOOKUPS WHERE sr_instance_code = '&enter_sr_instance_code';