APPS.MSC_EXP_WF dependencies on MSC_SUPPLIER_FLEX_FENCES
Line 2329: FROM msc_supplier_flex_fences
2325: -- Get the tolerance information
2326: --dbms_output.put_line('Before the tolerance information');
2327: SELECT DISTINCT fence_days, tolerance_percentage
2328: BULK COLLECT INTO suptol.fence,suptol.tolerance 2329: FROM msc_supplier_flex_fences 2330: WHERE plan_id = arg_plan_id
2331: AND inventory_item_id = p_item_id
2332: AND organization_id = p_org_id
2333: AND sr_instance_id = p_inst_id